Your company is planning to move its on-premises MySQL database to an AWS RDS Instance. They want to understand what are the key activities that will be performed by AWS which would reduce the administrative activities of their IT staff. Which of the following is carried out by AWS for database hosted in the AWS RDS? Choose 2 answers from the options given below.

Answer options:

A.Create and maintain backups so that you can restore to a point in time recovery of 5 minutes.
B.Create and maintain backups which are specially built for long term retention of 6 months to one year.
C.Installing critical security patches for the database.
D.Optimizing database queries fired on the database.

Correct Answers: A and C
Option B is incorrect since the maximum retention period possible for RDS databases is 35 days.
Option D is incorrect because query optimization is not at all related to RDS. Query optimization is related specifically to the respective database engine.
Option C is correct because Amazon RDS is a fully managed service. So, under the Shared Responsibility Model, AWS will take care of the security patches.
The AWS Documentation mentions the following.
Periodically, Amazon RDS performs maintenance on Amazon RDS resources. Maintenance most often involves updates to the DB instance`s underlying operating system (OS) or database engine version.
You can restore a DB instance to a specific point in time, creating a new DB instance. RDS uploads transaction logs for DB instances to Amazon S3 every 5 minutes.
For more information on point in time recovery and maintaining a database, please visit the below URLs-
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html