SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ80

Design and Manage Snowflake Resources and Performance

A company is developing a dashboard for thousands of Analysts. The dashboard displays results from several summary queries against tables that are updated regularly. Query conditions vary by topic based on the data each Analyst requires. Dashboard-query responsiveness is a top priority, and the data cache must be retained.

How should the Data Engineer configure compute resources to support this dashboard?

Explanation

A maximized multi-cluster virtual warehouse provides multiple concurrently running clusters for a large, steady, highly responsive query workload. Keeping those clusters running avoids the cache loss that occurs when compute resources are removed. Economy auto-scaling instead favors keeping clusters fully loaded to conserve credits, which can increase queuing and latency. Snowflake: Warehouse considerations Snowflake: Multi-cluster warehouses

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!