Data and Analytics Data Governance and Quality 2 — Questions and Answers
Question 1: What is a master data management (MDM) system?
- A database backup and recovery system
- A technology for creating a single, authoritative source of truth for critical business data (Correct answer)
- A system for managing database administrator accounts
- An ETL tool for moving data between systems
Correct answer: A technology for creating a single, authoritative source of truth for critical business data
MDM creates and maintains a single, consistent, and accurate record of critical business entities like customers, products, and suppliers across the organization.
Question 2: What is data deduplication?
- Encrypting duplicate copies of data
- The process of identifying and removing duplicate records from datasets (Correct answer)
- Backing up data in multiple locations
- Creating redundant database copies for failover
Correct answer: The process of identifying and removing duplicate records from datasets
Data deduplication identifies and eliminates duplicate records in datasets to ensure each entity appears only once, improving data quality.
Question 3: What is a data quality rule?
- A company policy about data ownership
- A condition or constraint that data must satisfy to be considered fit for use (Correct answer)
- A SQL constraint on a database column
- A regulatory requirement from a government agency
Correct answer: A condition or constraint that data must satisfy to be considered fit for use
A data quality rule defines the criteria that data must meet to be considered accurate, complete, and valid for its intended business use.
Question 4: What does 'data at rest' refer to in security?
- Data that has not been accessed recently
- Data stored in databases, file systems, or storage media that is not actively moving (Correct answer)
- Data temporarily cached in memory
- Data waiting to be processed in a queue
Correct answer: Data stored in databases, file systems, or storage media that is not actively moving
Data at rest refers to inactive data stored persistently in databases, file systems, or storage media, as opposed to data in transit or in use.
Question 5: What is the purpose of a data retention policy?
- To maximize data storage for analytics
- To define how long data should be kept before it is archived or deleted (Correct answer)
- To prevent data from being modified after creation
- To specify who has access to sensitive data
Correct answer: To define how long data should be kept before it is archived or deleted
A data retention policy specifies how long different categories of data are kept, balancing business needs, legal requirements, and storage costs.
Question 6: What is role-based access control (RBAC) in data systems?
- A method for assigning random access permissions
- A security model granting data access based on a user's organizational role (Correct answer)
- An encryption method for sensitive data
- A database replication strategy
Correct answer: A security model granting data access based on a user's organizational role
RBAC assigns permissions to roles rather than individuals, granting users access to data based on their job function within the organization.
Data and Analytics Data Governance and Quality 2
What is a master data management (MDM) system?