Exam (elaborations)
Snowflake SnowPro Certification Study Guide; Questions and Answers
- Course
- Institution
Snowflake SnowPro Certification Study Guide; Questions and Answers
[Show more]
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TheeGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now