I85PREP
⌘ K
OCI App Integration Pro (1Z0-1042-25) study materials
OCI App Integration Pro (1Z0-1042-25) study resources

OCI App Integration Pro (1Z0-1042-25) practice questions

One question at a time. Build your OCI App Integration Pro (1Z0-1042-25) understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Integration fundamentals and Oracle Cloud Application Integration architecture

In Oracle Cloud Application Integration, which component is the deployable unit that packages integrations and their connections for activation in a runtime environment?

  1. The trigger
  2. The integration project Correct answer.
  3. The connection
  4. The adapter endpoint

Explanation

An integration project groups one or more integrations, connections, lookups, and resources and is the unit that is packaged and activated together. Individual connections and triggers are design artifacts inside the project, not the deployable package.

Question 2Integration fundamentals and Oracle Cloud Application Integration architecture

An integration must start immediately when a file is created in an object storage bucket. Which trigger style fits this requirement in Application Integration?

  1. A manual run trigger
  2. A scheduled orchestration trigger
  3. An application-driven REST trigger
  4. An event-based (business event) trigger Correct answer.

Explanation

Event-based triggers subscribe to business events raised by a connected application, such as a file-created event from object storage, and start the integration on occurrence. Scheduled triggers run on a timer, REST triggers wait for an inbound call, and manual runs require user action.

Question 3Integration fundamentals and Oracle Cloud Application Integration architecture

Which statement best describes the role of a connection in Application Integration?

  1. It exposes the integration as a callable REST endpoint.
  2. It schedules the integration to run at recurring intervals.
  3. It defines the transformation mapping between source and target payloads.
  4. It stores the credentials, endpoint, and adapter configuration used to reach an external application. Correct answer.

Explanation

A connection is a reusable configuration object holding the adapter type, endpoint URL, and security credentials needed to communicate with an external system. Transformations, schedules, and exposed endpoints are defined on the integration itself, not on the connection.

Question 4Integration fundamentals and Oracle Cloud Application Integration architecture

A developer needs to expose an integration so an external system can invoke it synchronously over HTTPS. Which trigger should be configured?

  1. Scheduled orchestration
  2. Application-driven (REST) Correct answer.
  3. File-based
  4. Business event

Explanation

An application-driven trigger exposes the integration as a REST endpoint that external callers invoke, supporting synchronous request-response patterns. Scheduled and event triggers do not accept inbound synchronous calls.

Question 5Integration fundamentals and Oracle Cloud Application Integration architecture

What is the primary purpose of the activity stream within an Application Integration flow?

  1. To manage user roles and permissions
  2. To define the visual layout of the integration canvas
  3. To store environment-specific credentials
  4. To sequence the processing steps that transform, route, and invoke services Correct answer.

Explanation

The activity stream is the ordered sequence of activities that defines the runtime logic, including mapping, routing, invocation, and notification steps. Layout, credentials, and permissions are managed elsewhere in the platform.

Question 6Integration fundamentals and Oracle Cloud Application Integration architecture

Which artifact is used to store reusable reference data, such as a mapping of country codes to region names, in Application Integration?

  1. A callback
  2. A schedule
  3. A lookup Correct answer.
  4. A connection

Explanation

A lookup is a reusable key-value artifact that integrations can reference during mapping to translate codes or supply reference values. Connections, schedules, and callbacks serve different runtime purposes.

Question 7Integration fundamentals and Oracle Cloud Application Integration architecture

Which statement correctly distinguishes orchestration-style integrations from app-driven integrations in Application Integration?

  1. Orchestration integrations coordinate multiple steps and services, while app-driven integrations expose an endpoint invoked by an external application. Correct answer.
  2. Orchestration integrations run only in the design environment, while app-driven integrations run only in production.
  3. Orchestration integrations are triggered by an inbound REST call, while app-driven integrations run on a schedule.
  4. Orchestration integrations cannot use connections, while app-driven integrations must use only REST adapters.

Explanation

Orchestration integrations are flows that coordinate processing across steps and services, usually started by a schedule or event. App-driven integrations are designed to be invoked by an external application through an exposed trigger endpoint.

Question 8Integration fundamentals and Oracle Cloud Application Integration architecture

An integration receives an order payload and must route messages to different downstream services based on the order total. Which activity should be used to branch the flow?

  1. A notification activity
  2. A switch activity Correct answer.
  3. A mapper activity
  4. A wait activity

Explanation

A switch activity evaluates one or more conditions and routes the flow down the matching branch, which suits value-based routing. Mapper, notification, and wait activities perform transformation, alerting, and delay respectively.

Question 9Integration fundamentals and Oracle Cloud Application Integration architecture

A developer must call a long-running external process and continue processing only when it responds, without holding the original request open. Which mechanism should be used?

  1. A switch activity
  2. A synchronous invoke with a long timeout
  3. A scheduled trigger
  4. An asynchronous callback pattern Correct answer.

Explanation

The asynchronous callback pattern lets the integration send a request and resume when the external system calls back with a correlation identifier, avoiding long-held synchronous connections. A synchronous invoke would block until timeout, and schedules and switches do not provide response correlation.

Question 10Integration fundamentals and Oracle Cloud Application Integration architecture

Which statement accurately describes how mapper activities handle data transformation in Application Integration?

  1. They permanently delete unmapped source fields from the payload.
  2. They automatically create new connections for each target field.
  3. They map source fields to target fields and can apply functions and conditional expressions during mapping. Correct answer.
  4. They execute arbitrary SQL against the integration database.

Explanation

Mapper activities define field-level mappings and support built-in functions, expressions, and conditions to transform values between source and target structures. They do not run SQL, delete source data, or create connections.

Question 11Integration fundamentals and Oracle Cloud Application Integration architecture

What is the purpose of activating an integration in Application Integration?

  1. It compiles the integration source code into a native binary.
  2. It converts the integration into a lookup table.
  3. It deploys the integration to a runtime environment so its trigger can start processing. Correct answer.
  4. It locks the integration so it can no longer be edited.

Explanation

Activation deploys the integration and its dependencies to a runtime environment, enabling the configured trigger to start the flow. It is a deployment action, not compilation, conversion, or a permanent edit lock.

Question 12Integration fundamentals and Oracle Cloud Application Integration architecture

A developer wants to reuse the same transformation logic across several integrations. Which approach best supports reuse in Application Integration?

  1. Create a reusable library or shared resource referenced by multiple integrations. Correct answer.
  2. Place the logic in a connection's endpoint URL.
  3. Copy the mapper configuration into each integration manually.
  4. Duplicate the entire project for each integration.

Explanation

Shared resources and reusable libraries allow common transformation or utility logic to be defined once and referenced by multiple integrations. Copying, duplicating projects, or embedding logic in endpoint URLs creates maintenance problems and is not reuse.

Question 13Integration fundamentals and Oracle Cloud Application Integration architecture

Which statement about the relationship between integrations and their dependent artifacts is correct?

  1. An integration cannot reference a lookup unless the lookup is embedded in a connection.
  2. Connections are automatically deleted when an integration is activated.
  3. An integration can reference connections and lookups, and those dependencies are packaged during activation. Correct answer.
  4. Lookups must be recreated separately for each activation.

Explanation

Integrations reference connections and lookups as dependencies, and activation packages the required artifacts for the runtime. Lookups do not require connection embedding, and activation does not delete connections or force lookup recreation.

Question 14Integration fundamentals and Oracle Cloud Application Integration architecture

An integration is expected to process very high volumes of small messages with minimal latency. Which design consideration is most relevant in Application Integration?

  1. Increasing the number of switch activities in the flow
  2. Choosing an appropriate trigger type and minimizing synchronous blocking calls Correct answer.
  3. Using manual runs to control throughput
  4. Adding notification activities after every step

Explanation

Throughput and latency depend heavily on the trigger style and on avoiding unnecessary synchronous blocking calls that consume runtime resources. Extra switches, notifications, or manual runs add overhead rather than improve performance.

Question 15Integration fundamentals and Oracle Cloud Application Integration architecture

Which capability does the Application Integration monitoring console provide for activated integrations?

  1. Changing the connection credentials for all projects
  2. Editing the integration's activity stream in real time
  3. Compiling the integration into a container image
  4. Viewing instance runs, their status, and error details Correct answer.

Explanation

Monitoring shows runtime instances of activated integrations, including status, timing, and error information useful for troubleshooting. Design editing, credential changes, and image compilation are not monitoring functions.

Question 16Integration fundamentals and Oracle Cloud Application Integration architecture

A developer needs environment-specific endpoint values that differ between test and production without redesigning the integration. Which approach is appropriate?

  1. Hard-code the production endpoint in the mapper.
  2. Store the endpoint in a switch activity condition.
  3. Create separate integrations for each environment with different logic.
  4. Use connections configured per environment and reference them from the integration. Correct answer.

Explanation

Connections encapsulate endpoint and credential configuration, so the same integration logic can be activated against environment-specific connections. Hard-coding, duplicating logic, or embedding endpoints in conditions undermines portability.

Question 17Integration fundamentals and Oracle Cloud Application Integration architecture

Which statement best explains why Application Integration separates design-time artifacts from runtime instances?

  1. It eliminates the need for connections in production.
  2. It allows the same design to be activated and monitored across environments while preserving versioned logic. Correct answer.
  3. It requires all integrations to run on the developer's local machine.
  4. It prevents developers from changing integrations after the first activation.

Explanation

Separating design artifacts from runtime instances lets a versioned design be activated in different environments and monitored as separate runs. It does not freeze designs, run locally, or remove the need for connections.

Question 18Integration fundamentals and Oracle Cloud Application Integration architecture

A developer must ensure that a failed invocation of an external service does not abort the entire integration but instead follows an error path. Which construct should be used?

  1. A fault handler or scope with error handling configured on the invoke activity Correct answer.
  2. A second scheduled trigger
  3. An additional mapper activity
  4. A lookup table

Explanation

Fault handlers and error-handling scopes catch invocation failures and route them to defined error paths so the flow can recover or notify. Mappers, extra triggers, and lookups do not provide exception handling.

Question 19Integration fundamentals and Oracle Cloud Application Integration architecture

Which statement about the role of adapters in Application Integration is correct?

  1. Adapters define the protocol and payload handling used by a connection to communicate with a specific technology. Correct answer.
  2. Adapters replace the need for a trigger in every integration.
  3. Adapters store lookup tables for reference data.
  4. Adapters are only used during design and have no runtime role.

Explanation

Adapters provide technology-specific connectivity, handling protocol details and payload formats for systems such as REST, SOAP, or databases, and are configured through connections. They do not replace triggers, store lookups, or exist only at design time.

Question 20Integration fundamentals and Oracle Cloud Application Integration architecture

An architect is comparing Application Integration with Oracle Integration Cloud's process automation capabilities. Which statement is accurate?

  1. Application Integration focuses on connecting applications and orchestrating data flows, while process automation focuses on human-centric workflow with tasks and approvals. Correct answer.
  2. Both capabilities are identical and interchangeable for any use case.
  3. Application Integration provides human task approvals, while process automation only connects systems.
  4. Application Integration cannot use REST connections, while process automation can.

Explanation

Application Integration is oriented toward application connectivity and orchestration of data and events, whereas process automation targets structured human workflows with tasks and approvals. The capabilities are complementary rather than identical, and Application Integration supports REST connectivity.

Question 21Integration fundamentals and Oracle Cloud Application Integration architecture

A developer observes that an activated scheduled integration runs successfully in test but not in production, although the design is identical. Which explanation is most consistent with Application Integration architecture?

  1. The production connection used by the integration has different endpoint or credential configuration that is invalid. Correct answer.
  2. Lookups are automatically disabled outside the design environment.
  3. Scheduled triggers cannot be activated in production environments.
  4. The activity stream is recompiled differently in production.

Explanation

Because connectivity details live in connections, an identical design can behave differently when the production connection points to a wrong endpoint or has invalid credentials. Scheduled triggers, activity streams, and lookups are not inherently disabled or recompiled differently in production.

Question 22Integration fundamentals and Oracle Cloud Application Integration architecture

Which design pattern best prevents duplicate processing when an event-based integration may receive the same business event more than once?

  1. Add more switch activities to the flow
  2. Rely on the trigger to deduplicate events automatically
  3. Implement idempotency using a correlation key and a lookup or persistence check Correct answer.
  4. Increase the schedule frequency

Explanation

Event delivery can be repeated, so idempotency must be designed explicitly by checking a unique correlation key against stored state before processing. Triggers do not guarantee deduplication, and switches or faster schedules do not prevent duplicates.

Question 23Integration fundamentals and Oracle Cloud Application Integration architecture

A team wants to call an integration from an external application and receive an immediate response, but the underlying processing includes a step that may take several minutes. Which architecture is most appropriate?

  1. A synchronous app-driven integration that waits for the slow step to complete
  2. A scheduled integration that polls the external application every minute
  3. An app-driven integration that acknowledges the request and completes the slow step asynchronously with a callback Correct answer.
  4. A manual run integration triggered by an operator

Explanation

For slow processing behind a synchronous-looking interface, the robust pattern is to accept the request quickly, return an acknowledgement, and complete the work asynchronously with a callback. Blocking a synchronous call for minutes risks timeouts, while polling and manual runs do not provide responsive request handling.

Question 24Integration fundamentals and Oracle Cloud Application Integration architecture

Which consideration is most important when deciding between orchestration and app-driven integration styles for a new interface?

  1. Whether the project contains more than one lookup
  2. Whether the integration uses a mapper activity
  3. Whether the developer prefers the visual canvas layout
  4. Whether the interaction is initiated by a schedule or event versus invoked by an external caller expecting a response Correct answer.

Explanation

The decisive architectural factor is who initiates the interaction and whether a synchronous response is expected, which maps to orchestration versus app-driven styles. Mapper use, lookup count, and canvas preference are incidental design details.

Question 25Connections, adapters, and connectivity agents

In Oracle Integration, which connection role is used when an integration must be triggered by an incoming event from a source system such as a REST endpoint or a file drop?

  1. Trigger connection Correct answer.
  2. Agent connection
  3. Invoke connection
  4. Lookup connection

Explanation

A trigger connection defines the source side of an integration: it starts the flow when a request, schedule, or event arrives. Invoke connections represent the target systems the integration calls. The same adapter technology can often serve either role, but the role is determined by where it sits in the integration.

Question 26Connections, adapters, and connectivity agents

A customer needs Oracle Integration to reach a database inside a private data center that has no public inbound access. Which component must be installed in that network to enable this?

  1. Integration gateway node
  2. Service instance of a second region
  3. API gateway
  4. Connectivity agent Correct answer.

Explanation

The connectivity agent is a lightweight runtime installed on-premises that opens outbound connections to the Oracle Integration instance and relays adapter traffic to private resources. It removes the need for inbound firewall openings. The other components either serve different purposes or do not exist as described.

Question 27Connections, adapters, and connectivity agents

Which statement best describes how the connectivity agent establishes communication with the Oracle Integration cloud service?

  1. The cloud service initiates inbound connections to a listening port on the agent host.
  2. The agent requires a site-to-site VPN managed by Oracle Support.
  3. The agent uses a public DNS record that resolves to the on-premises host.
  4. The agent initiates outbound connections to the cloud and polls for work. Correct answer.

Explanation

The agent is designed to work from behind a firewall: it makes outbound HTTPS connections to the Oracle Integration instance and receives work over that channel. No inbound port or public DNS entry for the on-premises host is required. This outbound-only design is the core security property of the agent.

Question 28Connections, adapters, and connectivity agents

You are creating a REST adapter connection to an endpoint secured with OAuth 2.0 client credentials. Where is the client secret stored in Oracle Integration?

  1. In the connection's security policy configuration as a protected credential Correct answer.
  2. In the agent's properties file on the on-premises host
  3. In the project's README documentation
  4. In the integration's mapper expression as a literal string

Explanation

Credentials such as OAuth client secrets are entered through the connection's security configuration and stored as protected values in the service. Hard-coding them in mappers or documents exposes them and is not supported practice. The agent properties file holds agent registration details, not target-system credentials.

Question 29Connections, adapters, and connectivity agents

Which adapter should you choose to expose an existing database table as a REST resource without writing SQL mapping code by hand?

  1. REST Adapter with a database endpoint definition
  2. Oracle Database Cloud Service Adapter Correct answer.
  3. File Adapter
  4. SOAP Adapter

Explanation

The database adapter is the purpose-built way to browse schema objects and generate the CRUD operations for a table or view. The REST adapter describes an external REST API; it does not introspect a database schema. The SOAP and File adapters are unrelated to relational table access.

Question 30Connections, adapters, and connectivity agents

An integration uses a SOAP adapter connection whose WSDL is hosted on an internal server. The design-time connection test fails only when the agent is stopped. What is the most likely explanation?

  1. The SOAP adapter requires a REST fallback.
  2. The WSDL is reachable only through the connectivity agent. Correct answer.
  3. The connection is missing a fault-handling policy.
  4. The WSDL uses a deprecated SOAP version.

Explanation

If the connection succeeds with the agent running and fails when it is stopped, the endpoint is only reachable from the on-premises network, so traffic must flow through the agent. SOAP version, fault policies, and REST fallbacks do not explain an agent-dependent outcome. The fix is to keep the agent running and associated with the connection.

Question 31Connections, adapters, and connectivity agents

What is the purpose of creating an agent group in Oracle Integration?

  1. To group integrations that share a common schedule
  2. To define a failover region for the service instance
  3. To associate a set of connectivity agents with connections that target the same network Correct answer.
  4. To bundle multiple connections into a single adapter

Explanation

Agent groups let you associate one or more agents with the connections that need on-premises access, and multiple agents in a group provide high availability. They are a connectivity construct, not a scheduling, bundling, or disaster-recovery feature. Connections reference the agent group rather than an individual agent host.

Question 32Connections, adapters, and connectivity agents

Which file adapter operation pattern is appropriate when an integration must consume every file placed in a directory exactly once and then remove it?

  1. Write operation with append mode
  2. Write operation with overwrite mode
  3. List operation with a polling schedule
  4. Read operation with a delete-after-read option Correct answer.

Explanation

A read operation with delete-after-read processes each file and removes it so it is not picked up again. Write operations produce files rather than consume them. A list operation only enumerates filenames and does not process content.

Question 33Connections, adapters, and connectivity agents

A developer needs to call a REST endpoint that returns a large paginated payload. Which connection configuration most directly supports retrieving all pages?

  1. Increasing the connection's request timeout
  2. Adding a second invoke connection to the same endpoint
  3. Enabling pagination on the REST adapter endpoint with page-size and offset parameters Correct answer.
  4. Switching the security policy to basic authentication

Explanation

The REST adapter supports pagination configuration where you identify the request parameters or headers that control page size and offset or page number, so the runtime iterates through pages. Timeouts, authentication, and duplicate connections do not retrieve additional pages.

Question 34Connections, adapters, and connectivity agents

Which statement about adapter-specific connection properties is accurate in Oracle Integration?

  1. Properties are configured in the agent properties file rather than the connection.
  2. Each adapter exposes properties relevant to its protocol, such as directory paths or WSDL URLs. Correct answer.
  3. Properties are defined only after the integration is activated.
  4. All adapters expose an identical property set because they share one runtime.

Explanation

Each adapter surfaces configuration fields that match its protocol: a file adapter asks for directories and polling settings, a SOAP adapter asks for a WSDL URL, and so on. These are set on the connection at design time. They are not uniform across adapters, not deferred until activation, and not stored in the agent file.

Question 35Connections, adapters, and connectivity agents

You must connect to an on-premises Oracle E-Business Suite instance. Which combination is required?

  1. A REST adapter connection plus a public IP address on the EBS server
  2. A file adapter connection plus an SFTP server
  3. A SOAP adapter connection plus a WSDL hosted in the cloud
  4. An E-Business Suite adapter connection plus a connectivity agent in the EBS network Correct answer.

Explanation

On-premises packaged applications such as E-Business Suite are reached through their dedicated adapter, and because the system is private, a connectivity agent must run in that network. Exposing the server publicly or substituting file or SOAP adapters does not provide the packaged-application interface.

Question 36Connections, adapters, and connectivity agents

What happens to an activated integration that uses a connection whose agent group has no running agent?

  1. The integration is automatically deactivated and deleted.
  2. The connection silently switches to a mock endpoint.
  3. Runtime invocations that require the agent fail until an agent in the group is available. Correct answer.
  4. The integration falls back to a direct internet connection.

Explanation

There is no automatic fallback path; if no agent in the assigned group is reachable, calls that depend on it fail at runtime. The integration definition is not deleted, and no mock substitution occurs. High availability comes from running multiple agents in the group, not from fallback behavior.

Question 37Connections, adapters, and connectivity agents

Which adapter is the correct choice to publish messages to an Oracle Cloud Infrastructure Streaming topic?

  1. JMS Adapter
  2. Oracle Cloud Infrastructure Streaming Adapter Correct answer.
  3. MQ Adapter
  4. REST Adapter

Explanation

Oracle Integration provides a dedicated adapter for OCI Streaming that understands the service's endpoints and message model. The JMS and MQ adapters target traditional messaging brokers, and the generic REST adapter would require you to model the streaming API manually.

Question 38Connections, adapters, and connectivity agents

A connection test for a file adapter fails with a permission error while the agent is running. Where should you look first?

  1. The credentials used by the agent to access the directory on the file server Correct answer.
  2. The integration's mapper expressions
  3. The service instance's region setting
  4. The number of invoke connections in the integration

Explanation

A permission failure on a file operation points at the account the agent uses to authenticate to the file server and its rights on the target directory. Mapper expressions, region, and connection counts do not affect filesystem permissions. Verifying the directory path and the account's read/write rights resolves most such failures.

Question 39Connections, adapters, and connectivity agents

Which security policy should be selected on a SOAP connection when the target service requires WS-Security username tokens?

  1. OAuth 2.0 client credentials
  2. No security policy
  3. WS-Security with a username token policy Correct answer.
  4. Basic authentication over HTTPS

Explanation

WS-Security policies in the SOAP adapter add the appropriate security headers, such as username tokens, to the SOAP envelope. Basic authentication is an HTTP-level mechanism, OAuth is a token framework, and no policy sends no credentials. Choosing the wrong policy typically produces a SOAP fault from the target.

Question 40Connections, adapters, and connectivity agents

What is the recommended way to give an integration access to different target systems of the same adapter type with different credentials?

  1. Use the same connection with a dynamic endpoint override only
  2. Reuse one connection and change credentials at runtime
  3. Create a separate connection for each target system and credential set Correct answer.
  4. Store all credentials in a single lookup table

Explanation

Each connection captures the endpoint and its security configuration, so distinct targets with distinct credentials should be modeled as separate connections. Changing credentials at runtime or centralizing them in a lookup bypasses the protected credential store. Endpoint overrides do not carry their own authentication settings.

Question 41Connections, adapters, and connectivity agents

Which adapter would you use to read messages from an on-premises IBM MQ queue through the connectivity agent?

  1. REST Adapter
  2. JMS Adapter configured for the MQ broker Correct answer.
  3. File Adapter
  4. SOAP Adapter

Explanation

The JMS adapter can be configured to connect to JMS-compatible brokers such as IBM MQ, and when the broker is on-premises the agent provides the network path. REST, file, and SOAP adapters model different protocols and cannot read MQ queues.

Question 42Connections, adapters, and connectivity agents

An integration must be triggered on a fixed schedule rather than by an external event. Which connection type fits?

  1. An agent trigger connection
  2. A file adapter trigger connection
  3. A scheduled orchestration using a schedule trigger Correct answer.
  4. A REST trigger connection

Explanation

A scheduled orchestration starts on a time-based schedule and does not need an inbound event. REST and file trigger connections wait for external requests or files, and there is no 'agent trigger' connection type. The schedule is defined on the integration, not on a connection.

Question 43Connections, adapters, and connectivity agents

Which statement about the connectivity agent's high-availability configuration is correct?

  1. Agents must run on the same host to form a group.
  2. Only one agent can be registered per Oracle Integration instance.
  3. Multiple agents can be registered in one agent group so another agent serves traffic if one fails. Correct answer.
  4. Agent groups require a load balancer in front of the cloud service.

Explanation

Registering more than one agent in an agent group provides redundancy; if one agent becomes unavailable, the service can use another in the group. Agents may run on different hosts, and no customer-managed load balancer is needed for the outbound channel. A single instance can host several agents and groups.

Question 44Connections, adapters, and connectivity agents

You need to transform a comma-separated file into a JSON payload for a REST target. Which pair of components is most appropriate?

  1. SOAP adapter trigger connection and JMS adapter invoke connection
  2. REST adapter trigger connection and file adapter invoke connection
  3. File adapter trigger connection and REST adapter invoke connection Correct answer.
  4. Streaming adapter trigger connection and database adapter invoke connection

Explanation

The source is a file, so the file adapter acts as the trigger, and the target is a REST API, so the REST adapter is the invoke connection. The reverse pairing inverts source and target. SOAP, JMS, streaming, and database adapters do not match the described endpoints.

Question 45Connections, adapters, and connectivity agents

What is required before a connection that uses the connectivity agent can be tested successfully at design time?

  1. The connection must use basic authentication.
  2. The integration must already be activated.
  3. The agent must be running and associated with the connection's agent group. Correct answer.
  4. The target system must be exposed on a public IP address.

Explanation

The agent must be up and registered in the group the connection references, otherwise the design-time test cannot reach the private endpoint. Activation is not a prerequisite for testing a connection, public exposure defeats the agent's purpose, and the authentication scheme is independent of agent availability.

Question 46Connections, adapters, and connectivity agents

Which adapter supports both reading from and writing to an FTP or SFTP server?

  1. Database Adapter
  2. REST Adapter
  3. SOAP Adapter
  4. FTP Adapter Correct answer.

Explanation

The FTP Adapter supports both reading files from and writing files to FTP and SFTP servers. The REST, database, and SOAP adapters model HTTP APIs, relational data, and WSDL services respectively.

Question 47Connections, adapters, and connectivity agents

A REST connection uses a relative resource path configured at design time, but at runtime the endpoint host must vary per environment. Which approach is appropriate?

  1. Configure the endpoint URL as a connection property and override it per environment. Correct answer.
  2. Disable the connection's security policy.
  3. Hard-code the host in each mapper expression.
  4. Create a separate integration for each environment.

Explanation

Connection properties can be externalized so the endpoint address is supplied per environment without editing the integration. Duplicating integrations or embedding hosts in mappers creates maintenance burden and errors. Disabling security does not address the endpoint variation.

Question 48Connections, adapters, and connectivity agents

Which statement about invoking a SOAP service that requires a custom HTTP header is correct?

  1. The header can be configured on the SOAP adapter connection or set in the request through the integration. Correct answer.
  2. The header is set only in the agent properties file.
  3. Custom HTTP headers cannot be sent by the SOAP adapter.
  4. The header must be placed in the SOAP body as an element.

Explanation

The SOAP adapter allows transport-level headers to be configured so they are sent with the request, and they can also be supplied through the integration flow. They do not belong in the SOAP body, which carries the message payload. The agent properties file has no role in per-request headers.

Question 49Connections, adapters, and connectivity agents

Which adapter should be used to send an email notification as part of an integration flow?

  1. Email Adapter Correct answer.
  2. Database Adapter
  3. File Adapter
  4. REST Adapter

Explanation

A dedicated email adapter is provided for sending notifications through a configured mail server. The REST, file, and database adapters model unrelated protocols and would require manual workarounds. Using the email adapter keeps mail server configuration in the connection.

Question 50Connections, adapters, and connectivity agents

In Oracle Integration, a REST connection is configured to use a connectivity agent instead of direct invocation. What is the primary role of the connectivity agent in this configuration?

  1. It converts REST requests into SOAP messages before they reach the target system.
  2. It hosts the REST endpoint and generates the OpenAPI document at design time.
  3. It acts as a secure tunnel that forwards requests from the Oracle Cloud runtime to on-premises systems. Correct answer.
  4. It caches all request payloads so that integrations can be replayed after a failure.

Explanation

The connectivity agent is installed in the on-premises network and opens an outbound connection to Oracle Integration, so the cloud runtime can reach internal systems without inbound firewall rules. It transports the request; it does not host the endpoint, cache payloads, or translate REST to SOAP.