SnowPro Advanced: Data Engineer — Question 18

A company is building a dashboard for thousands of Analysts. The dashboard presents the results of a few summary queries on tables that are regularly updated. The query conditions vary by topic according to what data each Analyst needs. Responsiveness of the dashboard queries is a top priority, and the data cache should be preserved.
How should the Data Engineer configure the compute resources to support this dashboard?

Answer options

• A. Assign queries to a multi-cluster virtual warehouse with economy auto-scaling. Allow the system to automatically start and stop clusters according to demand.
• B. Assign all queries to a multi-cluster virtual warehouse set to maximized mode. Monitor to determine the smallest suitable number of clusters.
• C. Create a virtual warehouse for every 250 Analysts. Monitor to determine how many of these virtual warehouses are being utilized at capacity.
• D. Create a size XL virtual warehouse to support all the dashboard queries. Monitor query runtimes to determine whether the virtual warehouse should be resized.

Correct answer: B

Explanation

Option B is correct because using a multi-cluster virtual warehouse in maximized mode allows for optimal resource allocation, ensuring responsiveness for the dashboard queries while adapting to varying demands. Option A relies on economy auto-scaling, which may not provide the necessary responsiveness under high load. Option C could lead to inefficiency with too many virtual warehouses, and Option D may not adequately manage resources as a single XL virtual warehouse could become a bottleneck.