Data Warehousing

__________ 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