IICS Certification IICS Certification MCQ 5 — Questions and Answers
Question 1: What is the purpose of the 'Override' option when adding a field to a derived data object in IICS?
- It permanently deletes the original field from the source schema
- It allows you to change the data type or expression of a field inherited from the physical source (Correct answer)
- It creates a new index on the target table for that field
- It marks the field as sensitive so it is masked in the catalog
Correct answer: It allows you to change the data type or expression of a field inherited from the physical source
Overriding a field in a derived data object lets you customize its data type or derivation expression without altering the underlying source definition.
Question 2: In IICS Mass Ingestion Files, which setting determines how the task handles a file that was already successfully loaded in a previous run?
- Duplicate File Handling policy (Correct answer)
- Idempotency Mode
- File Processing State
- Re-run Behavior flag
Correct answer: Duplicate File Handling policy
The Duplicate File Handling policy controls whether previously loaded files are skipped, reloaded, or treated as errors.
Question 3: Which IICS component provides built-in governance lineage showing how data flows from source through transformations to target?
- Operational Insights
- CLAIRE lineage in Metadata Command Center (Correct answer)
- Data Integration Monitor
- Data Validation Option
Correct answer: CLAIRE lineage in Metadata Command Center
CLAIRE (Cloud AI-powered engine) in Metadata Command Center auto-generates end-to-end lineage graphs by scanning mapping metadata.
Question 4: When would you use a 'Synchronize' action on an existing IICS source or target object definition?
- To replicate the object to a secondary Secure Agent for high availability
- To refresh the object's schema after columns were added or removed in the underlying system (Correct answer)
- To publish the object to the CLAIRE catalog for lineage tracking
- To encrypt all string fields in the object definition
Correct answer: To refresh the object's schema after columns were added or removed in the underlying system
Synchronizing an object definition re-imports the current schema from the source system, keeping IICS metadata aligned with the actual data structure.
Question 5: In IICS, what does the 'Early Selection' optimization technique do in a mapping?
- It moves Filter transformations as early in the data flow as possible to reduce processed row count (Correct answer)
- It pre-caches source data before the mapping starts executing
- It selects the fastest available Secure Agent to run the mapping
- It applies pushdown to the source query to limit columns returned
Correct answer: It moves Filter transformations as early in the data flow as possible to reduce processed row count
Early Selection pushes filter logic upstream so fewer rows travel through subsequent transformations, improving overall mapping performance.
Question 6: Which IICS Application Integration feature allows you to expose a process as a callable HTTPS endpoint?
- Scheduled Process trigger
- Service Process with a REST API binding (Correct answer)
- File Listener with SFTP output
- Event Gateway with MQ binding
Correct answer: Service Process with a REST API binding
A Service Process with a REST binding publishes the process as a managed HTTPS URL that external clients can invoke synchronously.
Question 7: What is the significance of the 'Atomic' commit interval setting in an IICS mapping writing to a relational target?
- It sets the number of rows processed before the target connection is refreshed
- It defines how many rows are written per database transaction commit, balancing throughput and recoverability (Correct answer)
- It limits the number of rows per batch file sent to the target
- It controls how often IICS checkpoints progress to support mapping resume
Correct answer: It defines how many rows are written per database transaction commit, balancing throughput and recoverability
The commit interval determines transaction size: smaller intervals reduce data loss on failure but add overhead, while larger intervals improve throughput.
IICS Certification IICS Certification MCQ 5
What is the purpose of the 'Override' option when adding a field to a derived data object in IICS?