Implementation & Configuration Flashcards

A CDO is rolling out a new enterprise data catalog. Which configuration step should come first to make search results meaningful to business users?

Answer: Loading an approved business glossary and mapping terms to technical assets

A governed business glossary linked to technical metadata gives business users context, which makes catalog search useful.

When implementing a master data management (MDM) hub, which architectural style keeps master data in source systems and builds a virtual golden record only through cross-reference indexes?

Answer: Registry style

Registry-style MDM stores only identifiers and match links, assembling the golden view at query time without changing sources.

During configuration of MDM match rules, the team sees too many distinct customers being merged incorrectly. Which adjustment best reduces these false positives?

Answer: Raise the match threshold and add more deterministic attributes

A higher threshold plus stronger deterministic keys makes the engine stricter, so fewer records that only look alike get merged.

A data quality rule is configured to flag records where 'ship_date' is earlier than 'order_date'. Which data quality dimension does this rule primarily measure?

Answer: Consistency (validity across fields)

Cross-field logical rules test whether related values agree with each other, which is a consistency/validity check.

Which approach best enforces column-level protection of Social Security numbers in a cloud data warehouse while still allowing analysts to join on that column?

Answer: Apply deterministic tokenization or dynamic masking policies tied to roles

Deterministic tokenization or role-based dynamic masking hides raw values but keeps join keys consistent for authorized analytics.

When configuring role-based access control (RBAC) for a new data platform, which principle should guide the default permission assigned to new users?

Answer: Least privilege, with access granted via approved request workflows

Least privilege limits exposure by granting only what each role needs, with extra access approved through workflow.

A CDO is deploying a data lineage tool. Which capture method provides the most accurate column-level lineage for SQL-based transformations?

Answer: Parsing SQL and ETL job code or query logs automatically

Automated parsing of transformation code and query logs captures real column-to-column flows without relying on human memory.