1z0-1042-24 Oracle Cloud Infrastructure 2024 Application Integration Professional Questions and Answers

Both the Apache Kafka and OCI Streaming adapters support XML, JSON, and AVRO message formats.

The OCI Streaming adapter does not support consuming messages from a specified consumer group.

The Apache Kafka Adapter can be configured to support Transactions in case of Producers.

It is not mandatory to install a connectivity agent to use the OCI Streaming Adapter for Inbound polling.

The Wait action can only be positioned as the last action within the loop.

The Wait action cannot be used in a synchronous flow.

The maximum wait time cannot exceed 300 seconds.

The maximum wait time cannot exceed 20 seconds within a While loop.

All transformation mappings use eXtensible Stylesheet Language (XSL).

In the designer view, the Sources section contains data structure of all available data objects, which includes integration metadata, tracking variables, global variables, and integration property values.

The data structure for the target service is always displayed on the right side in the designer view.

All source and target data objects are represented internally as JSON structures.

When you navigate to the mapper and select a target element, Expression Builder launches in auser-friendly mode by default.

Event pattern integrations

Schedule pattern integrations

SOAP trigger connection-based integrations

File trigger connection-based integrations

Configure the REST Adapter to use the Basic Authentication or OAuth 2.0 security policy.

Enable Cross-Origin Resource Sharing (CORS) and set an API key in the REST Adapter configuration.

Set up an IP whitelist in the OIC instance, allowing only specific IP addresses to access the integration.

Encrypt the payload using a custom encryption algorithm and provide the decryption key to authorized clients.

You cannot drag and drop an XSLT flow control statement directly to a target node element.

You can drag and drop a source data element to multiple target node elements.

You cannot drag and drop a source data element to a target node element that is already mapped.

You cannot drag and drop an XPath function activity directly to a target node element.

Increase the number of instances to handle the error.

Contact Oracle Support.

Immediately restart the integration instance.

Check the instance activity stream for specific error messages and details.

Create a connection between the two systems, then use a SQL query to access the Lookup table directly, and map the customer status codes.

Define a Lookup table containing the customer status code mappings, and then use the Invokeaction to call a web service for the transformation.

Design a custom script to perform the transformation, and then use the Lookup function within a Map action to reference the script and transform the customer status codes.

Create a Lookup table with the mappings of customer status codes, and then use the Lookup function within a Map action to reference the table and perform the transformation.

Manually trigger the integration by sending an email to a specified email address with the required REST parameters.

Export the integration as a .jar file and run it in a local development environment.

Use the Test button in the integration designer to create a request, validate the response, and review the execution logs.

Perform a SQL query on the associated database to ensure that the expected data is present.

Import the JavaScript library file into your OIC instance’s database schema, then use a Local Invoke action to call the function.

Import the JavaScript library file to the project, then use the JavaScript action within the integration flow to reference the library function.

Copy and paste the JavaScript function code into a new JavaScript stage within the integration flow, then map the inbound and outbound data elements in the corresponding Map action.

Use the Function Call action within the integration flow to reference the external URL that is hosting the JavaScript library function.

iCal

cron

YAML

Groovy

SOAP clients can easily hold stateful references to remote server-side SOAP objects.

SOAP is platform independent and programming language independent.

SOAP typically leverages XML-based payloads to communicate between two client machines across any modern network.

SOAP commonly serves as a cleaning agent that removes excess data from the transmissionprotocol.

SOAP provides flexibility for message formatting allowing for loose coupling between a client and a server.

SOAP over HTTP is typically not blocked by firewalls and proxy servers.

Edit

Invoke

Monitor

View

Use the Raise Fault action within your integration flow to generate custom faults and handle them accordingly.

Create a separate integration solely for the purpose of handling faults and configure your main integration to call it when necessary.

Open the Global Fault handler page on the integration canvas and add actions as needed to handle unexpected faults.

Add a Try-Catch action to your integration flow and configure it to catch and handle any faults.

To change an integration identifier or version, you can manually edit the exported integration (IAR) file before importing it into another instance.

You cannot import an integration if it already exists with the same identifier and version.

You can export an integration either as a separate file (IAR) or bundled in a package (PAR) and it will still contain the connection resources.

You can import a package containing activated integrations.

Use the REST adapter configuration wizard to define the structure of the CSV when configuring the invoke connection, then map the MTOM attachment directly.

Map the received MTOM attachment directly to the REST adapter invoke map action using the encodeReferenceToBase64 function.

Create and register a JavaScript function to convert the contents, invoke it using the JavaScript call action, then map the result to the REST adapter invoke map action.

Create an NXSD in Oracle JDeveloper to define the schema of the CSV and use it to map the transformed data to the REST adapter invoke map action.

SOAP clients can easily hold stateful references to remote server-side SOAP objects.

SOAP is platform independent and programming language independent.

SOAP typically leverages XML-based payloads to communicate between two client machines across any modern network.

SOAP commonly serves as a cleaning agent that removes excess data from the transmission protocol.

SOAP provides flexibility for message formatting allowing for loose coupling between a client and a server.

SOAP over HTTP is typically not blocked by firewalls and proxy servers.

Exported integrations include all their dependent connection resource information except URLs and credentials.

Integration must be exported as a project deployment if you want to import them into another OIC environment.

Imported integrations cannot be immediately activated if their dependent connection resources are not already present in the target OIC environment.

Imported integrations can be reconfigured to use different connection resources by using the OIC REST API.

Receive Business Events raised within ERP Cloud

Send Files to ERP Cloud

Extract Bulk Data from ERP Cloud

Query, Create, Update, or Delete Information

When you open the Map Editor for a request or response message in an integration, the data structures are automatically populated with the information pulled from the trigger and invoke connections.

An application pattern integration can contain one or more trigger (source) connections for requests sent to OIC and one or more invoke (target) connections for requests sent from OIC.

Using the connectivity agent, you can create hybrid integrations and exchange messages between applications in private or on-premises networks and OIC.

OIC Lookups are based on a static definition, meaning you create and populate them during design time.

7

5

Unlimited

10

Performing inbound polling for records to process in an Oracle Autonomous Data Warehouse database

Transferring files to an FTP server installed on-premises or behind a firewall

Creating orders in Oracle E-Business Suite

Publishing messages to Azure Service Bus

Create a custom batch call function, register the function as a Library in your OIC environment, then use the JavaScript call action to invoke the application.

Reactivate the integration and use the disable tracing and message tracking option, which will optimize performance for each invocation to the application.

Use the Append option in the Write File operation of the Stage File action within a loop to create a single batch file to be sent to the application.

Throttle the individual synchronous calls by adding a wait activity prior to each invocation to the application within the loop, then fetch a batch response after the loop.

"FREQ=DAILY;BYDAY!=SA,SU;BYHOUR=15"

"FREQ=WEEKLY;BYDAY=MO-FR;BYHOUR=15"

"FREQ=DAILY;BYDAY=MO-FR;BYHOUR=15"

"FREQ=WEEKLY;BYDAY=MO,TU,WE,TH,FR;BYHOUR=15"

Any external SFTP client can access file server if an OIC administrator has configured specific folder access permissions for that client.

To write files to the OIC File Server from an internal OIC integration flow, a REST adapter connection resource must be used.

Access to the OIC File Server management REST APIs is limited to users with the ServiceAdministrator role.

The OIC File Server is a feature that is disabled by default in a newly provisioned OIC instance.

decodeBase64

encodeBase64

encodeReferenceToBase64

decodeBase64ToReference

Add a Try-Catch action to your integration flow and configure it to catch and handle faults.

Create a separate fault handling integration and configure your integration to invoke it when necessary using the Rethrow Fault action.

Open the Global Fault Handler page on the integration canvas and add actions to handle faults.

Use the Throw New Fault action within your integration flow to send caught faults to the OIC Error Hospital.

Read, write, list, download

Read, write, list, download, move

Read, write, list

Read, write, list, download, move, delete

Read, write