In Dimensional Modeling, a ________ is a central table in a star schema that contains metrics or measurements.
- Dimension table
- Fact table
- Lookup table
- Transaction table
In Dimensional Modeling, a Fact table is a central table in a star schema that contains metrics or measurements. It typically contains numeric data that represents business facts and is surrounded by dimension tables.
Loading...
Related Quiz
- Scenario: You are tasked with designing a monitoring solution for a real-time data pipeline handling sensitive financial transactions. What factors would you consider in designing an effective alerting mechanism?
- ________ involves setting predefined thresholds for key metrics to trigger alerts in case of anomalies.
- Scenario: A financial institution wants to implement real-time fraud detection. Outline the key components and technologies you would recommend for building such a system.
- What is idempotence in the context of retry mechanisms?
- What does the acronym ETL stand for in data engineering?