In data warehousing, a ________ is a type of schema used to model data for online analytical processing (OLAP).
- Fact schema
- Hybrid schema
- Snowflake schema
- Star schema
In data warehousing, a Star schema is a widely-used schema design for modeling data for OLAP. It consists of one or more fact tables referencing multiple dimension tables in a star-like structure, facilitating efficient querying and analysis.
Loading...
Related Quiz
- What are some potential drawbacks of denormalization compared to normalization?
- NoSQL databases are often used in scenarios where the volume of data is ________, and the data structure is subject to frequent changes.
- Apache NiFi offers ________ for data provenance, allowing users to trace the origin and transformation history of data.
- Scenario: A regulatory audit requires your organization to provide a comprehensive overview of data flow and transformations. How would you leverage metadata management and data lineage to address the audit requirements effectively?
- What does GDPR stand for in the context of data compliance?