Exam (elaborations)
Snowflake Certificate – Questions & Answers
- Course
- Institution
Snowflake Certificate – Questions & Answers
[Show more]
Seller
Follow
LeCrae
Reviews received
Content preview
Snowflake Certificate – Questions & AnswersA 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?
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 LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $23.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76799 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now