Exam AWS Certified Database - Specialty topic 1 question 246 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 246
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company plans to migrate a MySQL-based application from an on-premises environment to AWS. The application performs database joins across several tables and uses indexes for faster query response times. The company needs the database to be highly available with automatic failover.
Which solution on AWS will meet these requirements with the LEAST operational overhead?

A. Deploy an Amazon RDS DB instance with a read replica.
B. Deploy an Amazon RDS Multi-AZ DB instance.
C. Deploy Amazon DynamoDB global tables.
D. Deploy multiple Amazon RDS DB instances. Use Amazon Route 53 DNS with failover health checks configured.

Show Suggested Answer

Suggested Answer: B 🗳️

by mbar94 at Sept. 7, 2022, 12:21 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

mbar94

Highly Voted 2 years, 9 months ago

Selected Answer: B

High availability = Multi AZ

upvoted 5 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: B

B. Deploy an Amazon RDS Multi-AZ https://aws.amazon.com/rds/features/multi-az/ "Support high availability for your application with automatic database failover that completes as quickly as 60 seconds with zero data loss and no manual intervention." "In an Amazon RDS Multi-AZ deployment, Amazon RDS automatically creates a primary database (DB) instance and synchronously replicates the data to an instance in a different AZ. When it detects a failure, Amazon RDS automatically fails over to a standby instance without manual intervention."

upvoted 4 times

...