1Z0-1094-21 Exam Training Practice Tests (Oracle Cloud Database Migration and Integration 2021 Specialist)]

Question 1

Which parameter can be used to export a subset of data using Data Pump?

A. SUBSET_AS_TABLES B. VIEWS_AS_TABLES C. TABLES_AS_VIEWS D. MATERIALIZED_VIEWS

Correct Answer: B

Question 2

Which TWO statements are true about cross-endian migration using Transportable Tablespaces? (Choose all correct answers)

A. Tablespaces must be compressed. B. system and sysaux can be migrated cross-endian. C. Tablespaces may not be encrypted. D. Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER.

Correct Answer: C,D

Question 3

You run a database instance on Oracle Database 11.2 and you want to migrate to Oracle Cloud. In which case is it required to upgrade your source database before migrating to the cloud?

A. if you are using virtual machines B. if you are using unplug/plug C. if your target is Exadata Cloud Service D. if you are using Recovery Manager (RMAN)

Correct Answer: C

Question 4

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

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

Correct Answer: A,C

Question 5

Your source tables are in an on-premises Oracle Database. You are creating a data server in Oracle Data Integrator (ODI) topology. Which THREE configuration items are needed to successfully test an on-premises Oracle Database connection ? (Choose 3 all correct answers)

A. name of the Oracle Instance (SID) or service B. listing port of the oracle listener C. database link D. list of all schemas E. network name or IP address of the machine hosting the Oracle Database

Correct Answer: A,B,E

Question 6

Which entry in a Data Pump parameter file ensures consistent export using Data Pump migration to Autonomous Database?

A. METRIC B. PARALLEL C. LOGTIME D. FLASHBACK_TIME

Correct Answer: D

Question 7

Which type of autonomous database will you create for decision support systems that run fast queries over large volumes of data?

A. Autonomous Transaction Processing B. Autonomous JSON Database C. Autonomous APEX Service D. Autonomous Data Warehouse

Correct Answer: D

Question 8

Which THREE methods can be used to migrate an on-premises Oracle Database to Oracle Autonomous Database? (Choose all correct answers)

A. Enterprise Manager B. Data Pump Export/lmport C. Data Guard D. PDB Unplugging/Plugging E. Oracle Zero Downtime Migration

Correct Answer: A,B,E

Question 9

You are trying to load a denormalized target table C and the source attributes come from table A and Table B in Oracle Data Integrator (ODI). Which statement is true?

A. A mapping can have only one source and one target. You need to create 2 mappings to load target C. B. You are required to do outer join between table A and table B in order to load target C. C. You are required to do inner join between table A and table B in order to load target C. D. You can join table A and table B, as required by the data model and load target C in a Single mapping

Correct Answer: D

Question 10

Which migration method gives you the least down time?

A. Transportable Tablespaces B. Data Guard C. RMAN point-in-time recovery D. Data pump

Correct Answer: B

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