Snowflake SnowPro Certification Study
Guide Exam Questions
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 Snowflake's architecture (both the name
and descriptor) - Correct Answers ✅1) Storage - Databases
2) Compute - Virtual Warehouses
3) Cloud Services - Front End
What are the Cloud Object Storage options? - Correct Answers ✅1)
AWS S3
2) Azure Blobs
3) GCP
,Snowflake SnowPro Certification Study
Guide Exam Questions
How are storage costs calculated? - Correct Answers ✅A daily
average of all compressed data storage, including data stored according
to Time Travel retention policy and failsafe procedures
Which Microsoft and Amazon systems does Compute leverage? -
Correct Answers ✅1) AWS EC2
2) Azure Compute
Compute can't scale out as queries are running (T/F) - Correct Answers
✅False
Which services does Cloud Services provide? - Correct Answers ✅1)
Security Management
2) Infrastructure Management
3) Metadata Management
4) Query Optimization
Are Snowflake's Storage (DB) and Compute (WH) layers
A) Separate and Independent
B) Together and Dependent - Correct Answers ✅A) Separate and
Independent
, Snowflake SnowPro Certification Study
Guide Exam Questions
In addition to multiple Virtual Warehouses, Multi-Cluster means
individual Virtual Warehouses can... - Correct Answers ✅Scale up or
down automatically
Multi-Cluster turn off clusters when activity slows down (T/F) - Correct
Answers ✅True
Snowflake uses ANSI-SQL (T/F) - Correct Answers ✅True
What is Snowflake's semi-structured data type called? - Correct
Answers ✅VARIANT
What are the three types of caching in Snowflake? - Correct Answers
✅1) Warehouse
2) Metadata
3) Results
All cache data are cleared if the underlying data changes (T/F) - Correct
Answers ✅True
What does Warehouse Caching do? When is the data invalidated?
Where does it live? - Correct Answers ✅Stores data that's been
Guide Exam Questions
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 Snowflake's architecture (both the name
and descriptor) - Correct Answers ✅1) Storage - Databases
2) Compute - Virtual Warehouses
3) Cloud Services - Front End
What are the Cloud Object Storage options? - Correct Answers ✅1)
AWS S3
2) Azure Blobs
3) GCP
,Snowflake SnowPro Certification Study
Guide Exam Questions
How are storage costs calculated? - Correct Answers ✅A daily
average of all compressed data storage, including data stored according
to Time Travel retention policy and failsafe procedures
Which Microsoft and Amazon systems does Compute leverage? -
Correct Answers ✅1) AWS EC2
2) Azure Compute
Compute can't scale out as queries are running (T/F) - Correct Answers
✅False
Which services does Cloud Services provide? - Correct Answers ✅1)
Security Management
2) Infrastructure Management
3) Metadata Management
4) Query Optimization
Are Snowflake's Storage (DB) and Compute (WH) layers
A) Separate and Independent
B) Together and Dependent - Correct Answers ✅A) Separate and
Independent
, Snowflake SnowPro Certification Study
Guide Exam Questions
In addition to multiple Virtual Warehouses, Multi-Cluster means
individual Virtual Warehouses can... - Correct Answers ✅Scale up or
down automatically
Multi-Cluster turn off clusters when activity slows down (T/F) - Correct
Answers ✅True
Snowflake uses ANSI-SQL (T/F) - Correct Answers ✅True
What is Snowflake's semi-structured data type called? - Correct
Answers ✅VARIANT
What are the three types of caching in Snowflake? - Correct Answers
✅1) Warehouse
2) Metadata
3) Results
All cache data are cleared if the underlying data changes (T/F) - Correct
Answers ✅True
What does Warehouse Caching do? When is the data invalidated?
Where does it live? - Correct Answers ✅Stores data that's been
