CDS Data Management & Integration 3

Question 1

In an ETL pipeline, at which stage should data cleansing and standardization typically occur?

Accepted Answer

Transform

Answer

The Transform stage is where data is cleansed, standardized, enriched, and restructured before being loaded into the target system.

Question 2

A company's data warehouse team receives source data where the 'customer_id' field in the CRM uses integers but the ERP uses alphanumeric codes for the same entity. This mismatch is called a:

Accepted Answer

Key reconciliation problem

Answer

Key reconciliation involves resolving differences in how the same real-world entity is identified across different source systems.

Question 3

Which of the following BEST describes an ELT (Extract, Load, Transform) approach versus traditional ETL?

Accepted Answer

ELT loads raw data first and performs transformations within the target system

Answer

ELT leverages the processing power of modern cloud data warehouses by loading raw data first and transforming it in place using SQL or native tools.

Question 4

What is the role of a 'data steward' versus a 'data owner' in data governance?

Accepted Answer

Data owners are accountable for data assets; data stewards manage day-to-day quality and compliance

Answer

Data owners hold business accountability for data assets, while data stewards are responsible for the operational management of data quality, definitions, and usage.

Question 5

Which concept describes the practice of storing a copy of data from operational systems in a staging area before loading it into the data warehouse?

Accepted Answer

Data staging

Answer

A data staging area holds extracted data temporarily, decoupling the extraction from transformation and protecting source systems from heavy query loads.

(CDS) Certified Data Steward Practice Test

(CDS) Certified Data Steward Practice Test

CDS Data Management & Integration 3