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.)
To enhance the performance of a huge number of concurrent queries, enabling a multi-clustered virtual warehouse in maximized mode during the workload duration will allow dynamic scaling of resources, ensuring that sufficient compute resources are available to handle the peak load. Setting the MAX_CONCURRENCY_LEVEL to a higher value than its default of 8 at the virtual warehouse level will increase the number of queries that can be executed concurrently, thereby improving overall throughput and reducing wait times for queries.
A,B are correct
Answer is A,B and is validated
correct A&C
Changing to A&D