B snowflake - Study guides, Class notes & Summaries

Snowflake Certification study guide already graded A Which of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend 1) Adds clusters automatically based on query activity 3) Scales down when query activity slows Which of the following terms best describes Snowflake's data...

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

Snowflake Certification Test Questions with Complete Solutions Graded A+ Snowflake has three types of caching to optimize performance. Select the three types of caches from the list: A) Server B) Warehouse C) Client D) Results E) Security F) Metadata G) Database H) User B Warehouse, D Results, F Metadata True or False: Data Storage is independent from compute? True True or False: All virtual warehouses have access to all data? True True or False: Al interactions with data are in...

Which of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse correct answers A. Compress the source files B. Split large files into smaller files C. Isolate data loading workload into its own virtual warehosue how query processing is done in Snowflake? A. It is done using storage ...

Snowflake SnowPro Certification - Practice Exam Questions and Answers 100% Verified 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 A, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from the ...

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 object do you need to create to fetch data from private cloud locations? A. Storage Integration B. Only Stage C. Nothing, just pass source URL to a query D. Storage Connection correct answers A. Storage Integration What parameter should be changed to modify table retention time? A. DATA_RETENTION B. DATA_RETENTION_TIME_IN_DAYS C. DATA_RETENTION_TIME D. DATA_RETENTION_PERIOD correct answers B. DATA_RETENTION_TIME_IN_DAYS If a user has the role ACCOUNTADMIN assigned it's a...

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

Which of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse - Answer- A. Compress the source files B. Split large files into smaller files C. Isolate data loading workload into its own virtual warehosue how query processing is done in Snowflake? A. It is done using storage layer ...