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

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

Explanation

Option B is the most appropriate. Enterprise Edition provides the features necessary for diverse workloads (such as materialized views and advanced security), and using separate virtual warehouses allows for workload isolation and optimized resource allocation. Resource monitors can control costs. Standard Edition (A and E) lacks the features required for advanced workloads. Business Critical Edition (C) is overkill unless specific security or compliance requirements mandate it. VPS (D) is suitable for highly regulated industries but may be more expensive than necessary for a retail company. Using external services such as SageMaker (E) defeats the purpose of leveraging Snowflake for all workloads.

No community discussion yet for this question.