Snowflake snowpro - Study guides, Class notes & Summaries

Snowflake Snowpro Core Certification – Q&A

Snowflake SnowPro Certification - Practice Exams Questions With Solutions 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 - ANS A, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from...

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...

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...

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

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...

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...

Snowflake SnowPro-Core Certification Exam Questions and Answers 100% CorrectSnowflake SnowPro-Core Certification Exam Questions and Answers 100% CorrectSnowflake SnowPro-Core Certification Exam Questions and Answers 100% CorrectSnowflake SnowPro-Core Certification Exam Questions and Answers 100% CorrectCorrect True or False: Snowflake charges additional fees to Data providers for each share they create. - ANSWER - A. True B. False Answer: A