Snowflake Certificate – Questions & Answers
A virtual Warehouse CANNOT be resized while queries are running
A. True
B. False ✔️Ans - False
Which of the following are options when creating a Virtual Warehouse?
A. Auto-suspend
B. Storage size
C. Auto-resume
D. Server count ✔️Ans - A,C
The warehouse cache may be reset if a running warehouse is suspended and
then resumed.
A. True
B. False ✔️Ans - 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 ✔️Ans - 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) ✔️Ans
- 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 ✔️Ans - 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 ✔️Ans - 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 ✔️Ans -
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; ✔️Ans - 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 ✔️Ans - 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 ✔️Ans - A,D
A virtual warehouse can resized at any time whether they are serving a query
or idle.
A. True
B. False ✔️Ans - 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 ✔️Ans - 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 ✔️Ans - D
Which minimum Snowflake license allows Multi cluster virtual warehouse
capability?
A. Standard
B. Business Critical
C. Enterprise
D. VPS ✔️Ans - C
What are the resources that a virtual warehouse provides? Select all that
apply.
A. CPU
B. Temporary Storage
C. Memory D. User Management ✔️Ans - 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 ✔️Ans - A,C,E
Snowflake does not start executing any queries on a new virtual warehouse
until all of the servers or failure server, are provisioned. servers, in case of
A. 25%
B. 50%
C. 75%
D. 90% ✔️Ans - B
Which of the following are options when created a new multi cluster virtual
warehouse. Select all that apply
A. MAX_CLUSTER_COUNT
B. SUSPEND_AND_RESUME
C. MIN_CLUSTER_COUNT
D. SCALING_POLICY ✔️Ans - A,C,D
What is correct about multi cluster virtual warehouses?
A. Only one multi cluster virtual warehouse can be created customer. per
Snowflake
B. Multi cluster virtual warehouses can not be suspended or resumed.
C. They will remove the additional clusters as query demand decreases.
D. They will add additional clusters automatically when under high query
workload which is beyond the current capacity ✔️Ans - C,D
You have a virtual warehouse named my_vwh which is sized as Medium. You
need the size of the virtual warehouse to be Large for future queries. What is
the best way to make this change.
A. Alter the existing virtual warehouse and change the size to Large (ALTER
WAREHOUSE my_vwh WAREHOUSE_SIZE=large)
B. Drop the existing virtual warehouse and create a new one with the required
parameters
C. It is not permitted to re-size a virtual warehouse once it has been created
✔️Ans - A
Virtual Warehouse credits are charged on what basis?
A virtual Warehouse CANNOT be resized while queries are running
A. True
B. False ✔️Ans - False
Which of the following are options when creating a Virtual Warehouse?
A. Auto-suspend
B. Storage size
C. Auto-resume
D. Server count ✔️Ans - A,C
The warehouse cache may be reset if a running warehouse is suspended and
then resumed.
A. True
B. False ✔️Ans - 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 ✔️Ans - 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) ✔️Ans
- 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 ✔️Ans - 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 ✔️Ans - 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 ✔️Ans -
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; ✔️Ans - 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 ✔️Ans - 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 ✔️Ans - A,D
A virtual warehouse can resized at any time whether they are serving a query
or idle.
A. True
B. False ✔️Ans - 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 ✔️Ans - 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 ✔️Ans - D
Which minimum Snowflake license allows Multi cluster virtual warehouse
capability?
A. Standard
B. Business Critical
C. Enterprise
D. VPS ✔️Ans - C
What are the resources that a virtual warehouse provides? Select all that
apply.
A. CPU
B. Temporary Storage
C. Memory D. User Management ✔️Ans - 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 ✔️Ans - A,C,E
Snowflake does not start executing any queries on a new virtual warehouse
until all of the servers or failure server, are provisioned. servers, in case of
A. 25%
B. 50%
C. 75%
D. 90% ✔️Ans - B
Which of the following are options when created a new multi cluster virtual
warehouse. Select all that apply
A. MAX_CLUSTER_COUNT
B. SUSPEND_AND_RESUME
C. MIN_CLUSTER_COUNT
D. SCALING_POLICY ✔️Ans - A,C,D
What is correct about multi cluster virtual warehouses?
A. Only one multi cluster virtual warehouse can be created customer. per
Snowflake
B. Multi cluster virtual warehouses can not be suspended or resumed.
C. They will remove the additional clusters as query demand decreases.
D. They will add additional clusters automatically when under high query
workload which is beyond the current capacity ✔️Ans - C,D
You have a virtual warehouse named my_vwh which is sized as Medium. You
need the size of the virtual warehouse to be Large for future queries. What is
the best way to make this change.
A. Alter the existing virtual warehouse and change the size to Large (ALTER
WAREHOUSE my_vwh WAREHOUSE_SIZE=large)
B. Drop the existing virtual warehouse and create a new one with the required
parameters
C. It is not permitted to re-size a virtual warehouse once it has been created
✔️Ans - A
Virtual Warehouse credits are charged on what basis?
