In a data warehouse, the _________ table is used to store aggregated data at multiple levels of granularity.
- Fact
- Dimension
- Staging
- Aggregate
In a data warehouse, the "Fact" table is used to store aggregated data at various levels of granularity. These tables contain measures or metrics, which are essential for analytical queries and business intelligence reporting.
Loading...
Related Quiz
- The process of converting a trained machine learning model into a format that can be used by production systems is called _______.
- While preparing data for a machine learning model, you realize that the 'Height' column has some missing values. Upon closer inspection, you find that these missing values often correspond to records where the 'Age' column has values less than 1 year. What might be a reasonable way to handle these missing values?
- In Big Data processing, _______ operations filter and sort data, while _______ operations perform aggregations and transformations.
- A common architecture for real-time data processing involves using ________ to ingest and process streaming data.
- Overfitting can also be controlled by reducing the _______ of the neural network, which refers to the number of nodes and layers.