IICS Certification IICS Certification MCQ 2 — Questions and Answers
Question 1: Which IICS service is used to run data integration tasks in real time using event-driven triggers?
- Application Integration (Correct answer)
- Data Integration
- Mass Ingestion
- API Center
Correct answer: Application Integration
Application Integration in IICS supports event-driven, real-time process orchestration and API-based integration.
Question 2: In IICS Data Integration, what is the purpose of a 'Pushdown Optimization' setting on a mapping?
- It compresses data before writing to the target
- It shifts processing logic to the source or target database engine (Correct answer)
- It caches lookup data in memory on the Secure Agent
- It distributes tasks across multiple Secure Agent nodes
Correct answer: It shifts processing logic to the source or target database engine
Pushdown Optimization offloads transformation logic to the native database engine, reducing data movement and improving performance.
Question 3: Which license type in IICS allows an organization to process an unlimited number of rows for a flat monthly fee?
- Row-based license
- IPU (Informatica Processing Unit) license (Correct answer)
- Subscription license
- Enterprise Data Management license
Correct answer: IPU (Informatica Processing Unit) license
IPU-based licensing meters consumption by compute units rather than rows, enabling predictable cost regardless of volume.
Question 4: What does the 'Incremental Load' option in a Mass Ingestion Databases task control?
- It loads only rows modified since the last successful run using a watermark (Correct answer)
- It splits the source table into parallel chunks for faster loading
- It deduplicates records before inserting them into the target
- It compresses the data file during transfer to reduce bandwidth
Correct answer: It loads only rows modified since the last successful run using a watermark
Incremental Load uses a high-watermark column (such as a timestamp) to fetch only changed or new rows since the previous run.
Question 5: In IICS, which component is responsible for executing mappings and tasks on-premises or in a private cloud?
- Informatica Cloud Hosted Agent
- Secure Agent (Correct answer)
- Cloud Server
- Runtime Environment Manager
Correct answer: Secure Agent
The Secure Agent is the lightweight executable installed within the customer's network that performs data processing locally.
Question 6: When configuring a REST V2 connection in IICS, which authentication method uses a bearer token obtained from an OAuth 2.0 endpoint?
- Basic Authentication
- API Key
- OAuth 2.0 Client Credentials (Correct answer)
- Mutual TLS
Correct answer: OAuth 2.0 Client Credentials
OAuth 2.0 Client Credentials flow exchanges a client ID and secret for a bearer token used to authenticate subsequent API calls.
Question 7: Which IICS feature enables you to compare source and target row counts and flag discrepancies after a mapping run?
- Data Validation Option (DVO) (Correct answer)
- Operational Insights
- Monitor Dashboard
- Data Quality scorecard
Correct answer: Data Validation Option (DVO)
DVO performs post-run reconciliation by comparing counts and checksums between source and target datasets.
IICS Certification IICS Certification MCQ 2
Which IICS service is used to run data integration tasks in real time using event-driven triggers?