CDT Data Management & Integration 3

Question 1

Which data format is most commonly used for exchanging structured data between modern web APIs and document management systems?

Accepted Answer

JSON

Answer

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?

Accepted Answer

Given enough time without new updates, all replicas will converge to the same value

Answer

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'?

Accepted Answer

A common, enterprise-wide data format used as an intermediary between systems

Answer

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?

Accepted Answer

Referential integrity / foreign key constraints

Answer

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?

Accepted Answer

Profiling and cleansing metadata to identify duplicates and missing values

Answer

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.

(CDT) Certified Document Technologist Practice Test

(CDT) Certified Document Technologist Practice Test

CDT Data Management & Integration 3