In a Data Warehouse, data is often stored in a _______ schema.
- Hierarchical
- Relational
- Snowflake
- Star
In a Data Warehouse, data is often stored in a Star schema. The Star schema consists of one or more fact tables referencing any number of dimension tables, forming a star-like structure. This schema design facilitates efficient querying and reporting for analytical purposes.
Loading...
Related Quiz
- Scenario: A company has employees and departments. Each employee must be assigned to one department, but a department can have multiple employees. What cardinality and modality does this scenario represent?
- In data warehousing, what is the purpose of a roll-up operation?
- _______ is the process of reorganizing table and index data to improve query performance and reduce contention in a database.
- MySQL Workbench provides features for _______ database design and management.
- What is the primary function of a fact table in a data warehouse?