Data Management & Lifecycle Flashcards

What does data provenance refer to in the context of data management?

Answer: The documented history of data's origin, custody, and any changes made to it

Data provenance documents the origins and complete history of a dataset, including who created it, how it was processed, and what changes have been made, supporting trust and reproducibility.

A data governance committee has flagged a dataset as 'sensitive PII'. What should the data lifecycle management plan prioritize for this dataset?

Answer: Strict access controls, data minimization, and defined disposal procedures compliant with privacy regulations

Sensitive PII requires strict access controls, minimization of exposure, and compliant disposal procedures to meet privacy regulations such as GDPR and CCPA.

Which of the following best describes the difference between a data warehouse and a data lake?

Answer: A data warehouse stores structured, processed data optimized for querying, while a data lake stores raw data in its native format

A data warehouse stores cleansed, structured data modeled for analytical queries, while a data lake stores raw data in its original format regardless of structure, allowing for more flexible future use.

What is the purpose of a data disposal policy?

Answer: To establish rules for securely and permanently removing data that has reached the end of its retention period

A data disposal policy ensures that data no longer needed for business, legal, or compliance purposes is destroyed securely and in a documented manner to prevent unauthorized access.

In data lifecycle management, which activity ensures that data quality standards are maintained as data moves through its stages?

Answer: Data profiling and quality monitoring

Data profiling and quality monitoring continuously assess data for accuracy, completeness, consistency, and timeliness as it moves through ingestion, transformation, storage, and use stages.

Which of the following is a key principle of data minimization?

Answer: Collecting only the data that is necessary for the specified purpose and no more

Data minimization is a privacy principle requiring that only the minimum amount of data necessary to fulfill a specific purpose be collected and retained, reducing privacy risk.

A data analyst notices that a critical business report is using data from three different systems that frequently show conflicting values. Which data management solution would most directly address this problem?

Answer: Implementing a master data management (MDM) solution to create a single authoritative version of shared data entities

MDM creates a trusted, unified reference for key business entities across systems, resolving conflicts and ensuring that all reports draw from a single authoritative source.