SnowflakeSnowflake
ARA-C01 · Question #5
ARA-C01 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Performance Optimization
Question
A company's daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period. What configuration can the company's Architect implement to enhance the performance of this workload? (Choose two.)
Options
- AEnable a multi-clustered virtual warehouse in maximized mode during the workload duration.
- BSet the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual
- CIncrease the size of the virtual warehouse to size X-Large.
- DReduce the amount of data that is being processed through this workload.
- ESet the connection timeout to a higher value than its default.
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.
Topics
#Virtual Warehouses#Concurrency Control#Performance Tuning#Multi-cluster Warehouses