SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 82

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.)

Snowflake cannot handle the joins implied in a 3NF data model.

The Architect wants to remove data duplication from the data stored in Snowflake.

The Architect is designing a landing zone to receive raw data into Snowflake.

The BI tool needs a data model that allows users to summarize facts across different dimensions, or to drill down from the summaries.

The Architect wants to present a simple flattened single view of the data to a particular group of end users.

Correct Answer: D, E

A Snowflake Architect might use a star schema model rather than a 3NF model to support the needs of a BI tool that requires summarization and drill-down capabilities across different dimensions. Additionally, using a star schema allows for presenting a simplified, flattened view of the data to a specific group of end users, making it easier for them to understand and use the data for their analysis.

Discussion

NachoPrendesOptions: DE

A. Snowflake handle the joins perfectly B. data duplication is bigger in Star Schema C. The landing zone receives the data "AS IS", without changes