IICS Certification IICS Certification 4 — Questions and Answers
Question 1: In IICS, what does the 'Update Strategy' transformation control?
- Whether rows are inserted, updated, deleted, or rejected in the target (Correct answer)
- The order in which rows are written to the target
- The conflict resolution strategy for duplicate keys
- The commit interval for target writes
Correct answer: Whether rows are inserted, updated, deleted, or rejected in the target
The Update Strategy transformation tags each row with a flag (DD_INSERT, DD_UPDATE, DD_DELETE, DD_REJECT) that tells the target transformation how to handle that row.
Question 2: What is the default behavior of the IICS Secure Agent when it cannot connect to the IICS cloud services?
- It queues jobs locally and retries the connection periodically (Correct answer)
- It stops processing all jobs immediately
- It switches to a backup agent in the group
- It runs jobs using cached metadata until reconnected
Correct answer: It queues jobs locally and retries the connection periodically
The Secure Agent queues incoming job requests locally and retries connecting to IICS cloud services, allowing brief outages without losing scheduled jobs.
Question 3: Which IICS service provides a low-code environment to build and orchestrate multi-step business processes with human approval steps?
- Application Integration (Correct answer)
- Data Integration
- B2B Gateway
- Data Quality
Correct answer: Application Integration
Application Integration in IICS supports process design including human task steps for approval workflows within orchestrated business processes.
Question 4: In IICS Data Integration, what is the effect of enabling 'High Precision' for a Decimal port?
- Preserves precision up to 28 significant digits for numeric calculations (Correct answer)
- Rounds decimal values to 2 decimal places
- Converts decimal values to double-precision floating point
- Stores decimals as strings to avoid rounding
Correct answer: Preserves precision up to 28 significant digits for numeric calculations
High Precision mode maintains up to 28 significant digits for Decimal data types, preventing rounding errors in financial or scientific calculations.
Question 5: What is the purpose of the 'Pre-SQL' and 'Post-SQL' options available in IICS source and target transformations?
- Execute custom SQL commands before and after reading or writing data (Correct answer)
- Define the SQL query used to extract source data
- Validate source data quality before processing
- Log SQL execution plans for performance tuning
Correct answer: Execute custom SQL commands before and after reading or writing data
Pre-SQL and Post-SQL allow you to run arbitrary SQL (e.g., disabling indexes, truncating staging tables) immediately before or after the main data operation.
Question 6: In IICS, which type of schedule allows a task to be triggered by the completion of another task rather than a clock time?
- Taskflow with a sequence of tasks (Correct answer)
- Chained Schedule
- Event-Based Trigger
- Dependency Schedule
Correct answer: Taskflow with a sequence of tasks
A Taskflow in IICS orchestrates multiple tasks in sequence or parallel, triggering downstream tasks upon the success or failure of upstream ones.
Question 7: Which IICS Data Quality transformation assigns confidence scores and standardizes address data using reference datasets?
- Address Validator (Correct answer)
- Data Masking
- Labeler
- Exception
Correct answer: Address Validator
The Address Validator transformation in IICS Data Quality parses, corrects, and standardizes postal addresses using country-specific reference data and assigns match confidence scores.
IICS Certification IICS Certification 4
In IICS, what does the 'Update Strategy' transformation control?