Informatica Cloud Data Integration Developer Professional Certification — Questions and Answers

Question 1: What is the effect of enabling the 'Secure Agent proxy' setting in IICS when the corporate network routes all outbound traffic through an HTTP proxy?

The Secure Agent disables TLS verification when a proxy is configured
The proxy replaces the Secure Agent for all task execution
Proxy settings apply only to source connectors, not target connectors
The Secure Agent tunnels traffic through the proxy to reach IICS endpoints (Correct answer)

Correct answer: The Secure Agent tunnels traffic through the proxy to reach IICS endpoints

Configuring proxy settings in the Secure Agent allows it to route its outbound HTTPS connections through the corporate proxy server to reach IICS.

Question 2: What does the PDCA cycle stand for in quality management?

Prepare, Document, Certify, Approve
Predict, Design, Create, Adapt
Price, Demand, Cost, Assessment
Plan, Do, Check, Act (Correct answer)

Correct answer: Plan, Do, Check, Act

PDCA (Plan, Do, Check, Act) is a four-step management method for continuous improvement of processes and products.

Question 3: Which property of a linked list makes it more suitable than an array for Informatica Cloud dynamic schema mappings where columns are added at runtime?

Cache-friendly memory layout
O(1) random access
Fixed memory allocation
O(1) insertion without shifting elements (Correct answer)

Correct answer: O(1) insertion without shifting elements

Linked lists allow O(1) insertion at any position without shifting elements, unlike arrays that require O(n) shifting when inserting mid-sequence.

Question 4: What is benchmarking in the context of Informatica Cloud Certification quality management?

Recording daily activities
Comparing performance against best practices or competitors (Correct answer)
Testing equipment functionality
Setting minimum acceptable standards

Correct answer: Comparing performance against best practices or competitors

Benchmarking involves comparing your processes and performance metrics to industry best practices to identify improvement areas.

Question 5: When designing IICS integrations that must comply with data residency regulations (e.g., GDPR), which architectural control is most relevant?

Enabling pushdown optimization for all mappings
Setting all connections to read-only mode
Selecting a Secure Agent and IICS pod region that keeps data within the required geography (Correct answer)
Using Cloud MDM to mask sensitive fields

Correct answer: Selecting a Secure Agent and IICS pod region that keeps data within the required geography

Data residency compliance requires that both the IICS pod (cloud infrastructure region) and the Secure Agent processing data are located within the required geographic boundary.

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

Standard/Hot storage
Archive/Glacier storage (Correct answer)
Cool/Infrequent Access storage
Locally Redundant 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 7: When an IICS published API needs to enforce that consumers include a unique key in every request header, which policy type provides this control?

IP Allowlist Policy
Rate Limit Policy
OAuth 2.0 Policy
API Key Authentication Policy (Correct answer)

Correct answer: API Key Authentication Policy

An API Key Authentication Policy requires consumers to pass a valid API key in the request header before the API will process the call.

Question 8: In the shared responsibility model for cloud security, who is responsible for patching the guest operating system on an IaaS instance?

The cloud provider
A third-party managed security service
It is patched automatically with no responsibility assigned
The customer (Correct answer)

Correct answer: The customer

In IaaS, the cloud provider secures the physical infrastructure and hypervisor, but the customer is responsible for the OS, patches, and everything above.

Question 9: What is the role of documentation in Cloud Computing & Services for Informatica Cloud Certification?

It is only for management review
It should only be done monthly
It provides an accurate record for accountability and reference (Correct answer)
It is unnecessary paperwork

Correct answer: It provides an accurate record for accountability and reference

Proper documentation in Cloud Computing & Services ensures accountability, traceability, and serves as a reference for future decisions.

Question 10: Which IICS organization-level setting prevents users from exporting connection passwords or Secure Parameter values via the UI?

Secure Parameter masking in exports (Correct answer)
Export encryption policy
Connection object export is always prohibited
Role-based export restrictions

Correct answer: Secure Parameter masking in exports

Secure Parameters are masked and excluded from any export operation, preventing accidental disclosure of secrets through exported assets.

Question 11: In Informatica Cloud CDI, what is the function of the 'Early Selection' optimization?

It sorts data early to enable sorted-input Aggregators
It caches lookup results before the first data row arrives
It pre-computes Expression transformation outputs at mapping compile time
It pushes a filter as close to the source as possible to reduce rows flowing through the pipeline (Correct answer)

Correct answer: It pushes a filter as close to the source as possible to reduce rows flowing through the pipeline

Early Selection moves filter conditions upstream so fewer rows enter subsequent transformations, reducing total processing work.

Question 12: Which transformation is commonly used to filter records in Informatica Cloud?

Aggregator Transformation
Joiner Transformation
Filter Transformation (Correct answer)
Expression Transformation

Correct answer: Filter Transformation

The Filter Transformation in Informatica Cloud Data Integration is specifically used to filter records based on a defined condition. It allows users to include or exclude rows from the data flow that meet or do not meet certain criteria. This effectively reduces the volume of data processed and ensures that only relevant data moves to subsequent transformations or target systems.

Question 13: When deploying IICS to a new region for disaster recovery, what must be reconfigured because it is environment-specific?

Connection URLs, runtime environment assignments, and Secure Agent registrations (Correct answer)
Mapping logic and transformation rules
Email notification templates
Column metadata and data type mappings

Correct answer: Connection URLs, runtime environment assignments, and Secure Agent registrations

Connection endpoints, agent registrations, and runtime environment bindings are environment-specific and must be updated when standing up a DR region.

Question 14: In IICS Taskflow, what control flow element should you use to execute a branch only when a prior task fails?

Fault handler gateway
Error notification step
Exception handler path
Conditional branch with failure event (Correct answer)

Correct answer: Conditional branch with failure event

A conditional branch configured with the 'on failure' condition routes the Taskflow to an alternate path when a task does not complete successfully.

Question 15: An Informatica Cloud aggregator transformation must compute the median of a streaming dataset. Which pair of data structures achieves O(log n) insert and O(1) median retrieval?

Two stacks
BST and hash map
Circular buffer and array
Max-heap and min-heap (Correct answer)

Correct answer: Max-heap and min-heap

Maintaining a max-heap for the lower half and a min-heap for the upper half allows O(log n) insertion and O(1) median access via the tops of each heap.

Question 16: Which IICS Advanced Data Quality option should be disabled on a non-profiling run to improve mapping throughput?

Lookup cache warm-up
Data profiling / profile statistics collection (Correct answer)
Source row filtering
Column mapping

Correct answer: Data profiling / profile statistics collection

Data profiling collects statistics on every row processed; disabling it on production runs removes that per-row overhead.

Question 17: When a Secure Agent group is used, how does IICS determine which agent in the group runs a specific job?

The agent with the lowest current CPU load is selected
Round-robin assignment based on job submission order
IICS uses a load-balancing algorithm considering agent availability and capacity (Correct answer)
The first registered agent in the group always runs the job

Correct answer: IICS uses a load-balancing algorithm considering agent availability and capacity

IICS automatically load-balances jobs across available agents in the group, factoring in agent health and current workload.

Question 18: Which IICS feature provides data lineage tracking and impact analysis across mappings, tasks, and connections?

Mapping Designer canvas
Administrator connection audit log
Data Catalog (Axon / EDC integration) (Correct answer)
Monitor tab

Correct answer: Data Catalog (Axon / EDC integration)

Informatica's Enterprise Data Catalog (EDC) and Axon integration provide automated lineage discovery and impact analysis across IICS assets.

Question 19: Which planning tool helps visualize project timelines in Informatica Cloud Certification?

Gantt chart (Correct answer)
Bar graph
Scatter plot
Pie chart

Correct answer: Gantt chart

A Gantt chart displays project tasks against a timeline, showing start dates, durations, dependencies, and milestones.

Question 20: How does parallel processing enhance workflow optimization in Informatica Cloud?

Allows tasks to run concurrently for better efficiency (Correct answer)
Eliminates task dependencies
Increases execution time
Removes automation capabilities

Correct answer: Allows tasks to run concurrently for better efficiency

Parallel processing enhances workflow optimization in Informatica Cloud by allowing multiple independent tasks or data processing operations to run simultaneously. This concurrent execution leverages available computing resources more effectively, significantly reducing the overall workflow execution time and improving throughput, especially for large data volumes.

Question 21: Which IICS sub-organization concept allows an enterprise to isolate data, users, and jobs between business units while sharing a single Informatica license?

Federated organizations (sub-orgs) (Correct answer)
Separate IICS tenants
Workspace partitions
Environment-level RBAC groups

Correct answer: Federated organizations (sub-orgs)

IICS supports federated sub-organizations that share a parent license but maintain isolated users, assets, and runtime environments.

Question 22: In IICS, which workflow log level provides the most detailed output for diagnosing task-level failures and variable values during execution?

Error
Verbose (Correct answer)
Warning
Normal

Correct answer: Verbose

Verbose logging captures detailed runtime information including variable values, task inputs/outputs, and step-level execution traces.

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

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

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 24: What is the role of documentation in Security & Authentication for Informatica Cloud Certification?

It provides an accurate record for accountability and reference (Correct answer)
It should only be done monthly
It is unnecessary paperwork
It is only for management review

Correct answer: It provides an accurate record for accountability and reference

Proper documentation in Security & Authentication ensures accountability, traceability, and serves as a reference for future decisions.

Question 25: Which IICS Data Integration transformation is best suited for parsing a nested JSON or XML hierarchy into relational rows?

XML transformation
Structure Parser
Hierarchy Parser (Correct answer)
Normalizer

Correct answer: Hierarchy Parser

The Hierarchy Parser transformation flattens nested JSON or XML documents into relational output groups, mapping hierarchical nodes to flat rows.

Question 26: In IICS, a mapping fails with 'DTM_15007 Transformation evaluation error'. Which troubleshooting action is MOST appropriate?

Enable Verbose Data logging and re-run to identify the offending row (Correct answer)
Restart the Secure Agent
Increase DTM heap memory
Recreate the mapping from scratch

Correct answer: Enable Verbose Data logging and re-run to identify the offending row

DTM_15007 indicates a runtime data error in a transformation; Verbose Data logging reveals the exact row and field causing the failure.

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

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

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 28: In IICS, which scheduler option allows a task to be triggered immediately upon the completion of another task or workflow?

Event Monitor polling
Cron-based schedule
Manual trigger only
Chained task execution within a Taskflow (Correct answer)

Correct answer: Chained task execution within a Taskflow

Within a Taskflow, tasks can be chained so that one task starts automatically upon the successful (or failed) completion of a preceding task.

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

RSA
AES (Correct answer)
SHA-256
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 30: Which IICS Workflow best practice reduces the risk of long-running workflows consuming excessive Secure Agent memory?

Breaking large workflows into smaller chained or event-triggered sub-workflows (Correct answer)
Running all tasks sequentially to limit concurrency
Disabling logging to reduce overhead
Increasing the Java heap size on the Secure Agent

Correct answer: Breaking large workflows into smaller chained or event-triggered sub-workflows

Decomposing large workflows into smaller units limits memory footprint per execution and improves manageability and recovery.

Question 31: Which health check should be performed when a Secure Agent shows as 'Disconnected' in the IICS Administrator console?

Reinstall the Secure Agent software
Reset the agent API key in Administrator
Disable the local OS firewall on the agent host
Verify the agent host can reach cdn.informaticacloud.com on port 443 (Correct answer)

Correct answer: Verify the agent host can reach cdn.informaticacloud.com on port 443

The Secure Agent requires outbound HTTPS access to Informatica Cloud endpoints; blocked port 443 is the most common cause of disconnection.

Question 32: What is the importance of staying current with trends in Security & Authentication for Informatica Cloud Certification?

It is only required for new professionals
It is not necessary once certified
Trends do not affect professional practice
It ensures practices remain effective and relevant (Correct answer)

Correct answer: It ensures practices remain effective and relevant

Staying current with industry trends ensures that professional practices remain effective, relevant, and aligned with evolving standards.

Question 33: In Informatica Cloud mappings, what is the purpose of the Java transformation?

To convert data from serialized Java objects into a relational column format
To compile and validate Java class definitions as part of the data pipeline
To execute custom Java code within a mapping for complex logic not available as built-in transformations (Correct answer)
To establish connectivity between Informatica Cloud and Java EE application servers

Correct answer: To execute custom Java code within a mapping for complex logic not available as built-in transformations

The Java transformation allows developers to write and execute custom Java code inside a mapping, enabling complex transformation logic that cannot be achieved with standard built-in transformations.

Question 34: Which IICS Secure Agent JVM tuning parameter should you increase when a mapping that processes large XML or JSON payloads throws 'OutOfMemoryError'?

Session sort buffer size
DTM buffer block size
-Xmx (maximum heap size) (Correct answer)
-XX:MaxPermSize

Correct answer: -Xmx (maximum heap size)

-Xmx sets the JVM's maximum heap, providing more memory for parsing and holding large in-flight XML/JSON documents.

Question 35: Informatica Cloud's data masking transformation replaces sensitive values using a substitution dictionary. Which data structure gives the fastest substitution lookup?

Singly linked list
Hash map (Correct answer)
Unsorted array
Binary heap

Correct answer: Hash map

A hash map provides O(1) average-case lookup, making it the fastest structure for substituting sensitive values from a pre-built dictionary.

Question 36: In IDMC, what is the recommended method to test a Mapping Task without affecting production target tables?

Run the task directly against production with a row limit of 1
Point the task to a sandbox or staging target environment via environment-specific connections (Correct answer)
Disable all target transformations before running
Use the mapping's built-in simulation mode

Correct answer: Point the task to a sandbox or staging target environment via environment-specific connections

Using sandbox or staging connections isolates test execution from production data, preventing unintended side effects.

Question 37: In Informatica Cloud Data Integration, what is the role of the 'Runtime Environment' setting on a connection regarding security?

It enforces row-level security filters on query results
It determines which SSL certificate the connection trusts
It specifies which Secure Agent or agent group processes the connection's tasks, controlling data path (Correct answer)
It sets the encryption algorithm for data at rest

Correct answer: It specifies which Secure Agent or agent group processes the connection's tasks, controlling data path

The Runtime Environment setting dictates which Secure Agent handles connection tasks, keeping sensitive data within the designated network zone.

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

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

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 39: What is the primary goal of performance monitoring in Informatica Cloud?

To disable workflow logs
To reduce workflow execution time and optimize performance (Correct answer)
To randomly modify workflows
To remove security settings

Correct answer: To reduce workflow execution time and optimize performance

The primary goal of performance monitoring in Informatica Cloud is to track and analyze the execution of data integration workflows to identify bottlenecks and areas for improvement. By understanding performance metrics, users can optimize mappings, tasks, and overall workflow design to reduce execution time and ensure efficient data processing.

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

Command task
Decision task (Correct answer)
Wait 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 41: Which security measure is essential for protecting Informatica Cloud Certification digital systems?

Sharing login credentials
Implementing multi-factor authentication (Correct answer)
Disabling firewalls
Using simple passwords

Correct answer: Implementing multi-factor authentication

Multi-factor authentication adds extra layers of security beyond passwords, significantly reducing unauthorized access risk.

Question 42: When Informatica Cloud caches lookup data in memory, which collision resolution strategy is most commonly used in the underlying hash table?

Binary search fallback
Stack-based chaining
Open addressing with linear probing (Correct answer)
Merge sort fallback

Correct answer: Open addressing with linear probing

Open addressing with linear probing resolves hash collisions by scanning sequentially for the next open slot, keeping data in contiguous memory.

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

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

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 44: What type of token does IICS issue upon successful REST API authentication, and how long is its default validity?

A static API key with no expiry
A JWT lasting 7 days
A SAML assertion valid for 24 hours
A session token lasting 30 minutes by default, extendable to 8 hours (Correct answer)

Correct answer: A session token lasting 30 minutes by default, extendable to 8 hours

IICS issues a session token upon REST API login that defaults to 30-minute idle timeout but can be configured up to 8 hours.

Question 45: What is the purpose of a feasibility study in Informatica Cloud Certification project planning?

To assign team roles
To start the project immediately
To determine if a project is viable and worth pursuing (Correct answer)
To create a marketing plan

Correct answer: To determine if a project is viable and worth pursuing

A feasibility study evaluates whether a project is technically, financially, and operationally viable before committing resources.

Question 46: Which transformation in Informatica Cloud is used to perform aggregations such as SUM or COUNT?

Aggregator Transformation (Correct answer)
Filter Transformation
Joiner Transformation
Lookup Transformation

Correct answer: Aggregator Transformation

The Aggregator Transformation in Informatica Cloud is used to perform calculations on groups of data, such as summing values, counting records, calculating averages, or finding minimum/maximum values. It allows users to define aggregate functions and group data based on specific columns. This transformation consolidates multiple rows into a single summary row, which is essential for reporting and analytical purposes.

Question 47: When validating an IDMC API-triggered integration using Application Integration, which tool is most appropriate for sending test HTTP requests and inspecting responses?

An external REST client such as Postman or curl (Correct answer)
The IDMC Mapping Task Monitor
IDMC Data Preview panel
The IDMC Administrator console

Correct answer: An external REST client such as Postman or curl

External REST clients like Postman or curl allow testers to craft specific HTTP requests, inspect headers, payloads, and status codes independently of the IDMC UI.

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

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

Correct answer: A measurable value that demonstrates effectiveness

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

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

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

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 50: When configuring IICS to use an external Identity Provider via SAML, which attribute in the SAML assertion is used to map the authenticated user to an IICS account?

The X.509 certificate subject CN
NameID or a configured email attribute (Correct answer)
The IdP's entity ID
The SAML audience restriction value

Correct answer: NameID or a configured email attribute

IICS uses the SAML NameID or a designated email attribute in the assertion to identify and match the user to an existing IICS account.

Question 51: When designing an IICS Workflow that must process files sequentially to avoid data conflicts, which scheduling approach is most appropriate?

Parallel task execution with database row locking
High-frequency cron with file locking at the mapping level
Single-instance scheduling that prevents concurrent runs of the same workflow (Correct answer)
Event-based triggers with no concurrency guard

Correct answer: Single-instance scheduling that prevents concurrent runs of the same workflow

Single-instance scheduling ensures only one run of the workflow executes at a time, preventing race conditions when files must be processed in order.

Question 52: In IICS, what does the 'pushdown optimization' feature do?

Pushes mapping logic execution down to the source or target database engine (Correct answer)
Compresses data before pushing it to a target
Automatically indexes target tables after a load
Moves data processing from the cloud to on-premises servers

Correct answer: Pushes mapping logic execution down to the source or target database engine

Pushdown optimization translates mapping logic into native SQL and executes it on the source or target database, reducing data movement and improving performance.

Question 53: An IICS synchronization task is performing poorly because it recalculates derived fields for every source row even when the source data is unchanged. Which technique addresses this?

Increasing the target connection pool size
Switching the target load type from Insert to Delete/Insert
Using CDC (Change Data Capture) to process only modified rows (Correct answer)
Disabling expression caching on the Expression transformation

Correct answer: Using CDC (Change Data Capture) to process only modified rows

CDC identifies only rows that changed since the last run so unchanged rows never enter the mapping, eliminating wasted computation.

Question 54: When sending a large payload to an external REST API in IICS, which approach best addresses API payload size limits?

Increasing the REST V2 connector timeout value
Compressing the payload using the built-in ZIP transformation
Splitting the data into batches and making multiple API calls within the mapping (Correct answer)
Using a JDBC connection instead of REST to bypass size limits

Correct answer: Splitting the data into batches and making multiple API calls within the mapping

Batching the data and iterating over multiple API calls is the standard pattern to handle APIs that enforce payload size limits.

Question 55: What distinguishes 'cloud-native' applications from traditional applications 'lifted and shifted' to the cloud?

Cloud-native apps require no internet connectivity to function
Cloud-native apps run only on private clouds, while lifted-and-shifted apps run on public clouds
Cloud-native apps are architected to exploit cloud features like auto-scaling and managed services from the ground up (Correct answer)
Cloud-native apps do not use containers, whereas lifted-and-shifted apps rely on Docker

Correct answer: Cloud-native apps are architected to exploit cloud features like auto-scaling and managed services from the ground up

Cloud-native applications are designed from the start to leverage cloud capabilities—microservices, containers, managed services, and auto-scaling—rather than simply running existing apps on cloud VMs.

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

To compress sensitive data fields to reduce storage footprint in the target
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 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 57: When Informatica Cloud detects a cycle in a mapping graph (which is invalid), which algorithm is typically used to report the cycle?

Merge sort on edge list
Greedy coloring
DFS with back-edge detection (Correct answer)
Binary search on adjacency matrix

Correct answer: DFS with back-edge detection

DFS detects cycles by tracking visited states; a back edge (revisiting a node already on the current path) confirms a cycle exists in the mapping.

Question 58: In Informatica Cloud, when flattening a deeply nested JSON array into relational rows, which recursive algorithm pattern is applied?

Greedy selection
Depth-first traversal with a call stack (Correct answer)
Iterative bubble sort
Breadth-first level-order scan only

Correct answer: Depth-first traversal with a call stack

Depth-first traversal using a call stack recurses into each nested array level before moving to siblings, naturally flattening the hierarchy.

Question 59: What is the purpose of the 'Optimizer Level' setting in an IICS mapping session properties?

It determines the compression algorithm used on flat file targets
It sets the maximum CPU cores the session may consume
It enables automatic optimizations such as early selection, push-into, and cost-based reordering of transformations (Correct answer)
It controls the JVM garbage collection policy for the Secure Agent

Correct answer: It enables automatic optimizations such as early selection, push-into, and cost-based reordering of transformations

The Optimizer Level instructs IICS how aggressively to apply automatic rewrite rules—higher levels enable more transformations like pushdown and cost-based reordering.

Question 60: Which technique in IICS Workflow design helps avoid hard-coded connection information and supports environment promotion (dev to prod)?

Hard-coding connection names in each mapping task
Storing credentials in Assignment task variables
Embedding connection strings directly in Command tasks
Using connections defined as workflow parameters or parameter files (Correct answer)

Correct answer: Using connections defined as workflow parameters or parameter files

Parameterizing connection references allows the same workflow to use different connections per environment without design changes.

Question 61: What is the effect of enabling 'High Availability' for a Secure Agent Group in IICS?

If one agent fails, another agent in the group automatically picks up and runs the task (Correct answer)
All agents must be on the same machine to share memory
The group gains access to additional licensed connectors
Tasks are distributed evenly across all agents for parallel execution

Correct answer: If one agent fails, another agent in the group automatically picks up and runs the task

High availability in a Secure Agent Group means IICS will failover task execution to another healthy agent in the group if the primary agent becomes unavailable.

Question 62: What is the role of the Mapping Designer in Informatica Cloud?

To monitor server health
To design data integration workflows (Correct answer)
To configure API endpoints
To manage user access roles

Correct answer: To design data integration workflows

The Mapping Designer in Informatica Cloud is a graphical interface where users create and configure data integration mappings. These mappings define the flow of data from source to target, including all the necessary transformations, lookups, and filters required to process and prepare the data. It is the central component for visually building and managing ETL processes.

Question 63: In IICS, which object type should be used to pass encrypted runtime values such as API keys into a mapping without hardcoding them in the mapping configuration?

Flat-file lookup tables
Secure parameters in parameter files or runtime parameters (Correct answer)
Taskflow variables
Agent environment variables stored in agent properties

Correct answer: Secure parameters in parameter files or runtime parameters

Secure parameters in IICS parameter files allow sensitive values to be passed at runtime and stored in encrypted form, keeping secrets out of mapping definitions.

Question 64: An administrator wants to prevent Informatica Cloud users from exporting connection credentials or viewing connection passwords. Which access control approach achieves this?

Encrypting connections with a user-specific key
Disabling the Secure Agent outbound connection logs
Assigning users the Monitor role which hides credentials in the UI
Granting users connection 'Use' privilege without 'Edit' or 'Admin' privilege (Correct answer)

Correct answer: Granting users connection 'Use' privilege without 'Edit' or 'Admin' privilege

The 'Use' privilege allows users to select a connection in mappings without being able to view or modify the underlying credentials.

Question 65: In Informatica Cloud Certification, what is the purpose of an audit trail?

To measure system speed
To count user logins
To record and track all changes and access to data (Correct answer)
To track employee attendance

Correct answer: To record and track all changes and access to data

An audit trail provides a chronological record of all system activities, showing who accessed or changed data and when.

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

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

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 67: What is a fundamental principle of DevOps & Deployment in Informatica Cloud Certification practice?

Working in isolation without guidance
Ignoring industry guidelines
Following established standards and best practices (Correct answer)
Using outdated methods

Correct answer: Following established standards and best practices

Following established standards and best practices ensures quality and consistency in DevOps & Deployment.

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

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
Partition rows across multiple target connections simultaneously

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 69: What is a stakeholder analysis in Informatica Cloud Certification planning?

A competitive market review
A staff satisfaction survey
A financial audit
Identifying and assessing the interests and influence of affected parties (Correct answer)

Correct answer: Identifying and assessing the interests and influence of affected parties

Stakeholder analysis identifies all parties affected by or having influence over a project, helping manage expectations and engagement.

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

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

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.

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

90 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

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

now.informatica.com — Exam format, exam information · verified Oct 2026
infa-education.zendesk.com — Eligibility, test delivery, score validity, score release, passing score, time limit, retake policy, fees, test dates · verified Oct 2026