In a star schema, a fact table typically contains the measures and foreign keys to the _______ tables.
- Aggregate
- Dimension
- Fact
- Primary
In a star schema, the fact table contains the measures (quantitative data) and foreign keys that connect to dimension tables. Dimension tables hold descriptive information about the data, so the foreign keys in the fact table point to the dimension tables, allowing you to analyze the measures in context.
Loading...
Related Quiz
- In data profiling, the _______ provides a summary of the central tendency of the data.
- _______ involves predicting future data warehouse load or traffic based on historical data and trends to ensure optimal performance.
- Which of the following cloud-based data warehousing solutions uses a multi-cluster shared architecture, allowing for concurrent read and write access?
- The practice of regularly verifying the accuracy, consistency, and reliability of data in a data warehouse is known as _______.
- In a time dimension, which of the following can be considered a hierarchy?