Data Management & Integration Flashcards

Which data integration pattern uses a central hub to translate and route messages between disparate systems?

Answer: Hub-and-spoke architecture

Hub-and-spoke architecture uses a central hub that handles translation and routing, reducing the number of point-to-point connections required.

In document management, what does 'data normalization' primarily achieve?

Answer: Eliminates redundancy and ensures data consistency across tables

Data normalization organizes a database to reduce redundancy and improve data integrity by structuring tables and relationships correctly.

A CDT practitioner needs to merge customer records from two systems where the same person appears with slightly different name spellings. Which technique best addresses this?

Answer: Fuzzy matching / probabilistic record linkage

Fuzzy matching uses probabilistic algorithms to identify records that likely refer to the same entity despite minor spelling or format differences.

What is a 'data steward' responsible for in a document management environment?

Answer: Owning and enforcing data quality rules for a specific data domain

A data steward is accountable for the quality, governance, and appropriate use of data within an assigned domain or subject area.

Which XML technology is used to define rules for transforming an XML document into another format such as HTML or plain text?

Answer: XSLT

XSLT (Extensible Stylesheet Language Transformations) defines templates and rules for transforming XML documents into other document formats.

In an ETL pipeline, data is extracted from source systems, transformed, and then loaded into a target. What is the primary risk of performing heavy transformations before loading?

Answer: Processing bottlenecks can slow the entire pipeline and delay data availability

Complex transformation logic applied before loading can create processing bottlenecks that lengthen load windows and delay downstream availability.

A document repository stores metadata in a relational database and file content in a file system. What integration challenge does this 'split storage' model create?

Answer: Synchronization risk where metadata and files can become orphaned or mismatched

Split storage requires careful transactional coordination; if a file write succeeds but the metadata commit fails (or vice versa), records and files become orphaned or mismatched.