Data Management & Integration Flashcards

Which technology standard defines schemas for validating the structure and data types within an XML document?

Answer: XML Schema Definition (XSD)

XSD (XML Schema Definition) specifies the allowable elements, attributes, and data types within an XML document, enabling automated validation.

In a data warehouse supporting document analytics, what does a 'slowly changing dimension' (SCD Type 2) track?

Answer: Historical changes to dimension attributes by adding new rows with effective date ranges

SCD Type 2 preserves history by inserting a new row with updated values and date range stamps each time a dimension attribute changes, allowing historical reporting.

What is 'data latency' in the context of document management system integration?

Answer: The delay between when data is created or changed at the source and when it is available in the target system

Data latency measures how current the integrated data is; batch integrations have higher latency than real-time or near-real-time streaming approaches.

Which approach allows an organization to query data across multiple source systems without physically moving it to a central location?

Answer: Data virtualization / federated query

Data virtualization creates a logical abstraction layer that enables queries across distributed data sources in real time without physically consolidating the data.

When a document management system publishes events (e.g., 'document approved') to a message broker, and downstream systems subscribe to those events, this follows which integration pattern?

Answer: Publish-subscribe (pub/sub) event-driven architecture

Pub/sub decouples producers and consumers; the DMS publishes events without knowing who subscribes, enabling scalable, loosely-coupled integration.

A regulatory audit requires proving that a specific document has not been altered since it was ingested. Which technical mechanism provides this assurance?

Answer: Cryptographic hash (checksum) stored at ingestion and compared at retrieval

A cryptographic hash (e.g., SHA-256) computed at ingestion and recomputed at retrieval will differ if any bit of the document has changed, proving integrity.

In a CDT context, what does 'data profiling' involve?

Answer: Analyzing a data set to understand its structure, content, quality, and relationships before integration or migration

Data profiling examines source data to assess completeness, consistency, uniqueness, and format compliance, revealing quality issues before they enter a target system.