nerdexam
Snowflake

SOL-C01 · Question #247

A data warehouse architect is designing a Snowflake environment for a large retail company. The company has diverse data workloads, including batch data ingestion, real-time analytics, and machine lea

Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #247. The question stem and answer options stay visible for context.

Virtual Warehouses

Question

A data warehouse architect is designing a Snowflake environment for a large retail company. The company has diverse data workloads, including batch data ingestion, real-time analytics, and machine learning model training. The architect needs to choose the appropriate Snowflake edition and configure the virtual warehouse sizes to optimize cost and performance. Considering the diverse workloads, which combination of Snowflake edition and virtual warehouse strategy would be most appropriate?

Options

  • ASnowflake Standard Edition with a single X-Large virtual warehouse shared across all workloads.
  • BSnowflake Enterprise Edition with separate virtual warehouses of varying sizes (Small to X-Large)
  • CSnowflake Business Critical Edition with a single Medium virtual warehouse that auto-scales based
  • DSnowflake Virtual Private Snowflake (VPS) with a dedicated virtual warehouse for each
  • ESnowflake Standard Edition with separate Small virtual warehouses for batch ingestion and

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.

Topics

#Snowflake Editions#Virtual Warehouse Sizing#Workload Management#Cost/Performance Optimization
Full SOL-C01 Practice