CDT Data Management & Integration 3 — Questions and Answers
Question 1: Which data format is most commonly used for exchanging structured data between modern web APIs and document management systems?
- CSV
- EDI X12
- JSON (Correct answer)
- RTF
Correct 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.
Question 2: What does 'eventual consistency' mean in the context of distributed document repositories?
- All nodes immediately reflect every write operation
- Given enough time without new updates, all replicas will converge to the same value (Correct answer)
- Data is consistent only after manual reconciliation jobs run
- Documents are versioned until an administrator approves them
Correct 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.
Question 3: In the context of CDT data integration, what is a 'canonical data model'?
- A proprietary vendor schema for a specific ECM platform
- A common, enterprise-wide data format used as an intermediary between systems (Correct answer)
- A compressed binary format for large document archives
- A regulatory-mandated schema for government filings
Correct 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.
Question 4: Which database feature ensures that related records across multiple tables remain valid and consistent?
- Indexing
- Referential integrity / foreign key constraints (Correct answer)
- Partitioning
- Connection pooling
Correct 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.
Question 5: A company migrates 10 years of scanned invoices into a new ECM system. Which data quality step is MOST critical before migration?
- Applying new retention schedules post-migration
- Profiling and cleansing metadata to identify duplicates and missing values (Correct answer)
- Rebuilding the full-text search index after loading
- Converting all TIFFs to PDF/A format
Correct 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.
Question 6: What is the purpose of a 'data lineage' record in enterprise document management?
- Tracks the physical location of backup tapes
- Documents the origin, movement, and transformation history of data over time (Correct answer)
- Specifies the retention schedule assigned to each document class
- Records the access control list changes for a document
Correct 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.
Question 7: 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?
- Direct database link
- Message transformation via an enterprise service bus (ESB) (Correct answer)
- Batch FTP file drop
- Screen scraping
Correct 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.
CDT Data Management & Integration 3
Which data format is most commonly used for exchanging structured data between modern web APIs and document management systems?