Question 181 · 1323 in bank
What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?
Show answer
Answer: B
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?
Answer: B
Which feature is supported in column-level security in Snowflake?
Answer: D
A network policy applied at the user level takes precedence over a network policy applied to what Snowflake object?
Answer: B
Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?
Answer: D
Using which object-level parameters will help limit query processing and concurrency slowdowns? (Choose two.)
Answer: CD
Which of the following statements would be used to export/unload data from Snowflake?
Answer: A
How does Snowflake optimize queries on tables by leveraging the sorting and storage of data within micro-partitions?
Answer: B
What role should be used when creating a new user?
Answer: C
Which ACCOUNT_USAGE view will identify long-running queries?
Answer: C
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Answer: A
Signed up for free Snowflake account. Created X-Small and 4X Virtual Warehouse using web interface. X-Small took 96 ms, while 4X took 105 ms. You can validate it in Activity -> Query History.
Source: Adapted from community discussion — Dilbert
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 181. 1323 questions available.
Version 1.0.0. How we source questions