IICS Certification IICS Certification 2 — Questions and Answers
Question 1: Which IICS service is used to synchronize data between two applications in real time using event-driven integration?
- Application Integration (Correct answer)
- Data Integration
- Mass Ingestion
- API Center
Correct answer: Application Integration
Application Integration in IICS handles event-driven, real-time synchronization between applications using processes and connectors.
Question 2: In IICS Data Integration, what is the purpose of a Sequence Generator transformation?
- Generate unique numeric values for rows (Correct answer)
- Create a sequence of mappings to run
- Order rows by a specified column
- Generate primary keys from source data
Correct answer: Generate unique numeric values for rows
The Sequence Generator transformation produces unique, incrementing numeric values that can be used as surrogate keys or row identifiers.
Question 3: What does the 'Pushdown Optimization' feature in IICS Data Integration do?
- Pushes transformation logic to the source or target database for execution (Correct answer)
- Compresses data before pushing it to the target
- Offloads processing to a Spark cluster
- Sends mapping metadata to the Informatica cloud repository
Correct answer: Pushes transformation logic to the source or target database for execution
Pushdown Optimization (PDO) translates transformation logic into SQL and executes it directly on the source or target database, reducing data movement.
Question 4: Which connection property must be configured to enable SSL encryption when connecting to a MySQL database in IICS?
- Use SSL (Correct answer)
- Encryption Level
- Secure Connection Mode
- TLS Version
Correct answer: Use SSL
The 'Use SSL' property in the MySQL connection configuration enables SSL-encrypted communication between the Secure Agent and the MySQL server.
Question 5: In an IICS mapping, the Joiner transformation requires data from two sources. What is the role of the 'Detail' pipeline?
- It provides the larger dataset that is not cached in memory (Correct answer)
- It provides the smaller dataset that is cached in memory
- It defines the join condition columns
- It specifies the output schema of the join
Correct answer: It provides the larger dataset that is not cached in memory
The Detail pipeline in a Joiner transformation carries the larger dataset that is read sequentially, while the Master pipeline data is cached.
Question 6: What is the function of the 'Truncate Target Table' option in an IICS mapping task?
- Delete all rows from the target table before loading new data (Correct answer)
- Drop and recreate the target table schema
- Remove duplicate rows from the target after load
- Truncate the source staging table after reading
Correct answer: Delete all rows from the target table before loading new data
Enabling 'Truncate Target Table' causes IICS to delete all existing rows from the target table before inserting the new data, implementing a full refresh pattern.
Question 7: Which IICS feature allows you to monitor all running and completed jobs across multiple tasks from a single view?
- My Jobs
- Activity Monitor (Correct answer)
- Task Flow Designer
- Operational Insights
Correct answer: Activity Monitor
Activity Monitor in IICS provides a centralized view of running, completed, and failed jobs across all task types and runtimes.
IICS Certification IICS Certification 2
Which IICS service is used to synchronize data between two applications in real time using event-driven integration?