Snowflake
ADA-C01 · Question #60
ADA-C01 Question #60: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #60. The question stem and answer options stay visible for context.
Question
Two different roles are running queries on a production database. The queries are similar in complexity and duration, and there is generally about 3 minutes of idle time between queries. Typically, there are 2 or 3 queries running at a time for each role. Users in the Finance role are querying one set of tables, and users in the Engineering role are querying a different set of tables. What is the optimal approach to set up the virtual warehouse(s) based on this scenario?
Options
- AEach role should have its own warehouse with a short auto-suspend (less than 10 seconds) to
- BThe two roles should share a warehouse since each role's queries are similar in complexity and
- CThe two roles should share a warehouse with a short auto-suspend (less than 10 seconds) to
- DEach role should have its own virtual warehouse to make efficient use of caching.
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.