Informatica Cloud Data Integration Developer Professional Certification — Questions and Answers

Question 1: What distinguishes a multi-cloud strategy from a hybrid cloud strategy?

Multi-cloud and hybrid cloud are interchangeable terms
Multi-cloud uses only public providers; hybrid combines public and private clouds (Correct answer)
Multi-cloud uses only private clouds; hybrid adds on-premises hardware
Multi-cloud avoids cloud providers entirely; hybrid uses both cloud and edge

Correct answer: Multi-cloud uses only public providers; hybrid combines public and private clouds

Multi-cloud uses services from multiple public cloud vendors, while hybrid cloud integrates public cloud with private cloud or on-premises infrastructure.

Question 2: When Informatica Cloud processes data subject to CCPA, which data management action must the platform be able to support for California residents upon request?

Cross-border transfer prohibition to all non-US systems
Automatic data retention for 10 years
Mandatory data re-identification
Opt-out of personal data sale and right to deletion (Correct answer)

Correct answer: Opt-out of personal data sale and right to deletion

CCPA grants California residents the right to opt out of the sale of their personal information and the right to request deletion of their data.

Question 3: A financial services firm must demonstrate that no unauthorized changes were made to its Informatica Cloud integration assets over the past 90 days. Which capability supports this audit requirement?

Mapping version history and audit logs (Correct answer)
Cloud Data Quality scorecard reports
Connection test history
Secure Agent CPU usage logs

Correct answer: Mapping version history and audit logs

IICS maintains asset version history and audit logs that record who changed which asset and when, supporting change-control audits.

Question 4: When configuring a Secure Agent behind a corporate proxy, which configuration file is edited to add proxy settings?

infaagent.ini (Correct answer)
conf/default.properties
javaagent.conf
proxy.properties

Correct answer: infaagent.ini

Proxy host, port, and credentials are configured in the infaagent.ini file located in the Secure Agent installation directory.

Question 5: Which Informatica Cloud Data Integration feature helps identify and remediate columns that contain sensitive data patterns like Social Security Numbers across multiple source systems?

Connection health monitoring
Scheduler calendar configuration
Mapping parameter sets
Data profiling with pattern-based classification (Correct answer)

Correct answer: Data profiling with pattern-based classification

Data profiling with pattern matching can detect columns containing structured sensitive data like SSNs by scanning actual data values against regex patterns.

Question 6: Which IICS optimizer hint tells the Secure Agent to use a pipeline partition strategy based on key range rather than hash?

Key range partitioning (Correct answer)
Pass-through partitioning
Round-robin partitioning
Database partitioning

Correct answer: Key range partitioning

Key range partitioning divides rows into segments based on value ranges of a chosen key column, which can improve locality for sorted data sets.

Question 7: When using IICS to load data into Snowflake, which file staging approach typically yields the best bulk load performance?

JDBC batch commits of 1,000 rows
Row-by-row INSERT statements
Staging data in cloud storage (S3/Azure Blob) then using COPY INTO (Correct answer)
Loading through a REST API endpoint

Correct answer: Staging data in cloud storage (S3/Azure Blob) then using COPY INTO

Staging files in cloud object storage and using Snowflake's COPY INTO command bypasses row-level overhead and leverages Snowflake's optimized bulk ingestion engine.

Question 8: A compliance officer needs to generate a report showing all Informatica Cloud users who have the 'Admin' role, along with the date they were granted that role. Which IICS feature supports this?

Data Quality rule execution history
Connection usage report
User management audit log export (Correct answer)
Secure Agent task logs

Correct answer: User management audit log export

IICS maintains an audit log of user administration events including role assignments, which administrators can export for compliance reporting.

Question 9: A tester runs an IDMC Mass Ingestion Files task and notices some files were skipped. Where is the best place to investigate the reason for skipped files?

The target database error table
The source file system audit trail
The Monitor session log for the specific job run (Correct answer)
The Operational Insights dashboard

Correct answer: The Monitor session log for the specific job run

The session log for the Mass Ingestion job run contains file-level status messages including reasons why specific files were skipped.

Question 10: Under PCI DSS, cardholder data transmitted through Informatica Cloud pipelines must be protected in transit. Which of the following configurations satisfies this requirement?

Storing card numbers in hashed form only in the mapping output
Enabling TLS on source connections only
Enabling TLS on both source and target connections with valid certificates (Correct answer)
Using AES-256 file encryption at rest without transport encryption

Correct answer: Enabling TLS on both source and target connections with valid certificates

PCI DSS Requirement 4 mandates that cardholder data be encrypted across all network segments, requiring TLS on both the ingress (source) and egress (target) sides of a mapping.

Question 11: Which IICS Workflow element is used to evaluate a Boolean condition and direct execution to one of two possible paths?

Decision task (Correct answer)
Wait task
Command task
Assignment task

Correct answer: Decision task

The Decision task evaluates a condition expression and routes workflow execution along a true or false path accordingly.

Question 12: In IICS Data Integration, which join type returns all rows from the master source and only matching rows from the detail source?

Inner join
Full outer join
Left outer join (master-detail) (Correct answer)
Right outer join

Correct answer: Left outer join (master-detail)

In IICS Joiner transformation, a Master-Detail (left outer) join returns every master row and matched detail rows, with NULLs for unmatched detail columns.

Question 13: When configuring an IICS Taskflow, what is a Decision task used for?

To retry a failed mapping task automatically
To branch the flow based on a conditional expression evaluation (Correct answer)
To pause execution until a manual approval is received
To send an email notification when a step completes

Correct answer: To branch the flow based on a conditional expression evaluation

A Decision task evaluates a Boolean expression and routes execution to different branches depending on true or false outcome.

Question 14: A compliance requirement mandates that all ETL job execution logs be retained for seven years. Which Informatica Cloud feature best supports this requirement?

IICS Activity Log export to external storage (Correct answer)
Secure Agent local log rotation
Connection Manager audit trail
Data Integration Service logging

Correct answer: IICS Activity Log export to external storage

IICS Activity Logs can be exported to external storage systems where long-term retention policies and archival rules can be applied.

Question 15: Which encryption method is commonly used to secure data at rest in the cloud?

RSA
SHA-256
AES (Correct answer)
MD5

Correct answer: AES

AES (Advanced Encryption Standard) is a widely adopted and highly secure symmetric encryption algorithm used to protect data at rest in cloud environments. Its strong cryptographic properties and efficiency make it an industry standard for encrypting sensitive information stored on servers, databases, and storage devices. Other options like SHA-256 and MD5 are hashing algorithms, and RSA is an asymmetric encryption algorithm typically used for key exchange or digital signatures, not bulk data encryption.

Question 16: In Informatica Cloud, what is the primary purpose of using a 'runtime environment' with named Secure Agents grouped into a Secure Agent group?

To enforce TLS certificate pinning per agent
To provide high availability and load balancing for task execution (Correct answer)
To isolate encryption keys per physical machine
To enable per-agent license counting

Correct answer: To provide high availability and load balancing for task execution

A Secure Agent group acts as a runtime environment where multiple agents share workload, providing failover and horizontal scaling for task execution.

Question 17: Which IICS capability allows data stewards to define and enforce data access policies at the catalog level, preventing unauthorized users from querying sensitive datasets?

Informatica Axon data governance policies
Cloud Data Access Management (CDAM) policies in Informatica IDMC (Correct answer)
Firewall rules on the Secure Agent host
Column-level select grants on the source database

Correct answer: Cloud Data Access Management (CDAM) policies in Informatica IDMC

IDMC's Cloud Data Access Management lets data stewards define fine-grained policies that control which users or groups can query sensitive data assets across connected systems.

Question 18: In IICS, where are audit logs for user login events and asset changes stored and accessible?

In an external SIEM that must be configured manually
In the IICS Audit Log report under the Monitor tab (Correct answer)
In the PostgreSQL metadata database of the Secure Agent
Only in the Secure Agent local file system

Correct answer: In the IICS Audit Log report under the Monitor tab

IICS records user and asset audit events in the platform's Audit Log report, accessible from the Monitor section of the UI.

Question 19: In IICS Mass Ingestion, which ingestion type is used to continuously replicate data changes from a source database to a target?

Full load ingestion
File ingestion
Streaming ingestion via Kafka
Database ingestion with CDC (Change Data Capture) (Correct answer)

Correct answer: Database ingestion with CDC (Change Data Capture)

Database ingestion with CDC reads the source database transaction log to capture inserts, updates, and deletes in near real-time for continuous replication.

Question 20: In Informatica Cloud Data Integration, what distinguishes a connected lookup from an unconnected lookup?

A connected lookup requires an active network connection while an unconnected lookup works offline
A connected lookup supports multiple return values while an unconnected lookup returns only one
A connected lookup is part of the data flow pipeline and returns values directly, while an unconnected lookup is called via an expression (Correct answer)
A connected lookup queries external APIs while an unconnected lookup uses local cache

Correct answer: A connected lookup is part of the data flow pipeline and returns values directly, while an unconnected lookup is called via an expression

A connected lookup is directly integrated into the mapping pipeline and passes return values to the next transformation, whereas an unconnected lookup is invoked using the :LKP expression within another transformation.

Question 21: Which algorithm is used internally when Informatica Cloud auto-generates a topological execution order for transformation stages in a mapping?

Dijkstra's shortest path
Floyd-Warshall all-pairs
Kahn's algorithm (topological sort via BFS) (Correct answer)
Prim's minimum spanning tree

Correct answer: Kahn's algorithm (topological sort via BFS)

Kahn's algorithm performs a topological sort using BFS and in-degree tracking, producing a valid stage execution order for a DAG-based mapping.

Question 22: What is the primary goal of quality assurance in Informatica Cloud Certification?

Finding someone to blame for errors
Reducing staff numbers
Ensuring consistent standards and continuous improvement (Correct answer)
Completing tasks as quickly as possible

Correct answer: Ensuring consistent standards and continuous improvement

Quality assurance focuses on maintaining consistent standards and identifying opportunities for continuous improvement in processes and outcomes.

Question 23: When a Secure Agent reports 'connection timeout' errors intermittently, which troubleshooting step should be performed FIRST?

Restart the Secure Agent service
Increase the connection pool size in the connection properties
Upgrade the Secure Agent to the latest version
Check network firewall rules between the agent and the target (Correct answer)

Correct answer: Check network firewall rules between the agent and the target

Intermittent connection timeouts most commonly indicate network or firewall issues rather than agent or pool configuration problems.

Question 24: In an IICS mapping that reads from a REST API source, what field in the REST V2 source transformation specifies how to extract records from a JSON array response?

Array Node Path (Correct answer)
JSON Path Expression
Record Identifier
Root Element

Correct answer: Array Node Path

The Array Node Path field in the REST V2 source tells the connector which node in the JSON response contains the array of records to iterate over.

Question 25: In Informatica Data Quality (IDQ) within IDMC, what is the primary purpose of a scorecard?

To aggregate rule conformance metrics across datasets over time (Correct answer)
To schedule data profiling jobs automatically
To generate test data for quality validation
To map source columns to target columns

Correct answer: To aggregate rule conformance metrics across datasets over time

Scorecards consolidate data quality rule results into trend metrics so teams can track conformance over time.

Question 26: When should you use a 'Sorter' transformation placed before an 'Aggregator' in an IICS mapping?

When the mapping uses pushdown optimization
Always, to improve readability
When the Aggregator is not configured to use sorted input, and the source data is unsorted (Correct answer)
Only when writing to a flat file target

Correct answer: When the Aggregator is not configured to use sorted input, and the source data is unsorted

A Sorter before the Aggregator enables 'sorted input' mode, which lets the Aggregator process groups sequentially without building a full in-memory cache.

Question 27: When designing an API in Informatica Cloud Application Integration, what does the 'Request Schema' define?

The structure and data types of the incoming API payload (Correct answer)
The output format returned to the consumer
The authentication method for the API caller
The list of allowed IP addresses for API access

Correct answer: The structure and data types of the incoming API payload

The Request Schema defines the expected structure and data types of the payload that clients must send when invoking the API.

Question 28: In IICS, what happens when a mapping with 'Stop on Errors' set to 1 encounters its first row error?

The mapping immediately stops and marks the run as failed (Correct answer)
The error row is skipped and processing continues
IICS retries the failed row up to three times before stopping
The error is logged but the mapping continues until all rows are processed

Correct answer: The mapping immediately stops and marks the run as failed

When Stop on Errors is set to 1, IICS halts execution after the first row-level error and marks the session as failed.

Question 29: An IICS REST API integration must handle the scenario where the external API returns a 429 'Too Many Requests' response. What is the recommended handling approach?

Ignore the 429 response and continue processing
Immediately fail the mapping task and alert the user
Implement retry logic with exponential backoff to respect the API rate limit (Correct answer)
Switch to a SOAP endpoint as a fallback

Correct answer: Implement retry logic with exponential backoff to respect the API rate limit

Exponential backoff retry logic respects the external API's rate limits by progressively increasing wait time between retries after a 429 response.

Question 30: Which graph traversal strategy would best identify all connected pipeline stages in an Informatica Cloud mapping when starting from the source transformation?

Quick sort
Breadth-first search (BFS) (Correct answer)
Binary search
Bubble sort

Correct answer: Breadth-first search (BFS)

BFS explores all directly connected stages level by level, making it effective for discovering all reachable transformations from a source.

Question 31: When configuring a SOAP web service connection in IICS, what file is required to describe the available operations and message formats?

WSDL file (.wsdl) (Correct answer)
JSON Schema (.json)
OpenAPI Specification (.yaml)
XSD Schema (.xsd)

Correct answer: WSDL file (.wsdl)

A WSDL (Web Services Description Language) file defines the operations, input/output messages, and binding details for a SOAP web service.

Question 32: Which cloud storage class is most cost-effective for data that is accessed less than once per year?

Archive/Glacier storage (Correct answer)
Cool/Infrequent Access storage
Locally Redundant Storage
Standard/Hot storage

Correct answer: Archive/Glacier storage

Archive-tier storage (e.g., AWS Glacier, Azure Archive) has the lowest storage cost but highest retrieval latency and cost, making it ideal for rarely accessed data.

Question 33: An IICS mapping reads data from an S3 bucket using IAM role-based authentication. What credential is actually used at runtime?

A long-lived IAM user access key stored in Secure Parameters
The AWS access key ID embedded in the connection
A temporary STS credential obtained by the Secure Agent assuming the configured IAM role (Correct answer)
The EC2 instance's root credentials

Correct answer: A temporary STS credential obtained by the Secure Agent assuming the configured IAM role

When using IAM role authentication, the Secure Agent calls AWS STS to assume the role and receives temporary, short-lived credentials for the operation.

Question 34: Which skill is most important for success in Security & Authentication within Informatica Cloud Certification?

Avoiding feedback
Working without any training
Resisting change
Continuous learning and adaptation (Correct answer)

Correct answer: Continuous learning and adaptation

Continuous learning ensures professionals stay current with evolving practices in Security & Authentication.

Question 35: Which IICS setting controls the maximum number of failed login attempts before a user account is automatically locked?

Password complexity policy
Session timeout threshold
MFA retry limit
Account lockout policy (Correct answer)

Correct answer: Account lockout policy

The account lockout policy in IICS organization settings defines how many failed authentication attempts trigger an automatic account lock.

Question 36: In IICS, what does enabling 'constraint-based loading' on a target allow the Secure Agent to do?

Partition rows across multiple target connections simultaneously
Enforce referential integrity by loading parent tables before child tables automatically (Correct answer)
Convert all NULL values to a default before insert
Bypass primary-key checks on the target database

Correct answer: Enforce referential integrity by loading parent tables before child tables automatically

Constraint-based loading ensures parent records exist before child records are inserted, preventing foreign-key violations without manual ordering.

Question 37: When migrating assets between IICS environments (e.g., Dev to Prod), which feature is used to export and import packaged assets?

Secure Agent upgrade tool
Data Replication
Import/Export utility (packages) (Correct answer)
Application Integration Console

Correct answer: Import/Export utility (packages)

IICS provides an Import/Export utility that packages assets like mappings, tasks, and connections for migration across organizations.

Question 38: In IICS Data Integration, what is the purpose of the 'Union' transformation?

Merges multiple input pipelines with identical schemas into a single pipeline (Correct answer)
Splits a single pipeline into multiple output branches
Removes duplicate records from two data sets
Joins two sources on a key column

Correct answer: Merges multiple input pipelines with identical schemas into a single pipeline

The Union transformation combines rows from two or more upstream pipelines with compatible schemas into one output pipeline, similar to SQL UNION ALL.

Question 39: What does data backup mean in the context of Informatica Cloud Certification operations?

Deleting old files
Creating copies of data to prevent loss (Correct answer)
Moving data to a new system
Compressing files for email

Correct answer: Creating copies of data to prevent loss

Data backup involves creating duplicate copies of important data so it can be recovered if the original is lost, corrupted, or damaged.

Question 40: What does a Pushdown Optimization (PDO) setting of 'Full' do in an IICS mapping?

Automatically tunes query performance using AI
Pushes all supported transformation logic to the source or target database engine (Correct answer)
Enables parallel processing across multiple Secure Agents
Forces all transformations to run on the Secure Agent

Correct answer: Pushes all supported transformation logic to the source or target database engine

Full PDO instructs IICS to push as much transformation logic as possible down to the database, reducing data movement.

Question 41: In IICS, where would you find the error message for a task that failed during the 'Pre-SQL' execution phase?

The connection test log
The target error file
The session log (Correct answer)
The Monitor activity summary

Correct answer: The session log

Pre-SQL and Post-SQL errors are captured in the session log with specific SQL statements and database error codes.

Question 42: In Informatica Cloud Certification, what is a Key Performance Indicator (KPI)?

A financial penalty for poor performance
A compliance checklist
A measurable value that demonstrates effectiveness (Correct answer)
A mandatory training requirement

Correct answer: A measurable value that demonstrates effectiveness

KPIs are quantifiable measurements that demonstrate how effectively objectives are being achieved.

Question 43: In Informatica Cloud Workflows, what is the purpose of a Mapping task?

To run a mapping defined in IICS as part of the workflow (Correct answer)
To configure network mappings for connectors
To define field-level transformations inline
To map variable values between tasks

Correct answer: To run a mapping defined in IICS as part of the workflow

A Mapping task references and executes a pre-built IICS mapping, integrating data integration logic within the workflow.

Question 44: In IDMC, what happens when a mapping task encounters a non-fatal error and the 'Stop on Error' threshold has not been reached?

The task immediately aborts and rolls back all writes
The task pauses and waits for operator intervention
The task retries the failed row indefinitely
The row is written to the error log and processing continues for remaining rows (Correct answer)

Correct answer: The row is written to the error log and processing continues for remaining rows

Non-fatal errors below the Stop on Error threshold cause the row to be logged as an error while the task continues processing subsequent rows.

Question 45: What is the primary benefit of using a 'persistent cache' for a Lookup transformation in IICS when the mapping runs on a recurring schedule?

It reuses the pre-built cache from a previous run, skipping the cache rebuild step (Correct answer)
It enables dynamic port generation
It forces the lookup to use a database index
It encrypts the lookup data at rest

Correct answer: It reuses the pre-built cache from a previous run, skipping the cache rebuild step

A persistent cache saves the lookup index to disk after the first run so subsequent runs load the existing cache instead of re-querying the source.

Question 46: What is the recommended way to securely pass database credentials to an IICS mapping at runtime without hardcoding them in the connection?

Use Secure Parameters referenced in the connection definition (Correct answer)
Use environment variable substitution in the mapping SQL
Embed credentials in the mapping parameter file
Pass credentials as plaintext task parameters from the scheduler

Correct answer: Use Secure Parameters referenced in the connection definition

Secure Parameters allow connection credentials to be stored encrypted in the IICS vault and referenced by name without ever exposing plain text values.

Question 47: Which best practice helps optimize workflows in Informatica Cloud?

Avoid reusable components
Disable logging and monitoring
Use reusable components for efficiency (Correct answer)
Increase manual interventions

Correct answer: Use reusable components for efficiency

A key best practice for optimizing workflows in Informatica Cloud is to use reusable components, such as mappings, transformations, and parameters. This approach reduces development time, ensures consistency across different workflows, simplifies maintenance, and improves overall efficiency by avoiding redundant work and promoting standardization.

Question 48: An IICS API integration needs to pass data between two steps in a process using a temporary holding area. Which construct is used for this?

Mapping Parameter
Process Variable (Correct answer)
Temporary Table
Session Parameter

Correct answer: Process Variable

Process Variables in Application Integration store intermediate data in memory during process execution, enabling data passing between steps.

Question 49: What is the best practice to reduce execution time of a data integration workflow?

Increase unnecessary transformations
Disable optimization settings
Run all tasks sequentially
Enable parallel processing (Correct answer)

Correct answer: Enable parallel processing

Enabling parallel processing is a key best practice to reduce the execution time of data integration workflows in Informatica Cloud. By allowing multiple independent tasks or data partitions to run concurrently, it maximizes resource utilization and significantly speeds up the overall data processing, especially for large datasets.

Question 50: Which authentication protocol does Informatica Cloud support for integrating with corporate identity providers to enable single sign-on (SSO)?

Basic HTTP authentication
Kerberos ticket granting
LDAP v2 bind authentication
SAML 2.0 (Correct answer)

Correct answer: SAML 2.0

IICS supports SAML 2.0 federation, allowing corporate identity providers such as Okta or ADFS to authenticate users via SSO.

Question 51: In IICS Workflow optimization, what is the main benefit of using concurrent task execution?

Enforces strict execution ordering across all tasks
Guarantees each task gets dedicated CPU resources
Reduces total elapsed time by running independent tasks simultaneously (Correct answer)
Prevents any single task from failing

Correct answer: Reduces total elapsed time by running independent tasks simultaneously

Concurrent execution of independent tasks parallelizes work and reduces overall workflow run time.

Question 52: In Informatica Cloud (IICS), what is the role of the Secure Agent?

Hosts the cloud repository metadata
Executes tasks locally and communicates with the cloud service (Correct answer)
Manages user authentication for the platform
Provides a web UI for designing mappings

Correct answer: Executes tasks locally and communicates with the cloud service

The Secure Agent runs on-premises or in a private cloud and executes data integration tasks while communicating securely with Informatica Intelligent Cloud Services.

Question 53: What is the purpose of a cloud compliance audit?

To restrict data access for all users
To disable all cloud security controls
To verify compliance with security and regulatory standards (Correct answer)
To increase cloud service costs

Correct answer: To verify compliance with security and regulatory standards

A cloud compliance audit is a systematic evaluation designed to verify that a cloud environment adheres to specific security policies, industry standards, and regulatory requirements. This process helps organizations ensure data protection, identify potential vulnerabilities, and demonstrate their commitment to legal and ethical guidelines, thereby maintaining trust and avoiding penalties.

Question 54: What is the function of a cloud 'availability zone' (AZ)?

A geographic region where a cloud provider has no presence
A virtual network segment used for micro-segmentation
An isolated data center within a region that provides fault isolation (Correct answer)
A billing boundary that separates cloud accounts

Correct answer: An isolated data center within a region that provides fault isolation

An availability zone is one or more discrete data centers within a region with independent power, cooling, and networking, enabling high-availability architectures.

Question 55: In IICS architecture, what is the function of the 'Data Preview' feature in a mapping design?

It compresses the output before writing to the target
It generates a schema from the source without connecting to it
It runs a sample of data through the transformation logic at design time to validate results (Correct answer)
It deploys the mapping to production for testing

Correct answer: It runs a sample of data through the transformation logic at design time to validate results

Data Preview executes a sample of source rows through all transformations in the mapping designer so developers can validate logic without a full run.

Question 56: What is the primary benefit of using technology in Informatica Cloud Certification practice?

Reducing the need for training
Making work more complicated
Eliminating all human involvement
Improving efficiency, accuracy, and data management (Correct answer)

Correct answer: Improving efficiency, accuracy, and data management

Technology enhances professional practice by improving efficiency, reducing errors, and enabling better data management and analysis.

Question 57: Which security model is widely used in cloud computing to control access?

Mandatory Access Control (MAC)
Time-Based Access Control (TBAC)
Role-Based Access Control (RBAC) (Correct answer)
Discretionary Access Control (DAC)

Correct answer: Role-Based Access Control (RBAC)

Role-Based Access Control (RBAC) is a widely adopted security model in cloud computing that assigns permissions and access rights to users based on their organizational roles. Instead of granting individual permissions, users are assigned roles, and these roles have predefined access to resources. RBAC simplifies access management and enhances security by ensuring the principle of least privilege.

Question 58: In a multi-org IICS setup, which approach ensures that a shared connection definition stays consistent across dev, test, and prod organizations?

Manually recreate the connection in each org
Copy the connection XML from the browser developer tools
Include the connection in the export package and use API to update credentials per org after import (Correct answer)
Use a single org for all environments with folder-based separation

Correct answer: Include the connection in the export package and use API to update credentials per org after import

Export the connection as part of the package to replicate its structure, then use the Connections API to inject environment-specific credentials after import into each org.

Question 59: Which IICS Cloud Data Integration feature allows a single mapping to automatically scale compute resources up or down based on data volume at runtime?

Static partition override
Connection pool pre-warming
Advanced cluster (Spark-based) execution with auto-scaling worker nodes (Correct answer)
Sequential taskflow execution

Correct answer: Advanced cluster (Spark-based) execution with auto-scaling worker nodes

Advanced cluster mode runs mappings on an elastic Spark infrastructure that can dynamically add or remove executor nodes based on workload demand.

Question 60: What is the worst-case time complexity for searching an unsorted array of n records in Informatica Cloud's flat file source?

O(log n)
O(1)
O(n²)
O(n) (Correct answer)

Correct answer: O(n)

An unsorted array requires a linear scan in the worst case, visiting every element once, giving O(n) complexity.

Question 61: Which IICS feature allows you to parameterize a mapping so the same design can run against different source tables at runtime?

Reusable sub-mappings
Dynamic mapping with schema at run time (Correct answer)
Mapping templates
Taskflow branching

Correct answer: Dynamic mapping with schema at run time

Dynamic mappings allow the source or target schema to be resolved at runtime using parameters, enabling one mapping to process multiple tables.

Question 62: What is the first phase of strategic planning in Informatica Cloud Certification?

Budget allocation
Performance review
Implementation
Situational analysis and goal setting (Correct answer)

Correct answer: Situational analysis and goal setting

Strategic planning begins with analyzing the current situation and setting clear, measurable goals that guide all subsequent planning.

Question 63: Which Informatica Cloud Operational Insights capability can automatically detect when a job's duration is statistically anomalous compared to its historical baseline?

SLA-based monitoring rules
Session log comparison
Anomaly detection using machine learning (Correct answer)
Threshold-based alerting

Correct answer: Anomaly detection using machine learning

Operational Insights uses ML-based anomaly detection to flag jobs that deviate from their learned historical performance patterns.

Question 64: When troubleshooting a failed IICS mapping, the session log shows 'ORA-00001: unique constraint violated'. What is the correct remediation in the target connection settings?

Enable the 'Insert else Update' write strategy (Correct answer)
Enable bulk mode to bypass constraints
Switch from ODBC to JDBC driver
Set the error threshold to ignore duplicate key errors

Correct answer: Enable the 'Insert else Update' write strategy

The 'Insert else Update' (upsert) strategy prevents duplicate key violations by updating existing records instead of inserting duplicates.

Question 65: What is the space complexity of storing a lookup table for a joiner transformation with n records from the master source?

O(log n)
O(1)
O(n) (Correct answer)
O(n²)

Correct answer: O(n)

A joiner transformation stores the master source in memory as a hash table requiring O(n) space proportional to the number of master records.

Question 66: Which factor commonly affects the performance of an Informatica Cloud job?

Font size in the UI
Number of active users in the company
Data volume and network latency (Correct answer)
Cloud provider’s logo

Correct answer: Data volume and network latency

The performance of an Informatica Cloud job is significantly affected by the volume of data being processed and the network latency between the data sources, targets, and the Informatica Cloud Secure Agent. Larger data volumes require more processing time, and high network latency can slow down data transfer, both contributing to longer execution times.

Question 67: In IICS Data Integration, what does increasing the 'DTM buffer size' parameter primarily affect?

The amount of memory allocated for data transformation in-memory processing (Correct answer)
The size of the network packet sent to the target
The maximum number of partitions per pipeline stage
The number of concurrent sessions allowed

Correct answer: The amount of memory allocated for data transformation in-memory processing

DTM buffer size controls how much RAM is reserved for row processing; a larger buffer reduces disk spill and improves throughput.

Question 68: Which metric in IICS session statistics BEST indicates that a Lookup transformation is causing a performance bottleneck?

High 'lookup cache hit' ratio near 0% (Correct answer)
Low 'rows inserted' count at the target
High 'rows rejected' count
High 'DTM buffer block' allocation

Correct answer: High 'lookup cache hit' ratio near 0%

A near-zero cache hit ratio means every lookup row misses the cache and queries the source, causing repeated round trips and slow performance.

Question 69: In Informatica Cloud, what is the purpose of the Data Masking transformation?

To encrypt sensitive data at rest in the target system using AES encryption
To hide specific columns from appearing in the mapping output schema
To compress sensitive data fields to reduce storage footprint in the target
To replace sensitive data with realistic but fictitious values for testing or privacy compliance (Correct answer)

Correct answer: To replace sensitive data with realistic but fictitious values for testing or privacy compliance

The Data Masking transformation replaces sensitive production data with masked, realistic but fictitious values, supporting test data creation and compliance with data privacy regulations such as GDPR.

Question 70: Which field in the IICS REST V2 target transformation determines how the HTTP method (POST, PUT, PATCH, DELETE) is applied per request?

Request Type
HTTP Method Override
Operation Type (Correct answer)
Resource Path

Correct answer: Operation Type

The Operation Type field in the REST V2 target transformation specifies which HTTP verb (Insert=POST, Update=PUT/PATCH, Delete=DELETE) to use for each record.

Informatica Cloud Data Integration Developer Professional Certification

The ICC certification validates expertise in Informatica Intelligent Cloud Services (IICS), covering cloud data integration, mappings, transformations, taskflows, and application integration. Candidates demonstrate proficiency in building and managing cloud-based data pipelines using IDMC/IICS tools.

Questions

35 min

Time Limit

70%

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