Drag and Drop Question Match the terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once…

The correct answer is Dimension tables; Extract, transform, and load (ETL); Data warehouses. Dimension tables contain descriptive attributes (such as product names, customer details, or dates) used to filter, group, and label fact data in a data warehouse schema. ETL (Extract, Transform, and Load) is the process of pulling data from source systems…

Submitted by amina.ke· Mar 30, 2026Data Analytics / Data Engineering Fundamentals - Understanding core components of data warehouse architecture including dimensional modeling concepts, data integration pipelines, and analytical storage systems.

Question

Drag and Drop Question Match the terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Answer:

Exhibit

Answer Area

Drag items

Data warehousesDimension tablesExtract, transform, and load (ETL)Fact tablesOnline analytical processing (OLAP)

Correct arrangement

Dimension tables
Extract, transform, and load (ETL)
Data warehouses

Explanation

Dimension tables contain descriptive attributes (such as product names, customer details, or dates) used to filter, group, and label fact data in a data warehouse schema. ETL (Extract, Transform, and Load) is the process of pulling data from source systems, cleansing/transforming it into a usable format, and loading it into a target repository. Data warehouses are centralized repositories optimized for analytical querying and reporting, storing large volumes of historical, integrated data from multiple sources.

Topics

#Data Warehousing#ETL Processes#Dimensional Modeling#Business Intelligence

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice