IICS Certification Mass Ingestion and Data Synchronization 3

Question 1

In IICS Mass Ingestion Databases, which source database types are typically supported for CDC?

Accepted Answer

Oracle, SQL Server, MySQL, PostgreSQL, and other major enterprise relational databases

Answer

Only cloud databases

Answer

Only flat files and CSV sources

Answer

Only NoSQL databases like MongoDB

Question 2

What does 'restart' capability in IICS Mass Ingestion CDC ensure?

Accepted Answer

Recovery from the last committed checkpoint so no data is lost or duplicated after a failure

Answer

Automatic reprocessing of all historical data from the beginning

Answer

Resetting the target table schema on each run

Answer

Restarting the Secure Agent service

Question 3

In IICS Data Synchronization tasks, what is 'upsert' mode?

Accepted Answer

Inserting new records and updating existing records based on a key match in a single operation

Answer

Inserting all records regardless of whether they exist in the target

Answer

Deleting all records before reloading

Answer

Synchronizing metadata without touching data rows

Question 4

Which IICS Mass Ingestion feature lets you monitor real-time ingestion metrics such as rows processed and latency?

Accepted Answer

Monitor tab with Mass Ingestion-specific dashboards

Answer

Secure Agent logs only

Answer

Database query against the target table

Answer

External APM tool required

Question 5

In IICS Mass Ingestion, what happens to the target table during an 'initial load and continue with CDC' run mode?

Accepted Answer

Target is truncated, fully loaded with source data, then CDC begins capturing ongoing changes

Answer

CDC starts immediately and initial load is skipped

Answer

Target receives only schema definitions without data rows initially

Answer

Initial load is run manually; CDC must be configured separately afterward

Question 6

What is the significance of 'source row ID' tracking in IICS Mass Ingestion CDC?

Accepted Answer

It assigns a unique identifier to each change event for deduplication and ordering at the target

Answer

It maps source primary keys to a new surrogate key at the target

Answer

It logs the database user who made each change

Answer

It records the row size for billing purposes