Amazon DynamoDB
Amazon DynamoDB is a fully managed key-value NoSQL database.
Delegating operations is shared, but it cannot meet the requirement to use a relational database engine such as MySQL or PostgreSQL as-is, so it is incorrect.
Which service is BEST suited for using a relational database such as MySQL or PostgreSQL while delegating operations like backups, patching, and failure recovery to AWS?
Selecting a managed RDB whose operations can be delegated.
Amazon DynamoDB
Amazon DynamoDB is a fully managed key-value NoSQL database.
Delegating operations is shared, but it cannot meet the requirement to use a relational database engine such as MySQL or PostgreSQL as-is, so it is incorrect.
Install a database on Amazon EC2 yourself.
Installing a database on EC2 yourself is possible, but you must operate backups, patching, and redundancy entirely on your own.
This does not match the requirement to delegate operations to AWS, so it is incorrect.
Amazon RDS
Correct. Amazon RDS is a managed service that provides relational databases. AWS performs operations such as backups, patching, and failover, so users can focus on using the database.
Amazon Redshift
Amazon Redshift is a data warehouse specialized in aggregating and analyzing large volumes of data.
SQL can be used, but the requirement for managed operation of MySQL/PostgreSQL for the day-to-day transaction processing of business applications is met by RDS, and this is incorrect.
'Relational database' and 'delegate operations to AWS' point to Amazon RDS. Self-managed builds on EC2 put operations on you. A higher-performance, cloud-native RDB is Aurora.