System Architecture & Design Flashcards

Which IICS architecture component acts as a central registry for all data assets, lineage, and governance policies?

Answer: Cloud Data Governance and Catalog

Cloud Data Governance and Catalog provides a centralized registry for discovering, classifying, and governing all data assets along with lineage tracking.

What is the role of the 'Mapping Task' in IICS as opposed to the 'Mapping' itself?

Answer: A Mapping defines transformation logic; a Mapping Task configures runtime settings for execution

A Mapping contains the data flow and transformation logic, while a Mapping Task wraps that mapping with runtime configurations like connections, parameters, and scheduling.

Which approach in IICS best supports an ELT (Extract, Load, Transform) pattern for a cloud data warehouse?

Answer: Using pushdown optimization or serverless runtime to execute SQL on the warehouse

Pushdown optimization or serverless runtime pushes transformation SQL directly to the data warehouse engine, implementing the ELT pattern natively.

In IICS, what distinguishes a 'Synchronization Task' from a standard 'Mapping Task'?

Answer: Synchronization Tasks offer a simplified wizard for source-to-target sync with built-in upsert logic

A Synchronization Task provides a guided wizard interface for simple source-to-target synchronization with built-in insert, update, delete, and upsert operations.

When using IICS Cloud Application Integration to expose a REST API, which component defines the API contract and routes incoming requests?

Answer: API Service

An API Service in Cloud Application Integration defines the REST endpoint, HTTP methods, request/response schema, and routes calls to process flows.

Which IICS feature enables Change Data Capture (CDC) from relational databases to stream only modified rows?

Answer: Mass Ingestion — Databases with CDC mode

Mass Ingestion — Databases with CDC mode uses database log-based capture to stream only inserted, updated, or deleted rows rather than full table loads.

In IICS architecture, what is the function of the 'Data Preview' feature in a mapping design?

Answer: It runs a sample of data through the transformation logic at design time to validate results

Data Preview executes a sample of source rows through all transformations in the mapping designer so developers can validate logic without a full run.