CBDA Data Management & Lifecycle 2 — Questions and Answers
Question 1: A company discovers that the same customer appears under multiple different IDs across its CRM and billing systems. Which data management problem does this illustrate?
- Data latency
- Data duplication and lack of entity resolution (Correct answer)
- Data archival failure
- Schema drift
Correct answer: Data duplication and lack of entity resolution
Having the same real-world entity represented under different identifiers across systems is a classic data duplication problem that master data management and entity resolution techniques address.
Question 2: What is a data catalog primarily used for?
- Storing backup copies of production databases
- Providing a searchable inventory of an organization's data assets with metadata and lineage information (Correct answer)
- Automating ETL pipeline scheduling
- Enforcing row-level security on data warehouse tables
Correct answer: Providing a searchable inventory of an organization's data assets with metadata and lineage information
A data catalog acts as an organized inventory of data assets, enabling data consumers to discover, understand, and trust the data available to them through metadata, lineage, and descriptions.
Question 3: Data lineage tracking is most useful for which of the following purposes?
- Reducing query execution time on large datasets
- Tracing the origin, movement, and transformation of data throughout its lifecycle (Correct answer)
- Compressing data files to reduce storage costs
- Scheduling regular data quality audits
Correct answer: Tracing the origin, movement, and transformation of data throughout its lifecycle
Data lineage provides visibility into how data flows from source to destination and what transformations occur along the way, supporting debugging, compliance, and trust.
Question 4: Which of the following is an example of structured data?
- A PDF contract document
- A social media image
- A relational database table with defined columns and rows (Correct answer)
- A voice recording of a customer service call
Correct answer: A relational database table with defined columns and rows
Structured data is organized into a predefined format with fixed fields, such as rows and columns in a relational database, making it directly queryable with SQL.
Question 5: In the context of data management, what is 'schema-on-read'?
- Defining the data structure at the time data is loaded into the database
- Applying the data structure interpretation when data is queried rather than when it is stored (Correct answer)
- Automatically generating schemas from XML documents
- Restricting schema changes after initial table creation
Correct answer: Applying the data structure interpretation when data is queried rather than when it is stored
Schema-on-read defers applying a structure to data until it is accessed, commonly used in data lakes where raw data is stored without enforcing a schema upfront.
Question 6: What is the main advantage of implementing data versioning in a data management strategy?
- It reduces database storage costs by compressing older records
- It allows analysts to access and compare historical states of data over time (Correct answer)
- It automatically encrypts data at every save point
- It prevents unauthorized schema modifications
Correct answer: It allows analysts to access and compare historical states of data over time
Data versioning preserves historical snapshots of data, enabling analysts to audit changes, reproduce past analyses, and understand how data has evolved.
Question 7: Which role in a data management framework is typically responsible for defining data governance policies and standards at an enterprise level?
- Database administrator (DBA)
- Data engineer
- Chief Data Officer (CDO) (Correct answer)
- Business intelligence developer
Correct answer: Chief Data Officer (CDO)
The Chief Data Officer (CDO) holds executive responsibility for the organization's data strategy, governance policies, and standards across the enterprise.
CBDA Data Management & Lifecycle 2
A company discovers that the same customer appears under multiple different IDs across its CRM and billing systems.
Which data management problem does this illustrate?