NEW
Font size
WorksheetsData Warehousing
Total questions: 10
Worksheet time: 5mins
__________ refers to the process of collecting, storing, and managing large volumes of data from various sources in a centralized repository.
Data Warehousing
Data Mart
Data Modelling
Attributes
Which of these is not a type of data warehouse?
Single Tier
Desktop Based
Multi Tier
Cloud Based
_______________ is a subset of a data warehouse designed to serve a specific group or department's business intelligence (BI) and reporting needs.
Star Schema
Data Warehouse
Data Mart
Snowflake Schema
Which of the following supports day-to-day transactional operations?
OLTP
OLAP
Both
None
Which of the following supports complex and strategic business analysis?
OLTP
OLAP
Both
None
___________ is the blueprint that defines how your data will be stored, accessed and manipulated to support business intelligence.
Data Warehouse
Data Mart
Data Modelling
Data Lake
______________ define the structure and characteristics of dimension table, providing the necessary details for analysis.
Dimension Table
Fact Table
Attributes
Variables
In a ______________, the central feature is a fact table that is directly connected to multiple dimension tables. When visualized, the schema resembles a star, with the fact table at the center and dimensions radiating outward.
Simple Schema
Star Schema
Complex Schema
Snowflake Schema
A _______________ is an extension of the star schema where dimension table are normalized, meaning they are broken into multiple related tables. This results in a structure that resembles a snowflake when visualized, with additional levels of normalization.
Simple Schema
Star Schema
Complex Schema
Snowflake Schema
_____________ is the process of combining data from multiple sources into a single, unified view.
Data Warehouse
Data Integration
Data Mart
Data Modelling
