Free Oracle Cloud Database Migration and Integration 2021 Specialist Exam 1Z0-1094-21 Exam Practice Test

Which statements are true for Zero Downtime Migration? (Choose two.)

• It is a complex process that requires you to raise an SR with Oracle Support.
• It ensures zero data loss.
• It is free.
• It does not leverage Oracle MAA best practices.

Which statements are true for OCI GoldenGate Service? (Choose two.)

• It requires any source environment to run Oracle GoldenGate Microservices.
• It is customer-managed.
• It requires an on-premises license for the Oracle GoldenGate software.
• It supports the usage of Universal Credits.

Which view is used to measure the replication latency between source and target when using the automatic heartbeat table feature, in GoldenGate?

• gg_lag
• goldengate_lag
• ogg_latency
• Lag_view

Which FOUR key parameters should you include in your export command when migrating an Oracle Database to the Oracle Cloud? (Choose all correct answers)

• FLASHBACK_TIME=SYSTIMESTAMP (for consistent Export)
• parameter=1 (for performance) logtime=all (for Diagnostics)
• versron=10 (for compatibility) exclude=statistics (for performance
• metrics=yes (for Diagnostics)

What TWO ways does Data Pump use to move data to the cloud? (Choose all correct answers)

• RMAN Backup and Restore
• pdb unplug/plug
• import over Oracle Database database link
• import dump file from OCI Object Storage

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)

• Enterprise Scheduler Service (ESS) SOAP API
• Universal Content Management
• BI Application Configuration Manager
• REST API
• Cloud Connector

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)

• Jmx connections to be accepted from multiple hosts
• Root user or SSH key-based access to target database server
• Root user or SSH key-based access to source database server
• ZDM_BASE group access enabled

Which TWO options are valid when using the unplug/plug a PDB method to migrate? (Choose all correct answers)

• Non-CDB databases can be consolidated and migrated.
• Source database versions are 12c or later.
• Target database versions must be 18c or later.
• Use this technique to do a cross-endian conversion

Which are TWO benefits of Extract-Load-Transform (ELT) over traditional Extract-Transform-Load (ETL) architectures? (Choose all correct answers)

• ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.
• ELT architecture can easily become a bottleneck by placing excessive loads on the target servers.
• ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.
• Traditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload.

You have decided to use Oracle Data Integrator (ODI) on Marketplace to load data from an onpremises Oracle Database to Autonomous Database on Oracle Cloud Infrastructure (OCI). Which TWO methods can be used to connect to the on-premises Oracle Database from OCI? (Choose all correct answers)

• Oracle directory
• VPN Connect
• Terminal service
• Fast connect