Snowflake Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about Snowflake? On this page you'll find 442 study documents about Snowflake.
Popular textbooks 'Snowflake'
All 442 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...
-
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 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 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 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...
-
Snowflake Practice Test 1 exam 2024 with 100% correct answers
- Exam (elaborations) • 16 pages • 2024
-
Available in package deal
-
- $16.49
- + learn more
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 ...