DBS-C01 Question #316: Real Exam Question with Answer & Explanation

Question

An ecommerce company uses an Amazon Aurora MySQL DB cluster to process payments. The company's database specialist notices that Aurora performs database maintenance actions periodically. The database specialist is concerned because the upcoming maintenance window conflicts with a company sales event. What should the database specialist do to address this concern with the LEAST operational effort?

Options

• AAdd a new Aurora Replica so that the maintenance action occurs on the Aurora Replica first.
• BDefer the maintenance action in the AWS Management Console or by using the AWS CLI.
• CDelete the maintenance action in the AWS Management Console or by using the AWS CLI.
• DAdd a new Aurora standby DB instance so that the maintenance action occurs on the standby DB

Explanation

To address an Aurora maintenance window conflict with a sales event with minimal effort, the database specialist should simply defer the maintenance action using the AWS Management Console or AWS CLI.

Common mistakes.

• A. Adding a new Aurora Replica does not guarantee that maintenance will occur on the replica first, nor does it inherently prevent maintenance on the primary instance during the critical period, as maintenance schedules apply to all instances in a cluster.
• C. Maintenance actions cannot typically be "deleted" in AWS RDS or Aurora; they are essential for security, patches, and feature updates, making deferral the only viable option.
• D. There is no concept of an "Aurora standby DB instance" separate from Aurora Replicas in the context of maintenance scheduling; adding another replica does not automatically shift the maintenance window for the entire cluster.

Concept tested. Aurora maintenance window management

Reference. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_RDS_Maintenance.html

No community discussion yet for this question.