Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 99 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 99
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ.
The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes.
Which solution will meet these requirements?

A. Configure Oracle Real Application Clusters (RAC) on the EC2 instance and the RDS DB instance. Update the connection string to point to the RAC cluster. Once the EC2 instance and RDS DB instance are in sync, fail over from Amazon EC2 to Amazon RDS.
B. Export the Oracle database from the EC2 instance using Oracle Data Pump and perform an import into Amazon RDS. Stop the application for the entire process. When the import is complete, change the database connection string and then restart the application.
C. Configure AWS DMS with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
D. Configure AWS DataSync with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.

Show Suggested Answer

Suggested Answer: C 🗳️

by std2021 at April 1, 2021, 9:03 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

manan728

Highly Voted 3 years, 8 months ago

C is most plausible option even though it does not mention change data capture or CDC. Rest of the steps seem legit in option C. No other given alternative would ideally meet the 5 min downtime requirement.

upvoted 13 times

...

RotterDam

Highly Voted 3 years, 3 months ago

Selected Answer: C

this question came up in my exam. I chose (C). I passed the exam - also fairly certain this is the right answer. (I'll add this in as many questions as possible)

upvoted 10 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: C

C. Configure AWS DMS with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.

upvoted 1 times

...

IhorK

1 year, 10 months ago

Selected Answer: C

According to https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-oracle-database-to-amazon-rds-for-oracle.html B and C could be the answer - AWS Database Migration Service (AWS DMS); - Native Oracle tools. But B says "Stop the application for the entire process", while we have "a maintenance window of up to 5 minutes". So, the answer is C.

upvoted 1 times

...

lollyj

2 years, 5 months ago

Selected Answer: C

C is the most plausible

upvoted 1 times

...

novice_expert

3 years, 1 month ago

Selected Answer: C

x B. export import would take long time C. EC2 -> DMS -> new RDS -> Stop when in sync. Change db connections

upvoted 4 times

...

tugboat

3 years, 3 months ago

Selected Answer: C

C as DMS enables fastest failover

upvoted 2 times

...

kped21

3 years, 3 months ago

C: Correct B - Invalid as the exp/imp can take long time and there is only 5 min downtime

upvoted 2 times

...

Shunpin

3 years, 5 months ago

Ans:C Oracle SE only support single thread export/import. Not possible to finish within 5 minutes.

upvoted 2 times

...

jove

3 years, 6 months ago

C is correct

upvoted 2 times

...

toppic26

3 years, 6 months ago

AWS Question with DMS, solution is Oracle tool, are you serious? Answer is C

upvoted 3 times

...

Scunningham99

3 years, 7 months ago

CCCCCC -- B is a big no even for a small database would take more than 5 mins. Stopping the application for the entire process etc

upvoted 2 times

...

guru_ji

3 years, 7 months ago

Correct Answer: C

upvoted 1 times

...

Suresh108

3 years, 7 months ago

only possible choices B and C. B is wrong -- datapump import method takes longer time to migrate. it can't be done in 5 minutes - forget about it. My choice is C.

upvoted 1 times

...

Aesthet

3 years, 7 months ago

C final answer

upvoted 3 times

...

anandkl80

3 years, 8 months ago

Answer B: acle Data Pump technology enables very high-speed movement of data and metadata from one database to another. Oracle Data Pump is available only on Oracle Database 10g release 1 (10.1) and later. ... Moving Data Between Different Database Versions. Original Export and Import Versus Data Pump Export and Import.

upvoted 1 times

Huy

3 years, 7 months ago

Option B could be correct if it didn't mention 'Stop the application for the entire process'

upvoted 3 times

...

sellu

3 years, 8 months ago

Option C is correct. Option B is incorrect as it says application needs to be stopped till entire migration got completed

upvoted 4 times

...

Load full discussion...