Question 331 · 1323 in bank
A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Show answer
Answer: B
COF-C02AssociateSnowflakeAll questions freePage 34 of 133
COF-C02 practice questions 331–340
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
Official study references
1323 questions in this bank
Free access · progress saved on this device
Question 332 · 1323 in bank
Select 3What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
Show answer
Answer: ABD
Question 333 · 1323 in bank
How long is the Fail-safe period for temporary and transient tables?
Show answer
Answer: A
Question 334 · 1323 in bank
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Show answer
Answer: B
Question 335 · 1323 in bank
How does Snowflake Fail-safe protect data in a permanent table?
Show answer
Answer: C
Question 336 · 1323 in bank
A virtual warehouse is created using the following command: Create warehouse my_WH with - warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
Show answer
Answer: C
Explanation
We can see that queries are queued starting from 4 queries running. Later 6 queries are running in concurrency. So queries are queued not for reaching the max possible number of queries, but for reaching the max Cluster utilization. Therefor, the best solution is to scale out (Answer C)
Source: Adapted from community discussion — NabilR
Question 337 · 1323 in bank
Which minimum Snowflake edition allows for a dedicated metadata store?
Show answer
Answer: D
References
Question 338 · 1323 in bank
Select 2Network policies can be set at which Snowflake levels? (Choose two.)
Show answer
Answer: CE
References
Question 339 · 1323 in bank
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
Show answer
Answer: D
Explanation
A is the correct answer. Ref: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html Resizing a warehouse generally improves query performance, particularly for larger, more complex queries. It can also help reduce the queuing that occurs if a warehouse does not have enough compute resources to process all the queries that are submitted concurrently. Note that warehouse resizing is not intended for handling concurrency issues; instead, use additional warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available for your account).
Source: Adapted from community discussion — SteveKarr
Question 340 · 1323 in bank
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
Show answer
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 331. 1323 questions available.
About this question bank
Version 1.0.0. How we source questions