Snowflake
ADA-C01 · Question #24
ADA-C01 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
Question
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database. For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?
Options
- ATo save costs on warehouse shutdowns and startups for different queries
- BTo save costs by running the warehouse as little as possible
- CTo keep the data cache warm to support good performance of similar queries
- DTo keep the query result cache warm for good performance on repeated queries
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.