Question 26
Domain 3: Cloud Technology and ServicesYou work as an on-premises MySQL DBA. The work of database configuration, backups, patching, and DR can be time-consuming and repetitive. Your company has decided to migrate to the AWS Cloud. Which of the following can help save time on database maintenance so you can focus on data architecture and performance?
Correct answer: A
Explanation
Amazon RDS is a managed database service that handles routine administration tasks such as configuration, backups, patching, and disaster recovery. By offloading these repetitive maintenance duties, it lets DBAs focus on data architecture and performance instead of infrastructure management.
Why each option is right or wrong
A. Amazon RDS.
Amazon RDS is the managed database service that offloads routine administration under the AWS Shared Responsibility Model, including automated backups with a retention period you set from 0 to 35 days, automated software patching during a preferred maintenance window, and built-in Multi-AZ options for failover and disaster recovery. For a MySQL workload, it directly reduces the manual work of configuration, backup operations, patch management, and DR planning that an on-premises DBA would otherwise perform.
B. Amazon Redshift.
C. Amazon DynamoDB.
D. Amazon CloudWatch.