SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ93

Performance, Cost, and Resource Optimization

A company’s daily Snowflake workload involves a very large number of concurrent queries initiated between 9pm and 11pm. Individually, these queries are small statements that complete in a short period of time.

Which configuration can the company’s Architect implement to improve this workload’s performance?

Choose two
Explanation

Multi-cluster warehouses are designed to handle large numbers of concurrent users or queries. In maximized mode, Snowflake starts all configured clusters when the warehouse starts, providing maximum compute capacity throughout the predictable peak period. Raising MAX_CONCURRENCY_LEVEL permits more concurrent SQL statements per cluster; this suits a workload of numerous small, short-lived statements. Snowflake documents that warehouse resizing is not intended to resolve concurrency issues.

Learn more

Community Discussion

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