Informatica IICS Certification Exam — Questions and Answers

Question 1: When configuring a REST V2 connection in IICS, which authentication method uses a bearer token obtained from an OAuth 2.0 endpoint?

API Key
Basic Authentication
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 2: In IICS Application Integration, what does a 'Gateway' step provide?

A mechanism to send email notifications
A branching point that routes process flow based on conditions (exclusive or parallel) (Correct answer)
A data transformation utility
A way to call an external HTTP endpoint

Correct answer: A branching point that routes process flow based on conditions (exclusive or parallel)

A Gateway step introduces decision logic into a process, routing execution along different paths based on conditional or parallel branching.

Question 3: In IICS Mass Ingestion Files, which setting determines how the task handles a file that was already successfully loaded in a previous run?

Re-run Behavior flag
File Processing State
Idempotency Mode
Duplicate File Handling policy (Correct answer)

Correct answer: Duplicate File Handling policy

The Duplicate File Handling policy controls whether previously loaded files are skipped, reloaded, or treated as errors.

Question 4: What is the purpose of the 'Test Connection' functionality in IICS?

Test network latency between two Secure Agents
Verify that a Secure Agent can reach IICS cloud services
Validate that a user's authentication token is still active
Confirm that configured connection parameters can reach the target data source (Correct answer)

Correct answer: Confirm that configured connection parameters can reach the target data source

The Test Connection feature in IICS verifies that the connection object's configured parameters—such as host, credentials, and port—can successfully establish a live connection to the data source or target.

Question 5: Which IICS service is primarily used to design and run data integration mappings in the cloud?

API Management
Mass Ingestion
Application Integration
Data Integration (Correct answer)

Correct answer: Data Integration

Data Integration is the IICS service used to design, run, and manage cloud-based data integration mappings.

Question 6: Which IICS security feature allows administrators to restrict user access to specific assets, folders, or connections based on group membership?

IP Allowlist
Row-Level Security
Asset Permissions (Correct answer)
Data Masking Policy

Correct answer: Asset Permissions

Asset Permissions in IICS let administrators grant or restrict read, write, and execute access to folders and assets based on user roles and groups.

Question 7: In IICS, which organization-level setting controls the maximum number of concurrent jobs that can run across all agents in an agent group?

Max Concurrent Jobs (Correct answer)
Agent Throttle Limit
Job Queue Depth
Runtime Resource Pool

Correct answer: Max Concurrent Jobs

The Max Concurrent Jobs setting at the agent group level limits how many jobs can execute simultaneously, preventing resource contention on the Secure Agent servers.

Question 8: Which IICS Application Integration feature lets you test a process with sample input data before deploying it?

Advanced Cluster Preview
Process Simulator / Test Run (Correct answer)
Mapping Validation
Run with Debug

Correct answer: Process Simulator / Test Run

The Test Run or process simulator allows you to execute a process with sample inputs in design mode to verify behavior before deployment.

Question 9: Which binding type in IICS Application Integration enables a process to be triggered by a message on a queue or topic?

SOAP binding
REST binding
JMS / messaging binding (Correct answer)
File binding

Correct answer: JMS / messaging binding

A JMS or messaging binding subscribes a process to a message queue or topic, triggering execution when a message arrives.

Question 10: What does 'error handling' in an IICS Application Integration process allow you to do?

Delete failed records from the source
Automatically restart failed Secure Agents
Define catch steps that handle exceptions and route execution to recovery logic (Correct answer)
Notify Informatica support automatically

Correct answer: Define catch steps that handle exceptions and route execution to recovery logic

Error handling in a process lets you define catch scopes that intercept exceptions and execute recovery or notification logic.

Question 11: What is 'Data Synchronization' in IICS, and how does it differ from Data Integration mappings?

Data Synchronization runs in real time; Data Integration is batch only
Data Synchronization is a wizard-driven task for simple source-to-target sync without coding; Data Integration uses full mapping design (Correct answer)
They are identical features with different names
Data Synchronization only works with files; Data Integration works with databases

Correct answer: Data Synchronization is a wizard-driven task for simple source-to-target sync without coding; Data Integration uses full mapping design

Data Synchronization tasks use a simplified wizard interface for straightforward data sync scenarios, while Data Integration provides a full mapping canvas for complex transformations.

Question 12: In IICS Application Integration, what is a 'Service Connector'?

A type of process trigger based on a file event
A data masking utility for PII fields
A database table used for process logging
A pre-built adapter that enables connection to a specific SaaS or on-premise application (Correct answer)

Correct answer: A pre-built adapter that enables connection to a specific SaaS or on-premise application

A Service Connector is a pre-built, reusable adapter that provides out-of-the-box connectivity to specific SaaS or enterprise applications.

Question 13: What is 'API mocking' in the context of IICS API Center development?

Generating synthetic test data for data integration tasks
Simulating an API's responses without a real backend, enabling consumers to develop against it before the implementation is ready (Correct answer)
Testing security policies by sending malformed requests
Creating a duplicate of a production API for load testing

Correct answer: Simulating an API's responses without a real backend, enabling consumers to develop against it before the implementation is ready

API mocking returns simulated responses based on the API definition, allowing consumer teams to start development before the backend integration is complete.

Question 14: What is the role of a 'Guide' in IICS Application Integration?

A data profiling tool for source analysis
A user-facing wizard-style form that captures input and triggers a process (Correct answer)
A debugging utility for process runs
A reusable transformation template

Correct answer: A user-facing wizard-style form that captures input and triggers a process

A Guide provides a configurable multi-step UI form that collects user input and can trigger an underlying Application Integration process.

Question 15: Which IICS Mass Ingestion feature lets you monitor real-time ingestion metrics such as rows processed and latency?

Database query against the target table
Monitor tab with Mass Ingestion-specific dashboards (Correct answer)
Secure Agent logs only
External APM tool required

Correct answer: Monitor tab with Mass Ingestion-specific dashboards

The Monitor tab in IICS provides real-time and historical metrics for Mass Ingestion tasks including rows processed, apply latency, and error counts.

Question 16: You can process data using Mapping Configuration Tasks according to the data flow logic specified in:

False
True (Correct answer)

Correct answer: True

Data Warehousing (DW) is a process for collecting, storing, and managing data from various sources to provide meaningful business insights and support decision-making. <br> A data warehouse is a central repository that consolidates data from different operational systems, such as transactional databases, CRM systems, ERP systems, and more. The data is extracted, transformed, and loaded (ETL) into the data warehouse, where it is organized in a structured manner to support reporting, analysis, and data mining.

Question 17: In IICS API Center, what is an 'API Collection'?

A library of pre-built connector adapters
A set of related APIs grouped together for joint publication, versioning, and access control (Correct answer)
A collection of Secure Agent configurations
A folder of mapping objects

Correct answer: A set of related APIs grouped together for joint publication, versioning, and access control

An API Collection groups related APIs for shared lifecycle management, including publication, versioning, and applying security policies.

Question 18: What is 'request transformation' in IICS API Center?

Converting REST requests to file format for archival
Transforming database rows before writing to the target
Modifying or mapping the incoming API request payload before it reaches the backend process (Correct answer)
Encrypting request payloads at the gateway level

Correct answer: Modifying or mapping the incoming API request payload before it reaches the backend process

Request transformation allows the API gateway to modify, map, or enrich the incoming request payload before passing it to the backend integration process.

Question 19: In IICS API Management, what is 'API Analytics' used for?

Tracking API usage metrics such as call volume, latency, error rates, and consumer activity (Correct answer)
Profiling source data quality before ingestion
Analyzing ETL job performance and row throughput
Auditing user login activity across the platform

Correct answer: Tracking API usage metrics such as call volume, latency, error rates, and consumer activity

API Analytics provides visibility into how APIs are being used — including call counts, latency trends, error rates, and which consumers are most active.

Question 20: In IICS Data Integration, what does 'pushdown optimization' do?

Splits large files into partitions
Compresses data before writing to target
Caches lookup data in memory
Pushes transformation logic into the database engine to improve performance (Correct answer)

Correct answer: Pushes transformation logic into the database engine to improve performance

Pushdown optimization translates mapping logic into native SQL and executes it directly on the database, reducing data movement.

Question 21: In IICS, what does 'API lifecycle management' encompass?

Controlling the lifecycle of Secure Agent updates
The end-to-end process of designing, publishing, versioning, deprecating, and retiring APIs (Correct answer)
Managing ETL job run lifecycles from start to finish
Managing the deployment lifecycle of IICS itself

Correct answer: The end-to-end process of designing, publishing, versioning, deprecating, and retiring APIs

API lifecycle management covers all phases of an API's existence from initial design and publishing through versioning, deprecation, and eventual retirement.

Question 22: Which IICS feature allows administrators to receive email notifications when a scheduled job fails?

Alerts (Correct answer)
Runtime Notifications
Activity Monitor
Job Scheduler

Correct answer: Alerts

IICS Alerts can be configured to send email notifications to specified recipients when jobs fail, succeed, or meet other defined conditions.

Question 23: Monitoring jobs involving application integration is done with a monitor.

False (Correct answer)
True

Correct answer: False

The Monitor component in the Application Integration Console of Informatica Cloud/IICS is used for monitoring application integration jobs. The Monitor component provides visibility into the execution and status of integration processes and workflows.

Question 24: Which IICS Mass Ingestion option allows you to select specific tables from a source database rather than ingesting all tables?

Table filters / table selection in the task configuration (Correct answer)
You must ingest all tables and filter at the target
Custom SQL in the Source transformation
Schema-level inclusion rules only

Correct answer: Table filters / table selection in the task configuration

The Mass Ingestion task configuration includes a table selection panel where you can include or exclude specific tables for ingestion.

Question 25: In IICS Application Integration, what is an 'Assignment' step used for?

Sending a notification to a user
Setting the value of a process variable or field (Correct answer)
Routing flow along a conditional branch
Calling an external web service

Correct answer: Setting the value of a process variable or field

An Assignment step sets or updates the value of a variable or output field within the process flow.

Question 26: Which IICS transformation splits incoming rows into multiple output groups based on conditions?

Router (Correct answer)
Normalizer
Lookup
Sorter

Correct answer: Router

The Router transformation evaluates conditions and routes each row to one of multiple output groups.

Question 27: The following components are part of Informatica Cloud (IICS):

Application Integration Console
Data Integration
Application Integration
All of the above (Correct answer)

Correct answer: All of the above

These components work together to provide a comprehensive cloud-based integration platform that supports both data integration and application integration requirements. Informatica Cloud/IICS offers a range of features and functionalities to connect, transform, and govern data, as well as to orchestrate and manage integrations between diverse systems and applications.

Question 28: OLAP is standing for

Online Analytical Program
Online Analytical Processing (Correct answer)
Online Analytical publishing
Online Analytical Processing

Correct answer: Online Analytical Processing

Online Analytical Processing (OLAP) refers to a category of software tools and technologies used for analyzing multidimensional data from various perspectives. It enables users to perform complex and interactive analysis on large datasets with a focus on business intelligence and decision support.

Question 29: In IICS, what does enabling 'Truncate Target' on a mapping task do before writing records?

Drops and recreates the target table schema
Removes duplicate rows from the source before loading
Shrinks the target file to save storage space
Deletes all existing rows from the target before inserting new ones (Correct answer)

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 30: In IICS Mass Ingestion, what is a 'deployment' and why is it needed?

The step that activates and persists a Mass Ingestion task configuration, making it ready to run (Correct answer)
A backup of the IICS organization settings
A code release of the IICS platform itself
A test run of the task in sandbox mode

Correct answer: The step that activates and persists a Mass Ingestion task configuration, making it ready to run

Deploying a Mass Ingestion task activates its configuration, creates necessary objects at the target, and prepares it for execution.

Question 31: Which step type in an IICS Application Integration Process is used to call an external REST or SOAP web service?

Service Call (Correct answer)
Assignment
Notification
Gateway

Correct answer: Service Call

A Service Call step invokes an external web service (REST or SOAP) within an Application Integration process flow.

Question 32: In IICS Application Integration, what does a 'Notification' step do?

Triggers an external REST API call
Assigns a task to a human approver
Archives process run data to a file
Sends an email, SMS, or platform alert as part of the process flow (Correct answer)

Correct answer: Sends an email, SMS, or platform alert as part of the process flow

A Notification step sends messages such as email or SMS to recipients as part of the process execution.

Question 33: In IICS API Center (API Management), what is the role of a 'Managed API'?

An API automatically generated from a Data Integration mapping
An internal API only accessible within the IICS organization
A published API endpoint secured and governed by API Center policies (Correct answer)
A connector API managed by Informatica Support

Correct answer: A published API endpoint secured and governed by API Center policies

A Managed API in IICS API Center is an API endpoint that is published, secured with policies (throttling, authentication), and monitored through the API gateway.

Question 34: In IICS, what does the 'Update Strategy' transformation control?

The commit interval for target writes
The order in which rows are written to the target
The conflict resolution strategy for duplicate keys
Whether rows are inserted, updated, deleted, or rejected in the target (Correct answer)

Correct answer: Whether rows are inserted, updated, deleted, or rejected in the target

The Update Strategy transformation tags each row with a flag (DD_INSERT, DD_UPDATE, DD_DELETE, DD_REJECT) that tells the target transformation how to handle that row.

Question 35: Which IICS transformation is used to look up values in a relational table or flat file to enrich pipeline data?

Aggregator
Joiner
Expression
Lookup (Correct answer)

Correct answer: Lookup

The Lookup transformation queries a lookup source (table or file) to retrieve matching values, commonly used to get surrogate keys or reference data.

Question 36: What is an 'OAuth 2.0' policy in IICS API Center used for?

Encrypting the API response payload
Securing API access using OAuth 2.0 token-based authentication and authorization (Correct answer)
Transforming API request payloads automatically
Limiting the number of API calls per minute

Correct answer: Securing API access using OAuth 2.0 token-based authentication and authorization

An OAuth 2.0 policy enforces token-based security on APIs, requiring callers to present a valid OAuth access token issued by an authorization server.

Question 37: In IICS Application Integration, what is a 'Process'?

A scheduled data sync task
A database connection configuration
An orchestration flow that defines steps, decisions, and service calls for integration logic (Correct answer)
A batch ETL job

Correct answer: An orchestration flow that defines steps, decisions, and service calls for integration logic

A Process in Application Integration is an orchestration artifact that sequences steps such as service calls, decisions, and assignments to implement integration logic.

Question 38: How long does IICS retain job execution logs by default before they are purged?

90 days
60 days
30 days (Correct answer)
7 days

Correct answer: 30 days

IICS retains job execution logs for 30 days by default, after which they are automatically purged from the system.

Question 39: What is the purpose of 'API subscription plans' in IICS API Center?

Defining which IICS services a user can access
Defining different tiers of access with varying rate limits, quotas, and features for different consumer categories (Correct answer)
Setting the billing plan for IICS platform usage
Scheduling when APIs are available for consumption

Correct answer: Defining different tiers of access with varying rate limits, quotas, and features for different consumer categories

Subscription plans let API providers offer different access tiers — for example, basic vs. premium — each with different rate limits and allowed features.

Question 40: Which IICS connector framework allows Informatica partners and customers to build custom connectors using a documented SDK?

Connector Developer Kit
Extension Builder
Connector Toolkit (Correct answer)
Custom Agent Plugin

Correct answer: Connector Toolkit

The Informatica Connector Toolkit is the SDK that enables partners and customers to develop custom connectors and publish them to the IICS marketplace.

Question 41: 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
Generate primary keys from source data
Order rows by a specified column

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 42: What is the primary purpose of IICS Application Integration (formerly known as Cloud Application Integration or CAI)?

Running large batch ETL jobs
Orchestrating real-time and event-driven process integrations between applications (Correct answer)
Managing user access roles
Storing data in cloud data warehouses

Correct answer: Orchestrating real-time and event-driven process integrations between applications

Application Integration handles real-time, event-driven, and process-based integrations, orchestrating data and logic flows between applications.

Question 43: In IICS API Center, what is an 'API Consumer'?

A Secure Agent that routes API traffic
An Informatica-managed gateway server
An internal IICS user who designs APIs
An application, developer, or system that subscribes to and calls a published API (Correct answer)

Correct answer: An application, developer, or system that subscribes to and calls a published API

An API Consumer is the external application, developer, or system that subscribes to and invokes a published API through API Center.

Question 44: What does the 'Developer Portal' in IICS API Center provide to API consumers?

A monitoring dashboard for Secure Agent health
A code repository for storing IICS assets
A GUI for designing Application Integration processes
A self-service portal where developers can discover APIs, view documentation, and obtain access credentials (Correct answer)

Correct answer: A self-service portal where developers can discover APIs, view documentation, and obtain access credentials

The Developer Portal is a self-service web interface where API consumers can browse available APIs, read documentation, and subscribe for access.

Question 45: What is a 'Connection Factory' used for in IICS Application Integration?

Generating data transformations automatically
Defining reusable connection parameters for a service endpoint (Correct answer)
Scheduling process runs on a timer
Managing process error handling globally

Correct answer: Defining reusable connection parameters for a service endpoint

A Connection Factory stores reusable endpoint connection details such as URL and credentials for use across multiple processes.

Question 46: Salesforce and Informatica Cloud may be integrated in real time.

True (Correct answer)
False

Correct answer: True

Informatica Cloud can facilitate real-time integration with Salesforce. Informatica Cloud offers specific connectors, features, and capabilities designed to integrate and synchronize data between Salesforce and other systems or applications in real-time.

Question 47: Which IICS Cloud Integration Hub feature allows publishers to share data streams that multiple subscriber applications can independently consume?

Topics and Queues
Feeds and Webhooks
Publications and Subscriptions (Correct answer)
Events and Triggers

Correct answer: Publications and Subscriptions

Cloud Integration Hub uses a publish/subscribe model where data publications are made available for multiple subscriber applications to independently consume.

Question 48: In IICS Application Integration, what is the purpose of a 'Subprocess' step?

Runs a Data Integration mapping inline
Calls another Application Integration process as a reusable sub-component (Correct answer)
Sends an asynchronous message to a queue
Queries a database directly

Correct answer: Calls another Application Integration process as a reusable sub-component

A Subprocess step calls another process as a reusable modular component, enabling process decomposition and reuse.

Question 49: Which object in IICS Application Integration defines the data structure passed between steps in a process?

Taskflow
Schema / Service Object (Correct answer)
Mapping
Connection Factory

Correct answer: Schema / Service Object

Service Objects (schemas) define the data structure — fields and types — used as inputs and outputs for process steps.

Question 50: The Primary Key allows null values.

True
False (Correct answer)

Correct answer: False

In most traditional database systems, nulls are not allowed in primary keys. A primary key is a column or combination of columns that uniquely identifies each row in a table. The primary key ensures data integrity and provides a way to uniquely identify and reference individual records.

Question 51: In IICS, which type of schedule allows a task to be triggered by the completion of another task rather than a clock time?

Taskflow with a sequence of tasks (Correct answer)
Event-Based Trigger
Dependency Schedule
Chained Schedule

Correct answer: Taskflow with a sequence of tasks

A Taskflow in IICS orchestrates multiple tasks in sequence or parallel, triggering downstream tasks upon the success or failure of upstream ones.

Question 52: In IICS Cloud Data Integration, what is a 'Mapping Configuration Task' (MCT)?

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
A visual canvas for building reusable mapping logic

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 53: What is 'Mass Ingestion' in IICS primarily designed for?

Building REST API endpoints for external consumers
Running complex multi-step orchestration workflows
Designing custom data transformations
High-volume, efficient ingestion of data from databases or files into cloud targets with minimal configuration (Correct answer)

Correct answer: High-volume, efficient ingestion of data from databases or files into cloud targets with minimal configuration

Mass Ingestion is optimized for high-volume bulk data loading from databases or files into cloud data warehouses or data lakes with minimal setup.

Question 54: What does the 'Incremental Load' option in a Mass Ingestion Databases task control?

It deduplicates records before inserting them into the target
It splits the source table into parallel chunks for faster loading
It compresses the data file during transfer to reduce bandwidth
It loads only rows modified since the last successful run using a watermark (Correct answer)

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 55: What is the purpose of a 'CORS policy' applied to an API in IICS API Center?

Controlling which browser origins are allowed to make cross-origin API requests (Correct answer)
Caching API responses to reduce backend load
Compressing API responses to reduce bandwidth
Routing API requests to different backend processes based on URL

Correct answer: Controlling which browser origins are allowed to make cross-origin API requests

A CORS policy specifies which browser origins are permitted to make cross-origin requests to the API, controlling browser-based security.

Question 56: In IICS Application Integration, what is the 'Business Services Library' used for?

Storing reusable process components, schemas, and connection factories for team-wide consumption (Correct answer)
Managing user permissions and roles
Logging integration errors to a central store
Scheduling recurring process runs

Correct answer: Storing reusable process components, schemas, and connection factories for team-wide consumption

The Business Services Library is a repository of reusable assets such as processes, schemas, and connectors that teams can share across projects.

Question 57: 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 58: What is the purpose of 'projects' and 'folders' in IICS for asset organization?

They provide a hierarchical organizational structure for grouping and managing assets with access permissions (Correct answer)
They define the runtime execution order of tasks
They configure environment-specific connection settings
They act as database schemas for storing integration metadata

Correct answer: They provide a hierarchical organizational structure for grouping and managing assets with access permissions

Projects and folders organize assets hierarchically in IICS and are used to control access permissions at the project or folder level.

Question 59: What does 'synchronous' vs. 'asynchronous' process invocation mean in IICS Application Integration?

Synchronous is for batch; asynchronous is for streaming
Synchronous uses REST; asynchronous uses SOAP
Synchronous waits for a response before proceeding; asynchronous fires and continues without waiting (Correct answer)
Synchronous runs on a schedule; asynchronous runs in real time

Correct answer: Synchronous waits for a response before proceeding; asynchronous fires and continues without waiting

Synchronous invocation waits for the called process to complete and return a response, while asynchronous invocation continues immediately without waiting.

Question 60: In IICS, which field in a mapping task configuration controls how many rows are written to the target in each database commit?

Flush Size
Buffer Size
Commit Interval (Correct answer)
Batch Size

Correct answer: Commit Interval

The Commit Interval in IICS mapping task settings determines the number of rows written before the target database transaction is committed.

Informatica IICS Certification Exam

The Informatica Intelligent Cloud Services (IICS) Certification Exam tests knowledge of data integration, cloud application integration, and API management within the Informatica cloud platform.

Questions

90 min

Time Limit

65%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds