Snowflake
ADA-C01 · Question #34
ADA-C01 Question #34: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Question
A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size. Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?
Options
- ACreate a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the
- BCreate a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-
- CCreate a standard X-Large warehouse, which is equivalent to four small clusters. Set the
- DCreate four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.