SOL-C01 · Question #233
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 env
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #233. The question stem and answer options stay visible for context.
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
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.