RDS supported engines in AWS - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Amazon RDS?

Amazon RDS is a cloud service that makes it easy to set up, operate, and scale a relational database in the cloud.

beginner

Name three database engines supported by Amazon RDS.

Amazon RDS supports engines like MySQL, PostgreSQL, and Oracle Database.

beginner

Which Amazon RDS engine is fully managed and compatible with Microsoft SQL Server?

Amazon RDS supports Microsoft SQL Server as a fully managed engine.

intermediate

What is Amazon Aurora in the context of RDS?

Amazon Aurora is a high-performance, fully managed relational database engine compatible with MySQL and PostgreSQL.

intermediate

Can Amazon RDS support multiple database engines simultaneously?

Yes, Amazon RDS supports multiple engines, but each RDS instance runs only one engine at a time.

Which of the following is NOT a supported Amazon RDS engine?

A MySQL

B Oracle Database

C PostgreSQL

D MongoDB

Amazon RDS does not support MongoDB, which is a NoSQL database. RDS supports relational engines like MySQL, PostgreSQL, and Oracle.

Amazon Aurora is compatible with which database engines?

A MySQL and PostgreSQL

B Oracle and SQL Server

C MongoDB and Cassandra

D SQLite and MariaDB

Aurora is designed to be compatible with MySQL and PostgreSQL engines.

Which Amazon RDS engine would you choose for a fully managed Microsoft SQL Server database?

A Aurora

B SQL Server

C MySQL

D PostgreSQL

Amazon RDS supports Microsoft SQL Server as a fully managed engine.

Can a single Amazon RDS instance run multiple database engines at the same time?

A No, it runs only one engine per instance.

B Only for MySQL and PostgreSQL.

C Only if using Aurora.

D Yes, it can run multiple engines simultaneously.

Each RDS instance runs only one database engine at a time.

Which of these is a key benefit of using Amazon Aurora?

A Runs on local servers only

B Supports NoSQL queries

C High performance and scalability

D Requires manual backups

Aurora offers high performance and scalability as a fully managed relational database.

List all the database engines supported by Amazon RDS and describe one key feature of each.

Think about popular relational databases and Amazon's own engine.

Explain why you might choose Amazon Aurora over standard MySQL or PostgreSQL on RDS.

Consider speed and cloud optimization.