CDS Data Management & Integration 2

Question 1

Which data integration pattern uses a central hub to transform and route messages between systems, allowing each system to communicate only with the hub?

Accepted Answer

Hub-and-Spoke

Answer

The Hub-and-Spoke pattern centralizes integration logic so each system connects only to the hub, reducing the number of direct integrations required.

Question 2

A data steward discovers that two source systems use different date formats (MM/DD/YYYY vs YYYY-MM-DD) for the same field. This is an example of which data quality issue?

Accepted Answer

Syntactic inconsistency

Answer

Syntactic inconsistency occurs when the same data is represented in different formats or structures across systems.

Question 3

What is the primary purpose of a data dictionary in data management?

Accepted Answer

To define and document the meaning, format, and usage of data elements

Answer

A data dictionary provides authoritative definitions for data elements including names, descriptions, data types, and business rules.

Question 4

In Master Data Management (MDM), what is a 'golden record'?

Accepted Answer

The single, authoritative, trusted version of a master data entity

Answer

A golden record is the consolidated, de-duplicated, and authoritative representation of a business entity created from multiple source systems.

Question 5

Which integration approach is BEST suited for near-real-time data synchronization between an operational system and an analytics platform?

Accepted Answer

Change Data Capture (CDC)

Answer

CDC captures and propagates only the changed data rows as they occur, enabling near-real-time synchronization with minimal load.

(CDS) Certified Data Steward Practice Test

(CDS) Certified Data Steward Practice Test

CDS Data Management & Integration 2