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.)
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.)
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.
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
agreed with NachoPrendes