Snowflake
ADA-C01 · Question #79
ADA-C01 Question #79: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.
Question
A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set. Which action would provide optimal performance for the second SQL query?
Options
- AAssign additional clusters to the virtual warehouse.
- BIncrease the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
- CPrevent the virtual warehouse from suspending between the running of the first and second
- DUse the RESULT_SCAN function to post-process the output of the first query.
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.