Snowflake snowpro - Study guides, Class notes & Summaries

Snowflake SnowPro Certification Study Guide Questions and Answers Graded A+ What are the 3 Cloud Providers available for Snowflake 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data A) Multi-Cluster, Shared Data What ar...

Snowflake SnowPro Certification Study Guide Exam Questions And Answers What are the 3 Cloud Providers available for Snowflake - ANS 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) - ANS True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data - ANS A) Multi-Cl...

You own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... A) Grant USAGE on D1 B) Grant SELECT on D1 C) Grant USAGE on S1 D) Grant SELECT on S1 E) Grant USAGE on T1 F) Grant SELECT on T1 correct answers A, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from the roles given: A) ACCOUNTADMIN B) SYSADMIN C) AUDITOR D) ROLEADM...

What are the 3 Cloud Providers available for Snowflake - Answer- 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) - Answer- True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data - Answer- A) Multi-Cluster, Shared Data What are the 3 components of Snowflake's architectu...

What are the 3 Cloud Providers available for Snowflake correct answers 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) correct answers True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data correct answers A) Multi-Cluster, Shared Data What are the 3 components of Snowf...

Snowflake SnowPro Certification Study Guide Exam – Q’s and A’s

Snowflake SnowPro Certification Study Guide Exam – Q’s and A’s

True or False: A single database can exist in more than one Snowflake account. correct answersB. False A database is a logical grouping of schemas. Each database belongs to a single Snowflake account. Which of the following roles is recommended to be used to create and manage users and roles? A. SYSADMIN B. SECURITYADMIN C. PUBLIC D. ACCOUNTADMIN correct answersD. ACCOUNTADMIN By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user sho...

How many times can a share be consumed by a single account? Once. "A share can only be consumed once per account." What is Federated Authentication? Federated Authentication enables users to connect using SSO via an external SAML 2.0 compliment identity provider (IdP). What is the defn of PaaS? Platform as a Service. You manage only the applications and data. Everything else is managed by the vendor. What are the three layers of Snowflake, bottom to top? Database Stora...