Oracle Cloud Infrastructure 2023 AI Foundations Associate — Question 30

Which three tasks can be executed when you submit a data integration job to an Oracle Data Integrator (ODI) agent? (Choose three.)

Answer options

• A. The execution of a design-time object, such as a mapping, a package or a procedure.
• B. An operation on a model, submodel, or a data store, such as a customized reverse-engineering or a journalizing operation.
• C. The backing up of data warehouse destination objects before loading the transformed data.
• D. The setting up of an FTP server as a staging location for extracted data.
• E. The execution of a runtime scenario or a Load Plan that was launched from the Oracle Data Integrator Studio, from a command line, via a schedule or a web service interface.

Correct answer: A, B, E

Explanation

The correct answers are A, B, and E because these tasks are valid operations that can be executed by an ODI agent. Option C is incorrect because backing up data warehouse objects is not a task performed by an ODI agent during job submission. Option D is also incorrect as setting up an FTP server is not a direct task related to submitting a data integration job.