Snowflake SnowPro Certification Study Guide;
Questions and Answers
What are the 3 Cloud Providers available for Snowflake Correct Ans-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 Ans-True
How does Snowflake describe their architecture?
A) Multi-Cluster, Shared Data
B) Single-Cluster, Shared Data Correct Ans-A) Multi-Cluster, Shared Data
What are the 3 components of Snowflake's architecture (both the name and descriptor)
Correct Ans-1) Storage - Databases
2) Compute - Virtual Warehouses
3) Cloud Services - Front End
What are the Cloud Object Storage options? Correct Ans-1) AWS S3
, Snowflake SnowPro Certification Study Guide;
Questions and Answers
2) Azure Blobs
3) GCP
How are storage costs calculated? Correct Ans-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 Ans-1) AWS EC2
2) Azure Compute
Compute can't scale out as queries are running (T/F) Correct Ans-False
Which services does Cloud Services provide? Correct Ans-1) Security Management
2) Infrastructure Management
3) Metadata Management
4) Query Optimization
, Snowflake SnowPro Certification Study Guide;
Questions and Answers
Are Snowflake's Storage (DB) and Compute (WH) layers
A) Separate and Independent
B) Together and Dependent Correct Ans-A) Separate and Independent
In addition to multiple Virtual Warehouses, Multi-Cluster means individual Virtual
Warehouses can... Correct Ans-Scale up or down automatically
Multi-Cluster turn off clusters when activity slows down (T/F) Correct Ans-True
Snowflake uses ANSI-SQL (T/F) Correct Ans-True
What is Snowflake's semi-structured data type called? Correct Ans-VARIANT
What are the three types of caching in Snowflake? Correct Ans-1) Warehouse
2) Metadata
3) Results
, Snowflake SnowPro Certification Study Guide;
Questions and Answers
All cache data are cleared if the underlying data changes (T/F) Correct Ans-True
What does Warehouse Caching do? When is the data invalidated? Where does it live?
Correct Ans-Stores data that's been loaded into Virtual Warehouses during querying. The
data is invalidated if it's suspended. Lives in Compute.
What does Metadata Caching do? Where does it live? Correct Ans-It stores various info
about tables. It lives in the Cloud Services layer.
What does Results Caching do? Where does it live? Correct Ans-It stores results of queries
that have been executed within the past 24 hours (assuming underlying data hasn't changed).
It lives in the Cloud Services Layer.
A customer needs to have a preexisting account with AWS or Azure in order to have a
Snowflake account (T/F) Correct Ans-False
What are Availability Zones? Correct Ans-Data centers in certain regions
Questions and Answers
What are the 3 Cloud Providers available for Snowflake Correct Ans-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 Ans-True
How does Snowflake describe their architecture?
A) Multi-Cluster, Shared Data
B) Single-Cluster, Shared Data Correct Ans-A) Multi-Cluster, Shared Data
What are the 3 components of Snowflake's architecture (both the name and descriptor)
Correct Ans-1) Storage - Databases
2) Compute - Virtual Warehouses
3) Cloud Services - Front End
What are the Cloud Object Storage options? Correct Ans-1) AWS S3
, Snowflake SnowPro Certification Study Guide;
Questions and Answers
2) Azure Blobs
3) GCP
How are storage costs calculated? Correct Ans-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 Ans-1) AWS EC2
2) Azure Compute
Compute can't scale out as queries are running (T/F) Correct Ans-False
Which services does Cloud Services provide? Correct Ans-1) Security Management
2) Infrastructure Management
3) Metadata Management
4) Query Optimization
, Snowflake SnowPro Certification Study Guide;
Questions and Answers
Are Snowflake's Storage (DB) and Compute (WH) layers
A) Separate and Independent
B) Together and Dependent Correct Ans-A) Separate and Independent
In addition to multiple Virtual Warehouses, Multi-Cluster means individual Virtual
Warehouses can... Correct Ans-Scale up or down automatically
Multi-Cluster turn off clusters when activity slows down (T/F) Correct Ans-True
Snowflake uses ANSI-SQL (T/F) Correct Ans-True
What is Snowflake's semi-structured data type called? Correct Ans-VARIANT
What are the three types of caching in Snowflake? Correct Ans-1) Warehouse
2) Metadata
3) Results
, Snowflake SnowPro Certification Study Guide;
Questions and Answers
All cache data are cleared if the underlying data changes (T/F) Correct Ans-True
What does Warehouse Caching do? When is the data invalidated? Where does it live?
Correct Ans-Stores data that's been loaded into Virtual Warehouses during querying. The
data is invalidated if it's suspended. Lives in Compute.
What does Metadata Caching do? Where does it live? Correct Ans-It stores various info
about tables. It lives in the Cloud Services layer.
What does Results Caching do? Where does it live? Correct Ans-It stores results of queries
that have been executed within the past 24 hours (assuming underlying data hasn't changed).
It lives in the Cloud Services Layer.
A customer needs to have a preexisting account with AWS or Azure in order to have a
Snowflake account (T/F) Correct Ans-False
What are Availability Zones? Correct Ans-Data centers in certain regions
