Bitzu

CLF-C02 ยท Database services

Managed database vs database on Amazon EC2

What AWS handles in a managed database (patching, backups, failover) versus running a database on Amazon EC2, and when full control is worth it.

Key points

  • Database on Amazon EC2: AWS runs hardware, power, cooling; you install and patch the OS and engine, configure backups, high availability, scaling.
  • Managed (Amazon RDS, Aurora, DynamoDB): AWS also handles installation, patching, backups, failover, scaling.
  • You still own schema design, query tuning, data and access control.
  • EC2 only for OS-level access or an engine or configuration the managed service lacks.

Source: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html

Practice questions

Single choice

Which task does AWS take over when you move a MySQL database from Amazon EC2 to Amazon RDS?

  1. Tuning slow SQL queries
  2. Patching the database engine software
  3. Designing the table schema
  4. Deciding which users can read the data
Show answer

Answer: B. Patching the database engine software

With Amazon RDS, AWS installs and patches the database software. Query tuning and schema design stay with the customer in both models, and hardware is already AWS's job on EC2.

Select all that apply

A team runs Oracle Database on Amazon EC2. Which tasks are the team's responsibility (not AWS's)?

  1. Applying operating system patches
  2. Scheduling and testing database backups
  3. Replacing failed physical server hardware
  4. Installing database engine updates
  5. Providing power and cooling to the data center
Show answer

Answer: A. Applying operating system patches, B. Scheduling and testing database backups, D. Installing database engine updates

On EC2 the customer installs and patches the OS and database software and configures backups. AWS maintains the physical servers and the power, network and cooling of the data center.

True or false

Once a database moves to Amazon RDS, AWS also becomes responsible for tuning the application's slow queries.

Show answer

Answer: False

False. Amazon RDS hosts the infrastructure and software, but query tuning stays with the customer because it depends on schema design, data and access patterns.

Practice 8 questions on this topic in Bitzu

Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.

Download on the App StoreGet it on Google Play

More CLF-C02 topics in this module