• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 14 pages
Case

Snowflake SnowPro Certification Study Guide

Document preview thumbnail
Preview 2 out of 14 pages

What are the 3 Cloud Providers available for Snowflake 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) True

Content preview

Snowflake SnowPro Certification Study Guide
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)

Document information

Uploaded on
December 4, 2024
Number of pages
14
Written in
2024/2025
Type
Case
Professor(s)
Snowflake
Grade
A+
$9.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Exammate
2.7
(10)
Sold
65
Followers
8
Items
3181
Last sold
1 month ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions