Free Oracle 1Z0-1094-23 Exam Actual Questions

The questions for 1Z0-1094-23 were last updated On Jan 11, 2025

Question No. 1

Projector components in a mapping hides attributes from preceding components. All succeeding components can only use the attributes from projector component.

Which three components below are NOT a projector component in Oracle Data Integrator (ODI)? (Choose three.)

Show Answer Hide Answer
Correct Answer: B, C, E

In Oracle Data Integrator (ODI), projector components, like Aggregate and Distinct, limit the attributes available to succeeding components. Non-projector components, such as Sort, Filter, and Join, do not impose this limitation; they manipulate data streams without hiding attributes, allowing subsequent components in the mapping to access all available attributes.


Question No. 2

Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose all correct answers)

Show Answer Hide Answer
Correct Answer: A, D, E

In ODI, extracting data from Fusion SaaS applications to ADW can leverage components like the Enterprise Scheduler Service (ESS) SOAP API for job scheduling, REST API for web service interactions, and Cloud Connector for cloud-specific integrations. These components enable efficient data extraction and loading workflows from Fusion SaaS to ADW.


Question No. 3

Which autonomous database types are available on Oracle Cloud? (Choose three.)

Show Answer Hide Answer
Correct Answer: B, D, E

Oracle Cloud offers various types of Autonomous Databases, including Autonomous Data Warehouse (ADW) for analytics, Autonomous Transaction Processing (ATP) for transactional workloads, and Autonomous JSON Database for document-centric data models. These services provide self-managing, self-securing, and self-repairing database capabilities tailored to specific data management needs.


Question No. 4

Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?

Show Answer Hide Answer
Correct Answer: C

For Inflight Upgrade scenarios, Zero Downtime Migration (ZDM) supports Logical Migration only. Logical migration involves capturing and transforming the database schema and data into a logical format before transferring it to the target system, which is suitable for upgrades that involve significant changes to the database structure or version.


Question No. 5

You took a backup to DISK on the on-premises database and copied it to an Object Storage bucket to be used to instantiate a new Database Cloud Service.

Which RMAN operation is required before the backup can be restored?

Show Answer Hide Answer
Correct Answer: C

Before restoring a TDE-encrypted backup from an on-premises database to a Cloud Database Service, the RMAN operation required is to decrypt the backup if the encryption keys or wallet are not available in the target environment. This ensures the backup can be restored without encryption constraints in the new environment.