CBDA Data Management & Lifecycle 2

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?

Accepted Answer

Data duplication and lack of entity resolution

Answer

Data latency

Answer

Data archival failure

Answer

Schema drift

Question 2

What is a data catalog primarily used for?

Accepted Answer

Providing a searchable inventory of an organization's data assets with metadata and lineage information

Answer

Storing backup copies of production databases

Answer

Automating ETL pipeline scheduling

Answer

Enforcing row-level security on data warehouse tables

Question 3

Data lineage tracking is most useful for which of the following purposes?

Accepted Answer

Tracing the origin, movement, and transformation of data throughout its lifecycle

Answer

Reducing query execution time on large datasets

Answer

Compressing data files to reduce storage costs

Answer

Scheduling regular data quality audits

Question 4

Which of the following is an example of structured data?

Accepted Answer

A relational database table with defined columns and rows

Answer

A PDF contract document

Answer

A social media image

Answer

A voice recording of a customer service call

Question 5

In the context of data management, what is 'schema-on-read'?

Accepted Answer

Applying the data structure interpretation when data is queried rather than when it is stored

Answer

Defining the data structure at the time data is loaded into the database

Answer

Automatically generating schemas from XML documents

Answer

Restricting schema changes after initial table creation

Question 6

What is the main advantage of implementing data versioning in a data management strategy?

Accepted Answer

It allows analysts to access and compare historical states of data over time

Answer

It reduces database storage costs by compressing older records

Answer

It automatically encrypts data at every save point

Answer

It prevents unauthorized schema modifications

Question 7

Which role in a data management framework is typically responsible for defining data governance policies and standards at an enterprise level?

Accepted Answer

Chief Data Officer (CDO)

Answer

Database administrator (DBA)

Answer

Data engineer

Answer

Business intelligence developer