SOL-C01 Question #96: Real Exam Question with Answer & Explanation

Question

A Snowflake account uses separate virtual warehouses for different workloads: 'REPORTING WI- 4' for reporting queries and 'TRANSFORM WH' for data transformation jobs. A user, Alice, is responsible for running both types of workloads. Alice is experiencing performance issues with reporting queries when the transformation jobs are running concurrently. Both warehouses are currently configured with the 'STANDARD' size. What are the recommended strategies to improve the performance of reporting queries without significantly impacting the performance of transformation jobs?

Options

• AIncrease the size of 'REPORTING_WH' to 'LARGE and enable auto-suspend on to prevent it from
• BEnable mufti-cluster warehouses for both and and set the scaling policy to 'ECONOMY' for
• CEnable auto-suspend on 'REPORTING_WH' and increase the size of 'TRANSFORM_WH' to
• DEnable Resource Monitors to limit the credit usage of 'TRANSFORM_WH' and increase the size of
• EEnable multi-cluster warehouses for 'REPORTING with a scaling policy set to `STANDARD and a

Explanation

Enabling a multi-cluster warehouse for 'REPORTING_WH' with a 'STANDARD' scaling policy allows Snowflake to automatically scale up the number of clusters to handle the increased workload from concurrent reporting queries. The Query Acceleration Service (QAS) will try to reduce the resource consumption of reporting queries. Implementing Resource Monitors for `TRANSFORM WHS will prevent it from consuming excessive credits and impacting the performance of 'REPORTING_WH' during concurrent execution.

No community discussion yet for this question.