SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ33

Manage and maintain database objects and virtual warehouses

A Snowflake Administrator uses a multi-cluster virtual warehouse in the Snowflake Business-Critical edition. The minimum cluster count is set to 2, and the maximum cluster count is set to 10. This configuration performs well for the normal workload, which seldom exceeds 5 running clusters. However, once each month, several complex long-running queries increase queue time and cause the warehouse to reach its maximum of 10 clusters.

Which solutions will resolve the issues that occur once a month?

Choose two
Explanation

Multi-cluster warehouses scale for query concurrency, whereas a separate appropriately sized warehouse isolates the periodic resource-intensive workload from the standard workload and prevents it from consuming the shared warehouse’s cluster capacity. Optimizing the complex queries with appropriate clustering keys or materialized views can reduce scanned work and execution time, reducing the pressure that causes queuing.

Learn more

Community Discussion

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