exam questions

Exam 1z0-1072-20 All Questions

View all questions & answers for the 1z0-1072-20 exam

Exam 1z0-1072-20 topic 1 question 16 discussion

Actual exam question from Oracle's 1z0-1072-20
Question #: 16
Topic #: 1
[All 1z0-1072-20 Questions]

Which two methods are supported for migrating your on-premises Oracle database to an Oracle Autonomous Transaction Processing (ATP) database in Oracle
Cloud Infrastructure? (Choose two.)

  • A. Load text files into ATP using SQL Developer.
  • B. Use RMAN duplicate.
  • C. Use Oracle Data Pump.
  • D. Transfer the physical database files and re-create the database.
  • E. Use database backup and restore.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
KAYSERSOZE
Highly Voted 3 years, 10 months ago
IT is A and C. REF: https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION-BOOKMARK It is clearly written that RMAN is NOT supported and "Data Pump" is the official way to go.
upvoted 14 times
...
Carminetor
Highly Voted 4 years, 1 month ago
AC are correct. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-sqldeveloper-web.html#GUID-C06A4E05-CCD1-4241-A8FB-76A19F5F727F
upvoted 10 times
...
abhijitviktor
Most Recent 2 years, 1 month ago
B, C RMAN Duplicate is mentioned on ORacle Documentation https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/migrating.htm
upvoted 1 times
...
_Ahmed_Hassan_
3 years ago
i think answers C & D
upvoted 2 times
Yeanka
2 years, 11 months ago
It should be CD
upvoted 1 times
...
...
Sherifci
3 years, 2 months ago
Selected Answer: AC
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB. In the current release you cannot use physical migration methods like backup/restore, Data Guard, database clones, and transportable tablespaces to move your existing database to ADB.
upvoted 3 times
...
Dylan3160
3 years, 2 months ago
A,C correct How can I migrate my existing Oracle Database to Oracle Autonomous Database? : Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
upvoted 1 times
...
ethylyn
3 years, 2 months ago
B AND C. Already pass the ADB exam just like this is the question
upvoted 1 times
...
JavierV
3 years, 10 months ago
B and C maybe https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/mig-rman-duplicate-active-database.htm This topic explains how to migrate an entire, active container database (CDB) or non-CDB database to Oracle Cloud Infrastructure by using RMAN Active Duplication. The database to be migrated can reside on-premises or in Oracle Cloud Infrastructure Classic.
upvoted 1 times
...
briansbums
3 years, 10 months ago
B and C https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/migrating.htm Migration Methods Many methods exist to migrate Oracle databases to the Oracle Cloud Infrastructure Database service. Which of these methods apply to a given migration scenario depends on several factors, including the version, character set, and platform endian format of the source and target databases. Data Pump Conventional Export/Import Data Pump Full Transportable Data Pump Transportable Tablespace Remote Cloning a PDB Remote Cloning Non-CDB RMAN Cross-Platform Transportable PDB RMAN Cross-Platform Transportable Tablespace Backup Sets RMAN Transportable Tablespace with Data Pump RMAN DUPLICATE from an Active Database RMAN CONVERT Transportable Tablespace with Data Pump SQL Developer and INSERT Statements to Migrate Selected Objects SQL Developer and SQL*Loader to Migrate Selected Objects Unplugging/Plugging a PDB Unplugging/Plugging Non-CDB Zero Downtime Migration Service
upvoted 3 times
vlad_74
3 years, 8 months ago
why this option can not be used? SQL Developer and INSERT Statements to Migrate Selected Objects
upvoted 1 times
Joe_Qu
2 years, 8 months ago
Because of the "selected objects" clause. You want to migrate the entire DB
upvoted 1 times
...
...
abhijitviktor
2 years, 1 month ago
Thanks for this. As per Oracle official document RMAN/Data Pump are valid options. B,C are correct
upvoted 1 times
...
...
satyalanka
3 years, 10 months ago
A nd C is the answer RMAN wont work and what we will do by copying data files to OCOI when RMAN is not supported
upvoted 1 times
...
d5a865u
4 years ago
A and C are the correct answers
upvoted 2 times
...
AmrWaly
4 years ago
i think A & C are the most proper ways. RMAN is not supported for migration and any backup/ or physical DB files should have the same file / DB structure in order to migrate directly
upvoted 3 times
...
dreadsi3
4 years ago
A and C
upvoted 1 times
...
riso51
4 years, 1 month ago
I think it's AC. RMAN, or physical migration methods like backup/restore are not supported (https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html)
upvoted 3 times
...
pattabi
4 years, 2 months ago
RMAN and Data pump makes more sense in migration, since there is no data volume in question
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago