ARA-C01 Question 42

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.)
A. Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
B. Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
C. Increase the size of the virtual warehouse to size X-Large.
D. Reduce the amount of data that is being processed through this workload.
E. Set the connection timeout to a higher value than its default.

Accepted Answer

Marked answer: A. Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.

ARA-C01 Question 42

Community Discussion

Preparing Practice Exam…

ARA-C01 Question 42

Community Discussion