Data Management & Integration Flashcards

Which indexing strategy is BEST suited for full-text search across large volumes of scanned documents that have been OCR'd?

Answer: Inverted index mapping terms to document locations

An inverted index maps each unique word to the list of documents containing it, enabling fast keyword lookup across massive text collections.

A data dictionary in a document management context primarily serves to:

Answer: Define the meaning, format, and rules for every data element in the system

A data dictionary is a centralized repository that defines each data element's name, type, allowable values, and business meaning, ensuring consistent use across the organization.

In data integration, what does 'idempotency' mean for a message processing operation?

Answer: Executing the operation multiple times produces the same result as executing it once

An idempotent operation can be safely retried without producing duplicate or unintended side effects, which is critical for reliable message-based integration.

Which data classification level typically requires the STRICTEST access controls and encryption in a CDT-managed repository?

Answer: Personally Identifiable Information (PII) / Restricted

PII and restricted data carry the highest regulatory and legal exposure, requiring the most stringent access controls, audit logging, and encryption at rest and in transit.

What is the key difference between 'structured' and 'unstructured' data in a document management context?

Answer: Structured data has a predefined schema (e.g., database tables); unstructured data lacks a fixed format (e.g., emails, scanned PDFs)

Structured data conforms to a predefined schema enabling direct querying, while unstructured data (documents, images, emails) lacks a consistent format and requires additional processing to extract meaning.

When performing a data migration, a 'cutover' strategy means:

Answer: Switching all users and processes to the new system at a specific point in time, decommissioning the old one

A cutover migration switches the entire organization to the new system at a defined moment, after which the old system is retired, typically requiring a maintenance window.

A CDT team discovers that the same customer address is stored in three different formats across integrated systems. Which data management practice resolves this long-term?

Answer: Master Data Management (MDM) with a single authoritative source of truth

MDM establishes a golden record and governance processes to synchronize a single authoritative version of key entities (like customer address) across all integrated systems.