SNOWFLAKE SNOWPRO CERTIFICATION EXAM 2025

SNOWFLAKE SNOWPRO CERTIFICATION
EXAM 2025

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



How does Snowflake describe their architecture?

A) Multi-Cluster, Shared Data

B) Single-Cluster, Shared Data - ✅✅✅CORRECT -A) Multi-Cluster, Shared Data



What are the 3 components of Snowflake's architecture (both the name and descriptor) -
✅✅✅CORRECT -1) Storage - Databases

2) Compute - Virtual Warehouses

3) Cloud Services - Front End



What are the Cloud Object Storage options? - ✅✅✅CORRECT -1) AWS S3

2) Azure Blobs

3) GCP



How are storage costs calculated? - ✅✅✅CORRECT -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 -1) AWS EC2

2) Azure Compute

,Compute can't scale out as queries are running (T/F) - ✅✅✅CORRECT -False



Which services does Cloud Services provide? - ✅✅✅CORRECT -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 -A) Separate and Independent



In addition to multiple Virtual Warehouses, Multi-Cluster means individual Virtual Warehouses can... -
✅✅✅CORRECT -Scale up or down automatically



Multi-Cluster turn off clusters when activity slows down (T/F) - ✅✅✅CORRECT -True



Snowflake uses ANSI-SQL (T/F) - ✅✅✅CORRECT -True



What is Snowflake's semi-structured data type called? - ✅✅✅CORRECT -VARIANT



What are the three types of caching in Snowflake? - ✅✅✅CORRECT -1) Warehouse

2) Metadata

3) Results



All cache data are cleared if the underlying data changes (T/F) - ✅✅✅CORRECT -True



What does Warehouse Caching do? When is the data invalidated? Where does it live? -
✅✅✅CORRECT -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 -It stores various info about
tables. It lives in the Cloud Services layer.



What does Results Caching do? Where does it live? - ✅✅✅CORRECT -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 -False



What are Availability Zones? - ✅✅✅CORRECT -Data centers in certain regions



How many availability zones is your data replicated in? - ✅✅✅CORRECT -3 data zones in a region



What does it mean by "automatic" micro-partitions - ✅✅✅CORRECT -A partition scheme doesn't
need to be defined up front. Snowflake determines and creates it.



Data partitioning is automatically completed in the natural ingestion order (T/F) - ✅✅✅CORRECT -
True



New Partitions are based on physical properties (T/F) - ✅✅✅CORRECT -True



How does Snowflake optimize storage of semi-structured data? - ✅✅✅CORRECT -Repeated
elements within the strings



How far back does the Time Travel protection go? - ✅✅✅CORRECT -90 days



Zero-Copy Cloning operates on more than just the metadata (T/F) - ✅✅✅CORRECT -False - It's a
metadata-only operation



There's a difference in storage cost allocation between structured and semi-structured data (T/F) -
✅✅✅CORRECT -False - There's no difference