An Architect needs to improve the performance of reports that pull data from multiple Snowflake tables, join, and then aggregate the data. Users…

The most cost-effective way to increase the availability and performance of the reports during peak

usage times, while keeping costs under control, is to use a multi-cluster warehouse in auto-scale

mode. Option D suggests using a multi-cluster warehouse with 1 size Medium cluster and allowing it

to auto-scale between 1 and 4 clusters based on demand. This setup ensures that additional

computing resources are available when needed (e.g., during Monday morning peaks) and are scaled

down to minimize costs when the demand decreases. This approach optimizes resource utilization

and cost by adjusting the compute capacity dynamically, rather than maintaining a larger fixed size or

multiple clusters continuously.

Reference: Snowflake's official documentation on managing warehouses and using auto-scaling

features.