Snowflake
ADA-C01 · Question #60
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…
The correct answer is D. Each role should have its own virtual warehouse to make efficient use of caching. See the full explanation below for the reasoning.
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.
How the community answered
(24 responses)- A4% (1)
- B8% (2)
- C8% (2)
- D79% (19)
Community Discussion
No community discussion yet for this question.