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?

1 / 1
Select an answer
CorrectC

Explanation

Selecting a managed RDB whose operations can be delegated.

  • 1relational databaseA tabular RDB (such as MySQL/PostgreSQL)
  • 2delegating operations like backups, patching, and failure recovery to AWSA managed service that performs operations on your behalf = RDS
AIncorrect

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.

BIncorrect

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.

CCorrect

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.

DIncorrect

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.

Key Takeaway

'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.