CDT Data Management & Integration 1 — Questions and Answers
Question 1: What is the primary goal of data management?
- Ensuring data quality, availability, and security throughout its lifecycle (Correct answer)
- Storing as much data as possible
- Making all data publicly accessible
- Reducing storage costs only
Correct answer: Ensuring data quality, availability, and security throughout its lifecycle
Data management ensures data quality, availability, and security throughout its lifecycle, supporting informed decision-making and regulatory compliance.
Question 2: Why is data validation important during integration?
- It ensures data accuracy and consistency across connected systems (Correct answer)
- It slows down data transfer unnecessarily
- It is only needed for financial data
- It can be skipped if the source system is trusted
Correct answer: It ensures data accuracy and consistency across connected systems
Data validation during integration ensures accuracy and consistency, preventing corrupt or incompatible data from propagating across systems.
Question 3: What is a data governance framework?
- Policies and procedures that define how data is managed across the organization (Correct answer)
- A software tool for database management
- A backup and recovery plan
- A network security protocol
Correct answer: Policies and procedures that define how data is managed across the organization
A data governance framework establishes policies, procedures, and responsibilities for managing data quality, security, and usage across the organization.
Question 4: How should data quality issues be addressed?
- Identify root causes, implement corrections, and establish preventive controls (Correct answer)
- Delete problematic records
- Ignore issues that affect less than 5% of data
- Manually correct each error as it is found
Correct answer: Identify root causes, implement corrections, and establish preventive controls
Addressing root causes with corrective actions and preventive controls provides sustainable data quality improvement rather than reactive fixes.
Question 5: What is the purpose of data lineage tracking?
- To trace data origin, transformations, and movement through systems (Correct answer)
- To track which users access data
- To measure data storage costs
- To create backup schedules
Correct answer: To trace data origin, transformations, and movement through systems
Data lineage tracking traces data from origin through all transformations and movements, supporting audit requirements, troubleshooting, and impact analysis.
Question 6: When integrating systems, what is an API contract?
- A formal agreement on data formats, endpoints, and expected behaviors (Correct answer)
- A legal document between vendors
- A performance guarantee
- A user interface specification
Correct answer: A formal agreement on data formats, endpoints, and expected behaviors
An API contract formally defines data formats, endpoints, and expected behaviors between integrated systems, ensuring reliable and predictable communication.
CDT Data Management & Integration 1
What is the primary goal of data management?