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 176 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 176
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is running its critical production workload on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must move the workload to a new
Amazon Aurora Serverless MySQL DB cluster without data loss.
Which solution will accomplish the move with the LEAST downtime and the LEAST application impact?

A. Modify the existing DB cluster and update the Aurora configuration to ג€Serverless.ג€
B. Create a snapshot of the existing DB cluster and restore it to a new Aurora Serverless DB cluster.
C. Create an Aurora Serverless replica from the existing DB cluster and promote it to primary when the replica lag is minimal.
D. Replicate the data between the existing DB cluster and a new Aurora Serverless DB cluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled.

Show Suggested Answer

Suggested Answer: D 🗳️

by cynthiacy at Dec. 2, 2021, 12:10 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

MultiAZ

1 year, 5 months ago

Selected Answer: C

Answer is C You can now mix and match Serverless and normal Auroras in the same cluster.

upvoted 1 times

...

Windy

1 year, 11 months ago

The Answer is B for Serverless V2.

upvoted 1 times

...

SamDDD

1 year, 12 months ago

By the way, in Serverless V2 it is possible to fail over: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.upgrade.html#aurora-serverless-v2.switch-from-provisioned This question is a bit old.

upvoted 3 times

...

manig

2 years, 1 month ago

Creating serverless readreplica and promoting whenever lag is minimal is the best option I can go with - C DMS is the longest route

upvoted 2 times

...

teo2157

2 years, 4 months ago

Selected Answer: D

You can´t create an Aurora Serverless replica from the existing Aurora DB cluster. With no downtime, the answer is definitely D

upvoted 1 times

...

parle101

2 years, 6 months ago

Answer is B https://aws.amazon.com/premiumsupport/knowledge-center/aurora-migrate-provisioned-serverless/

upvoted 1 times

...

RBSK

2 years, 6 months ago

Selected Answer: C

I am really confused here. Pls refer to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html - Which clearly says that "Aurora Replicas connect to the same storage volume as the primary DB instance, but support read operations only". Which means there is no lag at all given Read replicas connect the same storage. Hence i will go for "C" which is the simplest from operations perspective

upvoted 2 times

lehoang15tuoi

2 years, 1 month ago

You really need to study again, very carefully. Replica is a basic concept in RDS and Aurora. Replicas and primary are the type of nodes in the *SAME* cluster, be it a RDS cluster or Aurora cluster. So when you are creating an "Aurora Serverless Replica", there has to be an Aurora *Serverless* Primary in the first place. That doesn't exist in the question - there is only an "Aurora MySQL DB cluster" In other words, "You can´t create an Aurora Serverless replica from the existing Aurora DB cluster"

upvoted 1 times

confusedyeti69

1 year, 4 months ago

English is way harder than databases apparently

upvoted 1 times

...

Jiang_aws1

2 years, 8 months ago

C vs D : looks take same amount of to do finial data sync & C is much simple than D C: Just auto sync by Aurora Replica D: Sync data by CDC

upvoted 1 times

...

rlnd2000

3 years, 1 month ago

Both C and D provides near Zero down time but the option C says "...when the replica lag is minimal" for me this is unacceptable for a "business's mission-critical production workload", B is out, impossible without downtime. I will go with D

upvoted 1 times

...

novice_expert

3 years, 2 months ago

Selected Answer: D

D. Replicate the data between the existing DB cluster and a new Aurora Serverless DB cluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled. for DMS: Aurora Serverless can not be source but can be target

upvoted 4 times

...

kret

3 years, 2 months ago

Selected Answer: D

because of the limited downtime requirement I'll go with DMS and D

upvoted 2 times

...

RotterDam

3 years, 4 months ago

Selected Answer: D

B looks tempting but it will result in downtime. D wont have any downtime

upvoted 3 times

...

awsmonster

3 years, 5 months ago

Option B

upvoted 1 times

awsmonster

3 years, 5 months ago

You can't use AWS Database Migration Service and Change Data Capture (CDC) with Aurora Serverless DB clusters. Only provisioned Aurora DB clusters support CDC with AWS DMS as a source. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.limitations

upvoted 1 times

awsmonster

3 years, 5 months ago

Sorry, D is correct. The doc state it does not support as Source, but the Aurora Serverless in this question is target.

upvoted 4 times

...

Germaneli

1 year, 9 months ago

That applies only to Serverless V1. You can use AWS Database Migration Service (DMS) and Change Data Capture (CDC) with Aurora Serverless v2 DB clusters though. Implementing Change Data Capute (CDC) with Aurora Serverless v2. https://dev.to/omarrosadio/implementing-change-data-capute-cdc-with-aurora-serverless-v2-4i1l

upvoted 1 times

...

Shunpin

3 years, 6 months ago

Selected Answer: D

The requirement to Minimum Downtime and from Provisioned to Serverless. The best choice is DMS.

upvoted 2 times

...

jove

3 years, 6 months ago

Option D

upvoted 1 times

...

[Removed]

3 years, 7 months ago

B. https://aws.amazon.com/rds/aurora/faqs/ Amazon Aurora is drop-in compatible with existing MySQL open-source databases and adds support for new releases regularly. This means you can easily migrate MySQL databases to and from Aurora using standard import/export tools or snapshots. It also means that most of the code, applications, drivers, and tools you already use with MySQL databases today can be used with Aurora with little or no change.

upvoted 2 times

RotterDam

3 years, 4 months ago

yes but snapshot restore has downtime

upvoted 1 times

...

RotterDam

3 years, 4 months ago

Since you would need to stop the writes on the source for this to work > Take snapshot and restore. then repoint the app - depending on the size of the database this could be substantial. With DMS its zero and the question is asking about LEAST DOWNTIME and LEAST APPLICATION IMPACT

upvoted 2 times

...

cynthiacy

3 years, 7 months ago

D. https://medium.com/@souri29/how-to-migrate-from-amazon-rds-aurora-or-mysql-to-amazon-aurora-serverless-55f9a4a74078

upvoted 4 times

...