IICS Certification IICS Certification MCQ 4 — Questions and Answers
Question 1: Which IICS Data Quality transformation detects and standardizes inconsistent address formats?
- Parser transformation
- Address Validator transformation (Correct answer)
- Standardizer transformation
- Labeler transformation
Correct answer: Address Validator transformation
The Address Validator transformation uses reference data to parse, validate, and standardize postal addresses to a consistent format.
Question 2: In IICS, what does enabling 'Truncate Target' on a mapping task do before writing records?
- Drops and recreates the target table schema
- Deletes all existing rows from the target before inserting new ones (Correct answer)
- Removes duplicate rows from the source before loading
- Shrinks the target file to save storage space
Correct answer: Deletes all existing rows from the target before inserting new ones
Truncate Target issues a TRUNCATE (or equivalent) on the target object before the mapping inserts fresh data, implementing a full-replace load pattern.
Question 3: Which IICS service is best suited for ingesting high-volume streaming data from Kafka topics into a cloud data warehouse?
- Data Integration Mapping
- Streaming Ingestion (Mass Ingestion Streaming) (Correct answer)
- Application Integration Event Trigger
- B2B Gateway
Correct answer: Streaming Ingestion (Mass Ingestion Streaming)
Mass Ingestion Streaming is designed for continuous, low-latency ingestion from messaging systems like Kafka into cloud targets.
Question 4: In the IICS Administrator, what does setting a Secure Agent group's 'Max Concurrent Jobs' limit control?
- The maximum number of IPUs the agent group can consume per hour
- The maximum number of tasks that can run simultaneously on that agent group (Correct answer)
- The maximum number of users who can run tasks on the agent group at the same time
- The maximum number of connections the agent can open to source systems
Correct answer: The maximum number of tasks that can run simultaneously on that agent group
Max Concurrent Jobs caps parallel task execution on the agent group, preventing resource exhaustion on the underlying server.
Question 5: Which parameter type in an IICS parameterized mapping lets you override a connection object at runtime?
- String parameter with a connection name value
- Connection parameter (type = Connection) (Correct answer)
- Mapping configuration parameter
- System-defined $DBConnection variable
Correct answer: Connection parameter (type = Connection)
A Connection parameter of type 'Connection' allows the caller to supply a different connection object when the mapping task is invoked, enabling reuse across environments.
Question 6: In IICS Cloud Data Integration, what is a 'Mapping Configuration Task' (MCT)?
- A visual canvas for building reusable mapping logic
- A task that runs a reusable mapping with a specific set of runtime parameters (Correct answer)
- A scheduled job that monitors mapping performance metrics
- A version-control snapshot of a mapping asset
Correct answer: A task that runs a reusable mapping with a specific set of runtime parameters
An MCT binds a published mapping to a specific set of runtime parameter values, allowing the same mapping logic to serve multiple use cases.
Question 7: Which IICS security feature restricts which data assets a user can view in the CLAIRE catalog based on their role?
- IP Allowlisting
- Column Masking Policy
- Asset-level permissions in Metadata Command Center (Correct answer)
- Row-Level Security in Data Integration
Correct answer: Asset-level permissions in Metadata Command Center
Metadata Command Center applies asset-level and resource-group permissions so users only see catalog assets authorized for their role.
IICS Certification IICS Certification MCQ 4
Which IICS Data Quality transformation detects and standardizes inconsistent address formats?