Data and Analytics Data Governance and Quality 2

Question 1

What is a master data management (MDM) system?

Accepted Answer

A technology for creating a single, authoritative source of truth for critical business data

Answer

A database backup and recovery system

Answer

A system for managing database administrator accounts

Answer

An ETL tool for moving data between systems

Question 2

What is data deduplication?

Accepted Answer

The process of identifying and removing duplicate records from datasets

Answer

Encrypting duplicate copies of data

Answer

Backing up data in multiple locations

Answer

Creating redundant database copies for failover

Question 3

What is a data quality rule?

Accepted Answer

A condition or constraint that data must satisfy to be considered fit for use

Answer

A company policy about data ownership

Answer

A SQL constraint on a database column

Answer

A regulatory requirement from a government agency

Question 4

What does 'data at rest' refer to in security?

Accepted Answer

Data stored in databases, file systems, or storage media that is not actively moving

Answer

Data that has not been accessed recently

Answer

Data temporarily cached in memory

Answer

Data waiting to be processed in a queue

Question 5

What is the purpose of a data retention policy?

Accepted Answer

To define how long data should be kept before it is archived or deleted

Answer

To maximize data storage for analytics

Answer

To prevent data from being modified after creation

Answer

To specify who has access to sensitive data

Question 6

What is role-based access control (RBAC) in data systems?

Accepted Answer

A security model granting data access based on a user's organizational role

Answer

A method for assigning random access permissions

Answer

An encryption method for sensitive data

Answer

A database replication strategy