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

Question 1

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

A. import over Oracle Database database link

B. import dump file from OCI Object Storage

C. pdb unplug/plug

D. RMAN Backup and Restore

Correct Answer: A,B

Question 2

Which statements are true about Data Pump? (Choose two.)

A. It supports cross-endian formats

B. It supports cross-platform migration

C. A best practice is to invoke Data Pump using SYS as SYSDBA

D. Both the source and target database must be of the same version

Correct Answer: A,B

Question 3

Which developer tool is web-based, function-rich, and resides in a low code development environment?

A. IMPEXPDP

B. DATAPUMP

C. APEX

D. RMAN

Correct Answer: C

Question 4

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

A. FLASHBACK_TIME=SYSTIMESTAMP (for consistent Export)

B. versron=10 (for compatibility)
exclude=statistics (for performance

C. metrics=yes (for Diagnostics)

D. parameter=1 (for performance)
logtime=all (for Diagnostics)

Correct Answer: A,B,C,D

Question 5

Which source database versions are supported for OCI Database Migration? (Choose two.) (Choose all correct answers)

A. Oracle Database 11g

B. Oracle Database 10g R2

C. Oracle Database 19c

D. Oracle Database 10g R1

Correct Answer: A,C

Question 6

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

A. goldengate_lag

B. ogg_latency

C. Lag_view

D. gg_lag

Correct Answer: D

Question 7

Which process does Oracle Data Integrator Enterprise Edition use to process and transform data for disparate relational database management systems or Big Data Engines?

A. SOA

B. DML

C. ETL

D. ELT

Correct Answer: D

Question 8

Which of these provide Active Replication? (Choose two.)

A. Sharding

B. Flashback

C. Active Data Guard

D. GoldenGate

Correct Answer: C,D

Question 9

Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? (Choose all correct answers)

A. Exadata Cloud Service

B. Database Cloud service Bare Metal

C. Autonomous Database

D. Infrastructure as a service

Correct Answer: A,C

Question 10

Which Oracle Database Cloud Service takes care of all routine database tasks ensuring higher performance, reliability, security, and operational efficiency?

A. Oracle MySQL Cloud Service

B. Oracle 19c

C. Oracle Autonomous Database

D. Oracle Exadata

Correct Answer: C

Welcome to TestSimulate

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