Data Management & Integration Flashcards
7 cards from real CDT practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Management & Integration flashcards as text
Which data format is most commonly used for exchanging structured data between modern web APIs and document management systems?
Answer: JSON
JSON (JavaScript Object Notation) is the dominant format for REST API data exchange due to its lightweight, human-readable, and language-agnostic structure.
What does 'eventual consistency' mean in the context of distributed document repositories?
Answer: Given enough time without new updates, all replicas will converge to the same value
Eventual consistency guarantees that, absent new updates, replicas across a distributed system will converge to identical values over time, though momentary divergence is allowed.
In the context of CDT data integration, what is a 'canonical data model'?
Answer: A common, enterprise-wide data format used as an intermediary between systems
A canonical data model defines a standard, neutral data structure that all integrated systems translate to and from, eliminating the need for N×(N-1) bilateral translations.
Which database feature ensures that related records across multiple tables remain valid and consistent?
Answer: Referential integrity / foreign key constraints
Referential integrity enforced via foreign key constraints prevents orphaned records by ensuring that references between tables always point to existing rows.
A company migrates 10 years of scanned invoices into a new ECM system. Which data quality step is MOST critical before migration?
Answer: Profiling and cleansing metadata to identify duplicates and missing values
Profiling and cleansing metadata before migration ensures that corrupt, duplicate, or incomplete records don't propagate into the new system, where remediation is far more costly.
What is the purpose of a 'data lineage' record in enterprise document management?
Answer: Documents the origin, movement, and transformation history of data over time
Data lineage traces where data originated, how it moved through systems, and what transformations were applied, supporting auditing, compliance, and impact analysis.
When integrating a document management system with an ERP, an organization uses middleware to translate ERP purchase orders into DMS metadata. What integration pattern does this represent?
Answer: Message transformation via an enterprise service bus (ESB)
An ESB acts as middleware that routes and transforms messages between systems, decoupling the ERP and DMS so neither depends directly on the other's data format.