1z0-1094-22 by Oracle Valid Free Exam Practice Test

Question 1

Which three backup mediums are supported when migrating a database with oracle zero downtime migration?. (Choose all correct answers)

A. Tape Storage B. NFS Storage C. Third-Party Cloud Storage D. Oracle Cloud Infrastructure Object Storage E. Oracle Zero data loss recovery appliance

Correct Answer: B,D,E

Question 2

Which TWO provisions are required for Oracle Zero Downtime Migration (ZDM) to perform a database migration successfully with the physical workflow? (Choose all correct answers)

A. Root user or SSH key-based access to target database server B. Root user or SSH key-based access to source database server C. ZDM_BASE group access enabled D. Jmx connections to be accepted from multiple hosts

Correct Answer: A,C

Question 3

When migrating an Oracle database, you must be aware of source and target requirements. Which TWO statements are true about using Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

A. Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-. B. Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated to Enterprise Edition Databases. C. Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM. D. When migrating with Oracle ZDM and the target database is at a higher patch level than the source database, the data patch utility runs on the target database as a post-migration task.

Correct Answer: A,C

Question 4

Which developer tool can be used to load JSON documents to an Oracle database on the cloud?

A. REST Data Services B. SQL Developer C. Modeler D. SQL Developer Web

Correct Answer: D

Question 5

Which are THREE target database prerequisites for database cloud migration with Oracle Zero Downtime Migration? (Choose all correct answers)

A. Transparent Data Encryption (TDE) must be enabled. B. The database db_name should be the same as the source database. C. The TDE wallet status must be open. D. The database can be created only after migration has begun. E. The TDE wallet status must be closed.

Correct Answer: A,B,C

Question 6

You are planning the migration of a 19c Oracle Database from Amazon Web Services Relational Database Service (AWS RDS) using RMAN backups. What is the correct sequence of operations?

A. Using the AWS tooling, take an RMAN backup of the RDS DB local file system and copy sctly to. an Oracle Cloud Infrastructure (OCI) Object Storage bucket. Restore the backup from the OCI bucket to an OCI DB Service Instance. B. Install the 0B Cloud Backup Module on the AWS ROS instance and perform a backup directly to an Oracle Cloud Intrastructure (OCI) Object storage bucket. Restore the backup from the OCI bucktt to an OCT DB Service instance C. Install the Oracle Secure Backup Cloud Module on the AWS RDS Instance and take an RMAN backup directly to an AWS 53 bucket. Copy the content of the S3 bucket to an Oracle Cloud E. Infrastructure (OCI) Object Storage bucket. Restore the backup from the OCI bucket to an OCT DB Service Instance. D. Using the AWS tooling, take an RMAN backup of the RDS DB local file system and move it to an AWS S3 bucket. Copy the content of the S3 bucket to an Oracle Cloud Infrastructure (OCT) C. Object Storage bucket, Restore the backup from the OCI bucket to an OCI DB Service Instance.

Correct Answer: D

Question 7

Your data warehouse load consists of extracting data from order header and order line items table. what kind of journalizing type should you use in Oracle Data Integration ( ODI ) to make sure referential integrity is maintained in the target?

A. Consistent B. Complex C. Application Base D. Simple

Correct Answer: A

Question 8

What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?

A. Data Load tab of the SQL worksheet in Database Actions B. RMAN Transportable Tablespace C. Data Pump Transportable Tablespaces D. Remote cloning a pluggable database (PDB)

Correct Answer: A

Question 9

Which TWO methods should you use when migrating a target database with different endianness than the source database? (Choose all correct answers)

A. RMAN RESTORE from target B. RMAN CONVERT C. RMAN Transportable Tablespaces with Data Pump D. RMAN DUPLICATE

Correct Answer: A,C

Question 10

You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?

A. It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping. B. It is not possible to join data from different source connection types in a Single mapping C. Flat file data has to have a header row in order to join with Oracle database table in a single mapping D. Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load. E. It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle.

Correct Answer: A

Oracle Cloud Database Migration and Integration 2022 Professional - 1z0-1094-22 Exam Practice Test