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

Question

A large e-commerce company is experiencing seasonal spikes in sales traffic, leading to significant increases in data ingestion and query processing. You are tasked with optimizing their Snowflake environment. Which of the following strategies BEST leverage Snowflake's elastic storage and compute capabilities to handle these fluctuating workloads efficiently and cost- effectively?

Options

• AManually resize the Snowflake virtual warehouse based on anticipated peak loads at the beginning
• BUtilize Snowflake's auto-scaling feature for virtual warehouses to automatically adjust compute
• CRely solely on Snowflake's automatic storage scaling and ignore the virtual warehouse size, as
• DPre-process all incoming data into smaller, aggregated tables before loading it into Snowflake to
• EUse only the X-Small virtual warehouse size, since Snowflake's cloud-based architecture

Explanation

Option B is the most effective strategy. Snowflake's auto-scaling feature automatically adjusts compute resources to match demand, ensuring optimal performance during peak periods. Resource monitors prevent runaway costs. Option A is less efficient as it relies on manual intervention and might not react quickly enough to changing demands. Option C neglects the importance of compute scaling. Option D introduces unnecessary complexity and potential data loss. Option E will lead to poor performance during peak loads.

No community discussion yet for this question.