




























































































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
This exam provides training on Informatica Cloud integration for application modernization. Participants will learn to integrate legacy and modern applications, configure ETL processes, and manage cloud data workflows. Labs provide practical experience with enterprise modernization initiatives.
Typology: Exams
1 / 113
This page cannot be seen from the preview
Don't miss anything!





























































































Question 1. Which component of IDMC is primarily responsible for orchestrating real‑time, event‑driven workflows? A) Cloud Data Integration (CDI) B) Secure Agent C) Cloud Application Integration (CAI) D) Data Integration Service Answer: C Explanation: CAI provides the low‑code engine for real‑time, event‑driven processes, whereas CDI handles batch data movement. Question 2. In the context of application modernization, the term “re‑hosting” most closely refers to: A) Re‑writing the application in a new programming language B) Moving the application to a cloud infrastructure without code changes C) Re‑architecting the application as microservices D) Converting the application to a SaaS model Answer: B Explanation: Re‑hosting (also called lift‑and‑shift) moves workloads to the cloud while keeping the existing code base intact. Question 3. Which Secure Agent function enables connectivity to on‑premises Oracle databases from the cloud?
A) Data Integration Service B) Cloud Mapping Designer C) Agent‑based JDBC driver D) API Management Answer: C Explanation: The Secure Agent includes JDBC drivers that allow secure tunneling to on‑premises databases such as Oracle. Question 4. Which transformation in the Cloud Mapping Designer is considered “passive” because it does not change row count? A) Filter B) Aggregator C) Sorter D) Joiner Answer: C Explanation: Sorter reorders rows but does not add, drop, or combine rows, making it passive. Question 5. When exposing a legacy service as a REST API using CAI, which specification format can be imported to auto‑generate the connector? A) WSDL B) Swagger/OpenAPI
Answer: B Explanation: Unconnected Lookup can reference a flat file or in‑memory dataset, avoiding a persistent connection. Question 8. Which task type in CDI is best suited for copying an entire table from a source to a target while preserving all DML operations? A) Synchronization Task B) Replication Task C) Masking Task D) Mapping Task Answer: B Explanation: Replication Tasks capture inserts, updates, and deletes to keep source and target in sync. Question 9. What is the primary purpose of a Mapplet in CDI? A) To schedule tasks on the Secure Agent B) To encapsulate reusable transformation logic C) To monitor real‑time API calls D) To manage user permissions Answer: B Explanation: Mapplets are modular, reusable groups of transformations that can be embedded in multiple mappings.
Question 10. Which authentication method in CAI supports token‑based access without transmitting user passwords? A) Basic authentication B) OAuth 2. C) LDAP D) Kerberos Answer: B Explanation: OAuth 2.0 issues access tokens, allowing secure API calls without exposing passwords. Question 11. In IDMC, the Data Integration Service runs on which of the following? A) Cloud‑only virtual machines B) Secure Agent runtime C) API Management layer D) Process Designer UI Answer: B Explanation: The Data Integration Service is deployed as part of the Secure Agent, executing CDI tasks.
A) An on‑premises ETL tool with limited scalability B) A platform that leverages microservices, elasticity, and API‑first design C) A legacy middleware that requires manual server provisioning D) A desktop application for data mapping Answer: B Explanation: Cloud‑native platforms are built for elasticity, microservices, and API‑centric integration. Question 15. In a Synchronization Task, which option determines the direction of data flow? A) Source‑only mode B) Target‑only mode C) Bidirectional mode D) Incremental mode Answer: A Explanation: Synchronization Tasks are typically one‑way (source to target); direction is defined by the source‑only configuration. Question 16. Which transformation in CDI can be used to eliminate duplicate rows based on a key column? A) Aggregator B) Rank
C) Sorter D) Filter Answer: A Explanation: Aggregator can group rows by a key and apply functions like MIN or MAX, effectively removing duplicates. Question 17. Which Secure Agent deployment mode allows multiple agents to share the same workload for high availability? A) Standalone mode B) Clustered mode C) Embedded mode D) Remote mode Answer: B Explanation: In clustered mode, multiple agents work together, providing load balancing and failover. Question 18. Which CAI connector type would you choose to interact with a SOAP‑based legacy system? A) REST Connector B) SOAP Connector C) FTP Connector D) JDBC Connector
Explanation: Monitor displays real‑time and historical execution details, including logs and health of Secure Agents. Question 21. Which of the following is a typical use case for a Masking Task in CDI? A) Encrypting data at rest in a data lake B. Removing personally identifiable information for non‑production environments C. Converting CSV files to Parquet format D. Replicating tables across regions Answer: B Explanation: Masking Tasks replace sensitive values (e.g., SSNs) with fictitious data to protect privacy in dev/test. Question 22. Which CDI transformation type requires a defined join condition and can produce inner, left, or outer joins? A) Filter B) Joiner C) Lookup D) Rank Answer: B Explanation: The Joiner transformation supports various join types based on user‑specified keys.
Question 23. In CAI, which object defines the structure of data that will be passed between steps? A) Process Object B) Mapping Object C) Connector Object D) Agent Object Answer: A Explanation: Process Objects act as data schemas for inputs and outputs within a CAI process. Question 24. Which of the following best describes “re‑platforming” in modernization? A. Re‑writing the entire code base in a new language B. Moving the application to a managed PaaS offering without major code changes C. Deploying the application on a new physical server rack D. Adding new microservices around the legacy monolith Answer: B Explanation: Re‑platforming shifts workloads to a cloud platform (e.g., managed database) while keeping most code unchanged.
A. It runs on a customer‑controlled environment. B. It can be installed on Windows, Linux, or macOS. C. It directly hosts the IDMC UI for user interaction. D. It handles data movement between cloud and on‑premises. Answer: C Explanation: The Secure Agent does not host the UI; the UI is a cloud service accessed via a browser. Question 28. In a CDI Mapping, which transformation would you use to change the data type of a field from string to integer? A. Expression B. Filter C. Joiner D. Lookup Answer: A Explanation: The Expression transformation can apply built‑in functions like TO_INTEGER() to convert data types. Question 29. Which CAI authentication method is best suited for service‑to‑service communication where a client secret is stored securely? A. Basic authentication B. OAuth 2.0 Client Credentials flow
C. API Key D. SAML Answer: B Explanation: OAuth 2.0 Client Credentials allows a service to obtain a token using a client ID and secret. Question 30. Which of the following is a recommended practice when designing reusable Mapplets? A. Hard‑code source and target names inside the Mapplet. B. Use In‑Out parameters for dynamic column mapping. C. Limit the Mapplet to a single transformation. D. Deploy the Mapplet on every Secure Agent separately. Answer: B Explanation: In‑Out parameters make the Mapplet flexible, allowing different mappings to pass values at runtime. Question 31. In IDMC, which service provides the capability to version and promote assets across development, test, and production environments? A. Data Integration Service B. API Management C. Asset Management (Export/Import) D. Secure Agent Grouping
Explanation: The Mapper step provides data transformation capabilities, including JSON parsing and flattening. Question 34. Which of the following is NOT a type of task flow in CDI? A. Linear Taskflow B. Conditional Taskflow C. Parallel Taskflow D. Recursive Taskflow Answer: D Explanation: CDI supports linear, conditional, and parallel taskflows but does not have a built‑in “recursive” taskflow type. Question 35. In the context of API Management within IDMC, what is the purpose of a “rate limit” policy? A. Encrypt API payloads B. Restrict the number of calls per time window for a consumer C. Transform request headers D. Log API usage to a database Answer: B Explanation: Rate limiting controls how many API requests a client can make within a defined period.
Question 36. Which transformation in CDI can be configured to cache lookup data in memory for faster performance? A. Unconnected Lookup with caching enabled B. Connected Lookup without caching C. Joiner with static join D. Filter with static condition Answer: A Explanation: Enabling caching on an Unconnected Lookup stores reference data in memory, reducing repeated source reads. Question 37. When moving data from a Salesforce object to a Snowflake table using CDI, which connection type is required for the source? A. JDBC B. ODBC C. Salesforce Cloud connector D. FTP Answer: C Explanation: The Salesforce Cloud connector provides native access to Salesforce objects. Question 38. Which of the following best describes “incremental load” in a CDI Mapping?
C. Limits integration to batch processes only D. Forces all data to be stored in a single cloud vendor’s storage Answer: B Explanation: iPaaS provides serverless, scalable integration and easy API creation, aligning with modernization goals. Question 41. Which transformation allows you to assign a default value to a field when the source value is null? A. Expression B. Filter C. Joiner D. Rank Answer: A Explanation: In an Expression transformation, you can use the NVL() or ISNULL() function to substitute defaults. Question 42. Which Secure Agent setting determines which network ports are used for communication with the IDMC cloud? A. Proxy configuration B. Agent Authentication mode C. Port range setting (default 443) D. Agent grouping policy
Answer: C Explanation: The Secure Agent communicates over HTTPS (port 443) by default; this can be adjusted in the port range setting. Question 43. In a CDI Mapping, what is the effect of setting a field’s “Primary Key” property? A. It forces the field to be unique in the target. B. It enables the Aggregator to group by that field. C. It tells the engine to use that field for change detection in incremental loads. D. It disables encryption for that field. Answer: C Explanation: Marking a field as Primary Key helps the engine identify new or changed rows during incremental loads. Question 44. Which of the following CAI process actions can be used to call an external SOAP service and map its response? A. REST Connector step B. SOAP Connector step C. FTP Connector step D. Database Connector step Answer: B