Oracle Exam 1Z0-997-22 Topic 7 Question 33 Discussion

Actual exam question for Oracle's 1Z0-997-22 exam

Question #: 33
Topic #: 7

A2Z corporation is into e-commerce business and is the choice of millions for the best offers it launches. It has a rich set of intelligent applications that runs 24x7 and are very critical to their business.

Continuous infrastructure management and maintenance, rise in customer base and workloads, have made them to think of migrating all workloads to cloud. They have selected Oracle Cloud Infrastructure for migrating both their application and database workload.

You, as an oracle pre-sales consultant has been asked to provide complete migration strategy for their source database workloads which includes oracle and MSSQL. They are particularly concerned about their oracle databases which cannot afford any downtime. They would be establishing fast connect from their data center to oracle data center to avoid any network impact. Their oracle database is around 90TB and MSSQL is around 10TB.

How would you propose the safe migration of customer database while meeting their availability requirement?

APropose the use of zero-downtime migration tool for oracle database and use combination of SQL Developer and Oracle SQL Loader for MSSQL migration

BPropose the use of Oracle datapump for oracle databases and SQL Developer for MSSQL database

CPropose the use of zero-downtime migration tool for oracle database and use combination of SQL Developer and Oracle GoldenGate for MSSQL migration

DPropose the use of Oracle GoldenGate to perform zero downtime migration for both MSSQL and Oracle source databases

Show Suggested Answer

Suggested Answer: C

by Jeanice at Mar 08, 2024, 11:38 PM

Limited Time Offer

25%

7 months ago

I think option A sounds like a good choice for migrating the oracle database.

upvoted 0 times

...