ICC System Architecture & Design 3

Question 1

In Informatica Cloud Data Integration, which transformation is used to route rows to different targets based on a condition?

Accepted Answer

Router

Answer

The Router transformation evaluates conditions on each row and directs it to the appropriate output group based on those conditions.

Question 2

Which IICS design pattern should be used when real-time event-driven integration is required between cloud applications?

Accepted Answer

Cloud Application Integration with process flows

Answer

Cloud Application Integration supports event-driven architectures using process flows, API services, and triggers for real-time integration.

Question 3

What is the primary architectural advantage of using pushdown optimization in IICS mappings?

Accepted Answer

It offloads transformation logic to the database engine, reducing data movement

Answer

Pushdown optimization translates mapping logic into SQL and executes it on the source or target database, minimizing data movement to the agent.

Question 4

In IICS, which feature allows a single mapping to dynamically switch its source or target object at runtime?

Accepted Answer

Parameterization

Answer

Parameterization lets you define parameters for connection names, object names, and filter conditions, enabling the same mapping to run against different sources or targets.

Question 5

Which IICS service is best suited for ingesting large volumes of data from files into a cloud data warehouse like Snowflake?

Accepted Answer

Mass Ingestion — Files

Answer

Mass Ingestion — Files is designed to efficiently load large file datasets into cloud data warehouses and data lakes at scale.

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC System Architecture & Design 3