ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 322 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 322
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is using an Amazon RDS for MySQL DB instance for a production application. During the company’s upcoming scheduled maintenance window, a database specialist will perform a major version upgrade to the DB instance. The application is critical, so the company wants to minimize the maintenance time and allow for a rollback if a problem occurs.

Which solution will meet these requirements?

  • A. Enable the automatic upgrade option by using the AWS Management Console. Amazon RDS will apply the upgrade, which will occur during the scheduled maintenance window with no downtime.
  • B. Create a new DB instance that has the desired version. Configure AWS Database Migration Service (AWS DMS) to migrate the existing data to the new DB instance. Change the DNS records to point to the new DB instance.
  • C. Create read replica of the DB instance. Upgrade the version on the read replica. Promote the read replica to be the primary DB instance. Direct the application to use the read replica endpoint.
  • D. Create a read replica of the DB instance. Configure a policy to fall over to the read replica if failure occurs during the upgrade. Upgrade the version on the primary DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by TQM__9MD at July 14, 2023, 1:23 a.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

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
Submit Cancel
JasonZhu
1 year, 9 months ago
Selected Answer: B
It needs to minimize the maintenance time and allow for a rollback if a problem occurs. Promote read replica doesn't support rollback. But DMS does.
upvoted 1 times
JasonZhu
1 year, 9 months ago
Sorry. I misunderstand the rollback meaning. Rollback after failure to upgrade from MySQL 5.7 to 8.0 is supported. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html#USER_UpgradeDBInstance.MySQL.Major.RollbackAfterFailure
upvoted 1 times
...
...
Pranava_GCP
1 year, 10 months ago
Selected Answer: C
C is correct https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html#USER_UpgradeDBInstance.MySQL.ReducedDowntime
upvoted 3 times
...
aqiao
1 year, 10 months ago
Selected Answer: C
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MariaDB.html#USER_UpgradeDBInstance.MariaDB.Major
upvoted 3 times
aqiao
1 year, 10 months ago
create a read replica and upgrade to new version, then promote it to primary instance
upvoted 2 times
...
...
marcelodba
1 year, 10 months ago
Selected Answer: C
C is the right one
upvoted 3 times
...
Windy
1 year, 11 months ago
It's C.
upvoted 2 times
...
TQM__9MD
1 year, 12 months ago
Selected Answer: C
C is answer
upvoted 3 times
TQM__9MD
1 year, 12 months ago
D is better
upvoted 2 times
Skarlex77
1 year, 5 months ago
Failover to a read replica is a manual process
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