Study online at https://quizlet.com/_7ygrjb
1) AWS - a provider since inception
2) Azure Cloud Platforms - generally
What are the 3 Cloud Providers available
available as of Sept. 2018
for Snowflake
3) Google Cloud Platform - trialed late
2019
Snowflake is currently the only DW built
True
for the cloud (T/F)
How does Snowflake describe their ar-
chitecture?
A) Multi-Cluster, Shared Data
A) Multi-Cluster, Shared Data
B) Single-Cluster, Shared Data
What are the 3 components of 1) Storage - Databases
Snowflake's architecture (both the name 2) Compute - Virtual Warehouses
and descriptor) 3) Cloud Services - Front End
1) AWS S3
What are the Cloud Object Storage op-
2) Azure Blobs
tions?
3) GCP
A daily average of all compressed data
storage, including data stored according
How are storage costs calculated?
to Time Travel retention policy and fail-
safe procedures
Which Microsoft and Amazon systems 1) AWS EC2
does Compute leverage? 2) Azure Compute
Compute can't scale out as queries are
False
running (T/F)
1) Security Management
Which services does Cloud Services 2) Infrastructure Management
provide? 3) Metadata Management
4) Query Optimization
Are Snowflake's Storage (DB) and Com-
pute (WH) layers
A) Separate and Independent
A) Separate and Independent
B) Together and Dependent
Scale up or down automatically
, Snowflake SnowPro Certification Study Guide
Study online at https://quizlet.com/_7ygrjb
In addition to multiple Virtual Warehous-
es, Multi-Cluster means individual Virtual
Warehouses can...
Multi-Cluster turn off clusters when activ-
True
ity slows down (T/F)
Snowflake uses ANSI-SQL (T/F) True
What is Snowflake's semi-structured
VARIANT
data type called?
1) Warehouse
What are the three types of caching in
2) Metadata
Snowflake?
3) Results
All cache data are cleared if the underly-
True
ing data changes (T/F)
Stores data that's been loaded into Vir-
What does Warehouse Caching do?
tual Warehouses during querying. The
When is the data invalidated? Where
data is invalidated if it's suspended. Lives
does it live?
in Compute.
What does Metadata Caching do? It stores various info about tables. It lives
Where does it live? in the Cloud Services layer.
It stores results of queries that have been
What does Results Caching do? Where executed within the past 24 hours (as-
does it live? suming 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 False
have a Snowflake account (T/F)
What are Availability Zones? Data centers in certain regions
How many availability zones is your data
3 data zones in a region
replicated in?
A partition scheme doesn't need to be
What does it mean by "automatic" mi-
defined up front. Snowflake determines
cro-partitions
and creates it.
Data partitioning is automatically com-
True
pleted in the natural ingestion order (T/F)