Snowflake Certification v1 & v2 Exam (Latest
2025/2026) – Verified Questions with 100%
Correct Answers
This document provides a comprehensive set of verified questions with 100% correct
answers for the Snowflake Certification v1 v2 Exam 2025/2026. It covers all essential
domains, including data warehousing, SQL, virtual warehouses, security and governance,
query performance optimization, storage and compute, and cloud data solutions.
Expert-verified and aligned with the latest exam updates, this study resource ensures
candidates are fully prepared for career advancement and certification success.
A virtual Warehouse CANNOT be resized while queries are running
A. True
B. False
False
Which of the following are options when creating a Virtual
Warehouse?
A. Auto-suspend
B. Storage size
C. Auto-resume
D. Server count
A,C
The warehouse cache may be reset if a running warehouse is
suspended and then resumed.
A. True
B. False
B
The Snowflake credit usage for multi cluster virtual warehouses is
based on? Select all that apply.
A. The number of hour for the warehouse is running
B. The number of clusters running during each hour for the
,warehouse is running
C. The value that is configured as the maximum in the multi cluster
virtual warehouse configuration
D. None of above
A,B
Not all Snowflake Editions have Elastic Data Warehousing. Check all
the Snowflake editions that have Elastic Data Warehousing enabled.
A. Enterprise Edition
B. Basic Edition
C. Virtual Private Snowflake
D. Standard Edition
E. Business Critical Edition (formerly Enterprise for Sensitive Data)
A,C,E
View the screenshot below and check all that apply.
A. The account shown is Snowflake's Enterprise Edition or above.
B. The account shown HAS multi-cluster warehousing.
C. The account shown DOES NOT have multi-cluster warehousing.
D. The account shown is Snowflake's Standard Edition
A,B
When configuring a Warehouse using a Snowflake edition that has
Elastic Data Warehousing enabled, what facets or components will
you need to configure that are not needed in accounts where Elastic
Data Warehousing is not enabled. (Choose two).
A. Scaling Policy
B. Minimum and Maximum Clusters
C. Auto-Resume
D. Auto-Suspend
A,B
The following statements have to do with the scaling of warehouses.
Check all true statements.
A. Scaling a warehouse UP will decrease the number of clusters.
B. Scaling a warehouse DOWN will decrease the number of servers.
C. Scaling a warehouse OUT will increase the number of clusters.
D. Scaling a warehouse IN will decrease the number of clusters
,B,C,D
You are creating a fresh virtual warehouse and you want this to
running all the time. What is the correct syntax for creating such a
virtual warehouse? Assume the name of the virtual warehouse will
be demo_wh
A. create or replace warehouse demo_wh warehouse_size=large
auto_suspend=0;
C. create or replace warehouse demo_wh warehouse_size=large
auto_suspend=null;
B. create or replace warehouse demo_wh warehouse_size=large
auto_suspend=-1; create or replace warehouse demo_wh
warehouse_size=large
D. never_suspend=true;
A,C
For a snowflake session, more than one virtual warehouse can be
specified at a time for executing a query.
A. True
B. False
B
Which of the following are options when creating a new virtual
warehouse. Select all that apply
A. auto_suspend
B. resume_on_demand
C. suspend_and_resume
D. auto_resume
A,D
A virtual warehouse can resized at any time whether they are
serving a query or idle.
A. True
B. False
A
Multi cluster virtual warehouses are designed to handle ... Select all
that apply
A. Large Complex Queries
, B. Queuing issues
C. Large number of concurrent queries
D. Large number of concurrent users
B,C,D
For a multi cluster virtual warehouse the administrator set the
minimum cluster count and the maximum cluster count to different
values. This can be best described as ?
A. Scaling Tuning
B. Fixed Scaling
C. Resizing Scaling
D. Auto Scaling
D
Which minimum Snowflake license allows Multi cluster virtual
warehouse capability?
A. Standard
B. Business Critical
C. Enterprise
D. VPS
C
What are the resources that a virtual warehouse provides? Select all
that apply.
A. CPU
B. Temporary Storage
C. Memory D. User Management
A,B,C
Which of the following are valid parameters when create a new
virtual warehouse? Select all that apply.
A. WAREHOUSE_SIZE
B. CPU_COUNT
C. AUTO_RESUME
D. RAM_SIZE
E. AUTO SUSPEND
A,C,E
2025/2026) – Verified Questions with 100%
Correct Answers
This document provides a comprehensive set of verified questions with 100% correct
answers for the Snowflake Certification v1 v2 Exam 2025/2026. It covers all essential
domains, including data warehousing, SQL, virtual warehouses, security and governance,
query performance optimization, storage and compute, and cloud data solutions.
Expert-verified and aligned with the latest exam updates, this study resource ensures
candidates are fully prepared for career advancement and certification success.
A virtual Warehouse CANNOT be resized while queries are running
A. True
B. False
False
Which of the following are options when creating a Virtual
Warehouse?
A. Auto-suspend
B. Storage size
C. Auto-resume
D. Server count
A,C
The warehouse cache may be reset if a running warehouse is
suspended and then resumed.
A. True
B. False
B
The Snowflake credit usage for multi cluster virtual warehouses is
based on? Select all that apply.
A. The number of hour for the warehouse is running
B. The number of clusters running during each hour for the
,warehouse is running
C. The value that is configured as the maximum in the multi cluster
virtual warehouse configuration
D. None of above
A,B
Not all Snowflake Editions have Elastic Data Warehousing. Check all
the Snowflake editions that have Elastic Data Warehousing enabled.
A. Enterprise Edition
B. Basic Edition
C. Virtual Private Snowflake
D. Standard Edition
E. Business Critical Edition (formerly Enterprise for Sensitive Data)
A,C,E
View the screenshot below and check all that apply.
A. The account shown is Snowflake's Enterprise Edition or above.
B. The account shown HAS multi-cluster warehousing.
C. The account shown DOES NOT have multi-cluster warehousing.
D. The account shown is Snowflake's Standard Edition
A,B
When configuring a Warehouse using a Snowflake edition that has
Elastic Data Warehousing enabled, what facets or components will
you need to configure that are not needed in accounts where Elastic
Data Warehousing is not enabled. (Choose two).
A. Scaling Policy
B. Minimum and Maximum Clusters
C. Auto-Resume
D. Auto-Suspend
A,B
The following statements have to do with the scaling of warehouses.
Check all true statements.
A. Scaling a warehouse UP will decrease the number of clusters.
B. Scaling a warehouse DOWN will decrease the number of servers.
C. Scaling a warehouse OUT will increase the number of clusters.
D. Scaling a warehouse IN will decrease the number of clusters
,B,C,D
You are creating a fresh virtual warehouse and you want this to
running all the time. What is the correct syntax for creating such a
virtual warehouse? Assume the name of the virtual warehouse will
be demo_wh
A. create or replace warehouse demo_wh warehouse_size=large
auto_suspend=0;
C. create or replace warehouse demo_wh warehouse_size=large
auto_suspend=null;
B. create or replace warehouse demo_wh warehouse_size=large
auto_suspend=-1; create or replace warehouse demo_wh
warehouse_size=large
D. never_suspend=true;
A,C
For a snowflake session, more than one virtual warehouse can be
specified at a time for executing a query.
A. True
B. False
B
Which of the following are options when creating a new virtual
warehouse. Select all that apply
A. auto_suspend
B. resume_on_demand
C. suspend_and_resume
D. auto_resume
A,D
A virtual warehouse can resized at any time whether they are
serving a query or idle.
A. True
B. False
A
Multi cluster virtual warehouses are designed to handle ... Select all
that apply
A. Large Complex Queries
, B. Queuing issues
C. Large number of concurrent queries
D. Large number of concurrent users
B,C,D
For a multi cluster virtual warehouse the administrator set the
minimum cluster count and the maximum cluster count to different
values. This can be best described as ?
A. Scaling Tuning
B. Fixed Scaling
C. Resizing Scaling
D. Auto Scaling
D
Which minimum Snowflake license allows Multi cluster virtual
warehouse capability?
A. Standard
B. Business Critical
C. Enterprise
D. VPS
C
What are the resources that a virtual warehouse provides? Select all
that apply.
A. CPU
B. Temporary Storage
C. Memory D. User Management
A,B,C
Which of the following are valid parameters when create a new
virtual warehouse? Select all that apply.
A. WAREHOUSE_SIZE
B. CPU_COUNT
C. AUTO_RESUME
D. RAM_SIZE
E. AUTO SUSPEND
A,C,E
