SnowPro Advanced: Architect — Question 98

Why might a Snowflake Architect use a star schema model rather than a 3NF model when designing a data architecture to run in Snowflake? (Choose two.)

Answer options

• A. Snowflake cannot handle the joins implied in a 3NF data model.
• B. The Architect wants to remove data duplication from the data stored in Snowflake.
• C. The Architect is designing a landing zone to receive raw data into Snowflake.
• D. The BI tool needs a data model that allows users to summarize facts across different dimensions, or to drill down from the summaries.
• E. The Architect wants to present a simple flattened single view of the data to a particular group of end users.

Correct answer: D, E

Explanation

Option D is correct because a star schema is designed to facilitate data summarization and analysis across different dimensions, which is essential for BI tools. Option E is also correct as a star schema provides a simplified view of data, making it easier for end users to understand. Options A, B, and C do not align with the primary reasons for choosing a star schema over a 3NF model.