A data architect is designing a data warehouse and chooses to normalize the dimension tables. This approach involves creating separate, related tables for different attributes within a single dimension to minimize data redundancy, which may require more complex queries. Which schema design is the architect implementing?
A snowflake schema is the correct choice because it normalizes dimension tables by breaking them down into multiple, smaller, related tables to reduce data redundancy. A star schema, in contrast, uses denormalized dimension tables, keeping all attributes for a dimension in a single table. A data lake is a storage repository for raw data and does not enforce a specific schema for analytics in the way a data warehouse does. OLTP (Online Transactional Processing) refers to a type of system designed for managing transaction-oriented applications, not a data warehouse schema for analytics.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a snowflake schema in data warehousing?
Open an interactive chat with Bash
How does a snowflake schema differ from a star schema?
Open an interactive chat with Bash
What are the advantages of using a snowflake schema?