Download PrepIQ Informatica Cloud Integration for Application Modernization Foundation Level ” Ult and more Exams Technology in PDF only on Docsity!
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 1. Which component of IDMC provides the runtime engine for executing Cloud Data Integration tasks? A) Secure Agent B) Data Integration Service C) API Manager D) Process Designer Answer: B Explanation: The Data Integration Service is the runtime engine that executes CDI tasks such as mappings, synchronizations, and replications. Question 2. In the context of application modernization, rehosting is best described as: A) Rewriting the application code for cloud-native services B) Moving the application to a cloud infrastructure without changes C) Replacing the database with a cloud-managed service D) Exposing the application via REST APIs only Answer: B Explanation: Rehosting (also called lift-and-shift) moves the existing application to the cloud with little or no modification. Question 3. Which Secure Agent deployment mode allows the agent to run on a virtual machine in a private data center? A) Cloud-only mode B) On-premises mode C) Hybrid mode D) Edge mode Answer: B Explanation: On-premises mode installs the Secure Agent on a VM or physical server within the private data center, enabling connectivity to on-prem sources.
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 4. Which transformation in Cloud Mapping Designer is considered a passive transformation? A) Aggregator B) Joiner C) Filter D) Sorter Answer: C Explanation: Passive transformations do not change the number of rows; a Filter only decides whether a row passes through. Question 5. When designing a Mapping, which property determines whether a lookup caches data in memory? A) Cache Size B) Cache Type C) Lookup Mode D) Cache Refresh Interval Answer: B Explanation: The Cache Type setting (e.g., Full Cache, Partial Cache) controls how the lookup caches source data. Question 6. Which API authentication method uses a token obtained from an authorization server? A) Basic Authentication B) API Key C) OAuth 2. D) LDAP Bind Answer: C Explanation: OAuth 2.0 issues access tokens after the client authenticates with the authorization server.
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
B) Mapping Task C) Replication Task D) Masking Task Answer: C Explanation: Replication Tasks replicate source objects to the target with little or no transformation. Question 11. In the IDMC UI, where can you view the health status of all Secure Agents? A) Monitor > Agents B) Connections > Agents C) Administrator > Secure Agents D) Dashboard > Agent Health Answer: C Explanation: The Administrator > Secure Agents page lists each agent and its connectivity status. Question 12. Which transformation would you use to calculate the total sales per region in a Mapping? A) Joiner B) Aggregator C) Rank D) Sorter Answer: B Explanation: The Aggregator groups rows and computes aggregate functions such as SUM. Question 13. When exposing a CAI process as an API, which component defines the endpoint URL and request/response schema? A) Service Connector B) API Manager
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
C) Process Object D) API Specification (Swagger/OpenAPI) Answer: D Explanation: The Swagger/OpenAPI specification describes the endpoint, methods, and payload schemas. Question 14. Which of the following is a characteristic of a cloud-native integration platform? A) Requires on-prem hardware for all executions B. Supports auto-scaling and multi-tenant architecture C) Only handles batch processing D) No support for REST APIs Answer: B Explanation: Cloud-native platforms are built for elasticity, multi-tenancy, and API-centric integration. Question 15. In a Synchronization Task, which option enables you to transfer only rows that changed after the last run? A) Full Load B) Incremental Load using a Change Data Capture (CDC) column C) Truncate Target before load D) Use of a Filter transformation Answer: B Explanation: Incremental load with a CDC column captures only rows modified since the previous execution. Question 16. Which Secure Agent group setting allows you to assign tasks to a specific subset of agents? A) Agent Pool B) Agent Cluster C) Agent Group
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Answer: D Explanation: Distributed Cache is not a native CDI option; CDI offers Full, Partial, and No Cache. Question 20. In the context of data masking, which technique replaces sensitive characters with a constant value? A) Shuffling B) Nulling C) Substitution D) Encryption Answer: C Explanation: Substitution masking replaces original characters with a predefined constant (e.g., “XXXX”). Question 21. Which IDMC service enables you to orchestrate multiple CDI tasks in a defined sequence? A) Process Designer B) Taskflow Service C) Data Integration Service D) API Manager Answer: B Explanation: Taskflow Service lets you chain CDI tasks (Mappings, Sync, Replication) into a workflow. Question 22. When creating a REST Service Connector manually, which field defines the HTTP method to be used? A) Endpoint URL B) Authentication Type C) HTTP Verb D) Request Body Answer: C
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Explanation: The HTTP Verb (GET, POST, PUT, DELETE) specifies the method for the REST call. Question 23. Which of the following best describes a “Hybrid Integration Platform”? A) Only on-prem integration tools B) Cloud services that cannot connect to on-prem systems C) A platform that can integrate both cloud and on-prem applications using a Secure Agent D) A platform limited to batch processing Answer: C Explanation: Hybrid platforms combine cloud capabilities with Secure Agents to reach on-prem resources. Question 24. Which transformation can be used to assign a sequential number to rows based on a sort order? A) Rank B) Sorter C) Sequence Generator D) Expression Answer: A Explanation: The Rank transformation can generate row numbers (rank) after sorting. Question 25. Which option in the Monitor service helps you view detailed error messages for a failed task? A) Dashboard Overview B) Session Log C) Agent Health D) Task Summary Answer: B
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Explanation: The Decision step evaluates expressions and routes execution based on true/false outcomes. Question 29. Which of the following is a recommended practice for improving performance of a Mapping that joins large tables? A) Use a Full Cache lookup on the larger table B) Disable all indexes on source tables C) Add a Filter after the Joiner D) Use a Sorter before the Joiner Answer: A Explanation: Caching the larger table reduces repeated reads and speeds up the join operation. Question 30. Which Secure Agent installation option provides the highest level of isolation? A) Shared installation on a server B) Docker container deployment C) Installation on a developer workstation D) Installation on a virtual machine with no network access Answer: B Explanation: Deploying the agent in a Docker container isolates it from host processes and simplifies lifecycle management. Question 31. Which transformation can be used to remove duplicate rows based on a key column? A) Aggregator with GROUP BY B) Filter C) Rank with “Row_Number = 1” D) Expression with DISTINCT function Answer: C
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Explanation: Using Rank and selecting only rows where the rank equals 1 eliminates duplicates. Question 32. In IDMC, what does the “Publish” action do for a CAI process? A) Executes the process immediately B. Saves the process as a draft C) Makes the process available as an API endpoint D) Deletes the process from the environment Answer: C Explanation: Publishing a CAI process registers it with the API Manager so it can be invoked as a service. Question 33. Which of the following is a limitation of a Synchronization Task compared to a Mapping Task? A) Cannot read from cloud sources B) Does not support complex transformations C) Cannot write to on-prem targets D) Does not allow incremental loads Answer: B Explanation: Sync tasks are designed for simple column-to-column moves and lack the rich transformation capabilities of mappings. Question 34. Which option defines the maximum number of parallel threads a Mapping can use during execution? A) Concurrency Level B) Partitioning Mode C) Thread Count D) Parallelism Setting Answer: B Explanation: Partitioning Mode (e.g., Horizontal, Dynamic) determines how many partitions (threads) run in parallel.
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 38. Which IDMC feature allows you to move assets (mappings, connections, processes) between Development and Production environments? A. Export/Import Package B. Clone Workspace C. Sync Repository D. Version Control Integration Answer: A Explanation: Export/Import packages bundle assets for transport across environments. Question 39. Which transformation is required when you need to combine data from three source tables into a single output stream? A. Joiner (multiple joins) B. Union C. Lookup (connected) D. Aggregator Answer: B Explanation: The Union transformation merges rows from multiple sources without requiring join keys. Question 40. What is the primary purpose of the “Taskflow” object in CDI? A. To design real-time API calls B. To schedule mappings on a calendar C. To orchestrate a series of integration tasks in a defined order D. To monitor Secure Agent health Answer: C Explanation: Taskflows define the execution sequence of multiple CDI tasks (e.g., mappings, sync tasks).
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 41. Which of the following best describes a “Stateless” API in the context of CAI? A. Requires the client to maintain session information on the server B. Does not store any client context between calls C. Stores user preferences in a database for each request D. Uses cookies to persist data across calls Answer: B Explanation: Stateless APIs treat each request independently, without retaining session state on the server. Question 42. Which Secure Agent setting determines the maximum memory it can use for caching lookups? A. Cache Size Limit B. JVM Heap Size C. Agent Memory Allocation D. Data Buffer Size Answer: B Explanation: The JVM heap size controls how much memory the agent can allocate for in-memory caches. Question 43. In CAI, which step type would you use to transform incoming JSON data into a flat structure for downstream processing? A. Transform B. Decision C. Call Service D. Loop Answer: A Explanation: The Transform step allows you to map, rename, or reshape data structures.
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 47. In a Mapping, what is the purpose of the “Input/Output Parameter” type? A. To pass values into the mapping at runtime and retrieve results B. To define static default values only C. To create temporary tables in the target database D. To configure connection credentials Answer: A Explanation: Input/Output parameters enable dynamic values (e.g., filter dates) to be supplied when the mapping runs. Question 48. Which of the following best describes “Data Governance” within IDMC? A. Only encrypting data at rest B. Managing data quality, lineage, and access controls across integration flows C. Automating server patching D. Providing high-availability for Secure Agents Answer: B Explanation: Data governance encompasses policies for quality, lineage, security, and compliance across data pipelines. Question 49. Which transformation can be used to generate a new column that concatenates first and last name fields? A. Filter B. Expression C. Rank D. Joiner Answer: B Explanation: An Expression transformation can apply the CONCAT function to combine fields.
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 50. Which CAI feature allows you to version and rollback an API service? A. Process Designer B. API Manager – Service Versions C. Taskflow Scheduler D. Secure Agent Groups Answer: B Explanation: API Manager tracks multiple versions of a published service and enables rollback. Question 51. Which type of connection would you use to read a CSV file stored in Amazon S3? A. File System Connection B. S3 Connection C. FTP Connection D. Cloud Application Integration Connection Answer: B Explanation: An S3 Connection accesses objects in Amazon S3, including CSV files. Question 52. In a Mapping, what does the “Dynamic Partitioning” option enable? A. Automatic determination of partition count based on source size B. Manual specification of fixed number of partitions C. Disabling parallelism altogether D. Encrypting each partition separately Answer: A Explanation: Dynamic partitioning lets the engine decide how many partitions to create at runtime for optimal performance.
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 56. Which of the following best defines “Re-factoring” in the context of modernization? A. Moving the application to a new server B. Re-writing code to improve structure, performance, or scalability without changing functionality C. Adding new features to the UI D. Re-deploying the same binaries to a cloud VM Answer: B Explanation: Re-factoring improves internal code quality while preserving external behavior. Question 57. In CDI, which transformation can be used to assign a deterministic hash value to a column for partitioning? A. Sequence Generator B. Expression (using HASH function) C. Sorter D. Aggregator Answer: B Explanation: The HASH function in an Expression generates a numeric hash useful for partitioning. Question 58. Which of the following is a primary advantage of using a Secure Agent group for a set of integration tasks? A. Guarantees zero latency B. Enables load balancing and high availability across agents C. Removes the need for any cloud resources D. Allows tasks to run without any authentication Answer: B Explanation: Grouping agents distributes workload and provides failover if one agent becomes unavailable.
Integration for Application
Modernization Foundation Level ”
Ultimate Exam
Question 59. Which CAI component is responsible for handling message retries and dead-letter queues? A. Process Designer B. Event Source Configuration C. API Manager D. Secure Agent Answer: B Explanation: Event Source settings define retry policies and dead-letter handling for asynchronous triggers. Question 60. Which transformation would you use to sort rows before feeding them into a Rank transformation? A. Sorter B. Filter C. Joiner D. Aggregator Answer: A Explanation: The Sorter ensures rows are ordered appropriately for Rank calculations. Question 61. Which of the following best describes the “Publish” vs. “Deploy” actions for a CAI process? A. Publish makes the process available as an API; Deploy schedules it for execution. B. Publish saves the process; Deploy deletes it. C. Publish runs the process immediately; Deploy creates a backup. D. Publish and Deploy are synonyms in CAI. Answer: A Explanation: Publishing registers the process as a callable API; deployment moves it to a runtime environment.
