Snowflake Study guides, Class notes & Summaries

DATA ENGINEERING PLATFORMS (MSCA 31012) Part B (Individual): Dimensional Modeling( Sakila ) , Insights Page 2 2. Download Sakila Snowflake dimensional data model (DDL) from canvas –{ 40 Points } a. Run the DDL & DML provided for the Sakila dimension model b. For the missing Fact table fact_rental create the DDL and the DML scripts to pull data from the Sakila ER model. Modify/improve the fact table script if you need more metrics for the Tableau report below ( F

Snowflake Certification Exam Complete 200+ Q&A 2023 (100% correct). True or False: Data Storage is independent from compute? True or False: All virtual warehouses have access to all data? True or False: Al interactions with data are initialized through the services layer? True or False: Multi-Cluster Warehouses support high concurrency? True or False: Warehouses can be dynamically expanded to adjust to workloads? Which layer provides centralized services for the data wareh...

True or False: Data Storage is independent from compute? - correct answer True True or False: All virtual warehouses have access to all data? - correct answer True True or False: Al interactions with data are initialized through the services layer? - correct answer True True or False: Multi-Cluster Warehouses support high concurrency? - correct answer True True or False: Warehouses can be dynamically expanded to adjust to workloads? - correct answer True Which layer prov...

Snowflake's Founders? - correct answer Thierry and Benoit What was the founder's initial purpose? - correct answer to re-architect data storage in the cloud from scratch What does Snowflake's architecture support? - correct answer 1. fault isolation 2. elastic compute/adapting based on demand based on usage, not version license 4. infinitely scalable storage 5. performance isolation What does multi-layered architecture allow for? - correct answer 1. Performance 2. Scalabilit...

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 answer 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) ROLE...

Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is: A. Micro-partitions B. Clustering keys Most Voted C. Key partitions D. Clustered partitions correct answers Clustering Keys Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.) A. Custom B. Economy C. Optimized D. Standard correct answers BD True or False: A single database can exist in more than one Snowflake account. A. True B. ...

True or False: Data Storage is independent from compute? - Answer- True True or False: All virtual warehouses have access to all data? - Answer- True True or False: Al interactions with data are initialized through the services layer? - Answer- True True or False: Multi-Cluster Warehouses support high concurrency? - Answer- True True or False: Warehouses can be dynamically expanded to adjust to workloads? - Answer- True Which layer provides centralized services for the data wareho...

What are the 3 Cloud Providers available for Snowflake - correct 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) - correct answer True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data - correct answer A) Multi-Cluster, Shared Data What are the 3 components...

Multi-cluster shared data - correct answer Which of the following terms best describes Snowflake's database architecture? Pruning - correct answer What technique does Snowflake use to limit the number of micro-partitions scanned by each query? All data in Snowflake is encrypted - correct answer Which of the following statements apply to Snowflake in terms of security? Select all that apply. Snowflake leverages a role-based access control model - correct answer Which of the foll...

The Snowflake credit usage for multi cluster virtual warehouses is based on -the value that is configured as the maximum in the multi cluster virtual warehouse configuration -the number of clusters running during each hour for the warehouse is running - correct answer the number of clusters running during each hour for the warehouse is running For a snowflake session, more than one virtual warehouse can be specified at a time for executing a query True/False - correct answer False ...

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