CDT Data Management & Integration 2 — Questions and Answers
Question 1: Which data integration pattern uses a central hub to translate and route messages between disparate systems?
- Point-to-point integration
- Hub-and-spoke architecture (Correct answer)
- Batch file transfer
- Direct API chaining
Correct 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.
Question 2: In document management, what does 'data normalization' primarily achieve?
- Compresses file sizes for storage efficiency
- Eliminates redundancy and ensures data consistency across tables (Correct answer)
- Encrypts sensitive fields before archival
- Converts documents to a universal file format
Correct 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.
Question 3: 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?
- Data masking
- Fuzzy matching / probabilistic record linkage (Correct answer)
- Schema mapping
- Data partitioning
Correct 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.
Question 4: What is a 'data steward' responsible for in a document management environment?
- Writing ETL code and database queries
- Owning and enforcing data quality rules for a specific data domain (Correct answer)
- Managing physical server infrastructure
- Approving software license purchases
Correct 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.
Question 5: Which XML technology is used to define rules for transforming an XML document into another format such as HTML or plain text?
- XPath
- XSLT (Correct answer)
- XSD
- SOAP
Correct answer: XSLT
XSLT (Extensible Stylesheet Language Transformations) defines templates and rules for transforming XML documents into other document formats.
Question 6: 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?
- It reduces the need for target storage space
- Processing bottlenecks can slow the entire pipeline and delay data availability (Correct answer)
- It eliminates the need for data validation at the target
- It prevents the use of incremental loading strategies
Correct 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.
Question 7: 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?
- Higher CPU usage during OCR processing
- Synchronization risk where metadata and files can become orphaned or mismatched (Correct answer)
- Inability to support full-text search indexing
- Requirement for dedicated SAN storage
Correct 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.
CDT Data Management & Integration 2
Which data integration pattern uses a central hub to translate and route messages between disparate systems?