ARA-C01 · Question #97
ARA-C01 Question #97: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #97. The question stem and answer options stay visible for context.
Question
A Developer is having a performance issue with a Snowflake query. The query receives up to 10 different values for one parameter and then performs an aggregation over the majority of a fact table. It then joins against a smaller dimension table. This parameter value is selected by the different query users when they execute it during business hours. Both the fact and dimension tables are loaded with new data in an overnight import process. On a Small or Medium-sized virtual warehouse, the query performs slowly. Performance is acceptable on a size Large or bigger warehouse. However, there is no budget to increase costs. The Developer needs a recommendation that does not increase compute costs to run this query. What should the Architect recommend?
Options
- ACreate a task that will run the 10 different variations of the query corresponding to the 10 different
- BCreate a task that will run the 10 different variations of the query corresponding to the 10 different
- CEnable the search optimization service on the table. When the users execute the query, the search
- DCreate a dedicated size Large warehouse for this particular set of queries. Create a new role that
Unlock ARA-C01 to see the answer
You've previewed enough free ARA-C01 questions. Unlock ARA-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.