CSI Data Mapping & Transformation 3

Question 1

What is 'data normalization' in the context of data transformation?

Accepted Answer

Restructuring data to reduce redundancy and improve consistency, often conforming values to a standard range or format

Answer

Data normalization reorganizes data to minimize redundancy (database sense) or scales values to a standard range (statistical sense), improving data quality and consistency.

Question 2

In JSON-to-XML transformation, which mechanism is most commonly used in integration middleware?

Accepted Answer

XSLT 3.0 with JSON support or purpose-built middleware converters

Answer

Modern integration tools use XSLT 3.0 (which natively parses JSON) or dedicated JSON-to-XML converters built into middleware platforms like MuleSoft or Apache Camel.

Question 3

Which strategy resolves conflicts when the same entity appears with different attribute values in two source systems being merged?

Accepted Answer

Apply a survivorship rule to determine which source's value takes precedence

Answer

Survivorship rules define which source system's value 'wins' during master data consolidation, often based on recency, completeness score, or system-of-record priority.

Question 4

A transformation that replaces sensitive data with a format-preserving but fictitious value is called:

Accepted Answer

Data masking

Answer

Data masking replaces real sensitive data with realistic but fictitious values, maintaining the format and structure while protecting privacy in non-production environments.

Question 5

What does a 'lookup transformation' do in a data integration pipeline?

Accepted Answer

Retrieves reference data from an external table to enrich or validate incoming records

Answer

A lookup transformation queries a reference or dimension table to enrich incoming records with additional attributes or to validate foreign key values.

(CSI) Certified System Integrator Practice Test

(CSI) Certified System Integrator Practice Test

CSI Data Mapping & Transformation 3