Snowflake Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about Snowflake? On this page you'll find 437 study documents about Snowflake.
Popular textbooks 'Snowflake'
All 437 results
Sort by
-
DATA ENGINEERING PLATFORMS (MSCA 31012
- Exam (elaborations) • 10 pages • 2023
-
- $9.99
- 2x sold
- + learn more
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).
- Summary • 26 pages • 2023
-
- $11.49
- 1x sold
- + learn more
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...
-
Snowflake Certification exam 2024 with 100% correct answers
- Exam (elaborations) • 37 pages • 2024
-
Available in package deal
-
- $16.49
- + learn more
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 exam 2024 with 100% correct answers
- Exam (elaborations) • 18 pages • 2024
-
Available in package deal
-
- $16.49
- + learn more
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...
-
Snowflake SnowPro Certification exam 2024 with 100% correct answers
- Exam (elaborations) • 20 pages • 2024
-
Available in package deal
-
- $16.49
- + learn more
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...
Fear of missing out? Then don’t!
-
SNOWFLAKE CERTIFICATION EXAM
- Exam (elaborations) • 26 pages • 2023
-
Available in package deal
-
- $12.49
- + learn more
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...
-
Snowflake || with 100% Errorless Answers
- Exam (elaborations) • 65 pages • 2024
-
Available in package deal
-
- $15.49
- + learn more
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. ...
-
Snowflake SnowPro Certification exam 2024 with 100% correct answers
- Exam (elaborations) • 18 pages • 2024
-
Available in package deal
-
- $16.49
- + learn more
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...
-
Snowflake Exam Study Set Questions and Answers 100% Pass
- Exam (elaborations) • 40 pages • 2023
- Available in package deal
-
- $10.99
- + learn more
Snowflake Exam Study Set Questions and Answers 100% Pass 
True or false: A table in Snowflake can contain both a variant columns and a timestamp. True 
True or false: The warehouse cache may be reset if a running warehouse is suspended and then resumed. True 
Which of the following are true of Multi-Cluster warehouses? Select all that apply. Adds clusters automatically based on query activity; Scales down when query activity slows 
Which of the following are options when creating a Virtual Wareh...
-
Snowflake Certification Q&A
- Exam (elaborations) • 16 pages • 2023
-
Available in package deal
-
- $12.49
- + learn more
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 ...
-
Snowflakes Preparation Exam 2024 with 100% correct answers
- Exam (elaborations) • 18 pages • 2024
-
Available in package deal
-
- $14.49
- + learn more
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...
Do you wonder why so many students wear nice clothes, have money to spare and enjoy tons of free time? Well, they sell on Stuvia! Imagine your study notes being downloaded a dozen times for $15 each. Every. Single. Day. Discover all about earning on Stuvia