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

Question

Options

• ASnowflake cannot handle the joins implied in a 3NF data model.
• BThe Architect wants to remove data duplication from the data stored in Snowflake.
• CThe Architect is designing a landing zone to receive raw data into Snowflake.
• DThe Bl tool needs a data model that allows users to summarize facts across different dimensions,
• EThe Architect wants to present a simple flattened single view of the data to a particular group of

• A
  16% (9)
• B
  3% (2)
• C
  9% (5)
• D
  72% (42)

Explanation

A star schema model is a type of dimensional data model that consists of a single fact table and multiple dimension tables. A 3NF model is a type of relational data model that follows the third normal form, which eliminates data redundancy and ensures referential integrity. A Snowflake Architect might use a star schema model rather than a 3NF model when designing a data architecture to run in Snowflake for the following reasons: A star schema model is more suitable for analytical queries that require aggregating and slicing data across different dimensions, such as those performed by a BI tool. A 3NF model is more suitable for transactional queries that require inserting, updating, and deleting individual records. A star schema model is simpler and faster to query than a 3NF model, as it involves fewer joins and less complex SQL statements. A 3NF model is more complex and slower to query, as it involves more joins and more complex SQL statements. A star schema model can provide a simple flattened single view of the data to a particular group of end users, such as business analysts or data scientists, who need to explore and visualize the data. A 3NF model can provide a more detailed and normalized view of the data to a different group of end users, such as application developers or data engineers, who need to maintain and update the data.

No community discussion yet for this question.