RDS supported engines in AWS - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Identify the supported RDS engine for a relational database

Which of the following is a supported engine type for Amazon RDS that is designed for relational databases?

A Amazon Neptune

B Amazon DynamoDB

C Amazon ElastiCache

D Amazon Aurora

💡 Hint

Think about engines that support SQL and relational data models.

Amazon Aurora is a relational database engine supported by Amazon RDS. DynamoDB is a NoSQL database, ElastiCache is for caching, and Neptune is a graph database.

🧠 Conceptual

intermediate

Select the RDS engine that supports PostgreSQL compatibility

Which Amazon RDS engine provides compatibility with PostgreSQL?

A Amazon Aurora PostgreSQL

B Amazon DocumentDB

C Amazon Redshift

D Amazon Aurora MySQL

💡 Hint

Look for the engine name that includes PostgreSQL.

Amazon Aurora PostgreSQL is an RDS engine compatible with PostgreSQL. Aurora MySQL is compatible with MySQL, Redshift is a data warehouse, and DocumentDB is for document databases.

❓ Architecture

advanced

Determine the best RDS engine for a multi-AZ high availability setup

You need a managed database with automatic failover across multiple availability zones. Which RDS engine supports this feature natively?

A Amazon RDS for MariaDB

B Amazon Aurora

C Amazon RDS for Oracle Standard Edition

D Amazon RDS for SQL Server Express Edition

💡 Hint

Consider engines designed for high availability and fault tolerance.

Amazon Aurora supports multi-AZ deployments with automatic failover built-in. Other engines support multi-AZ but may have limitations or require additional configuration.

❓ security

advanced

Identify which RDS engine supports encryption at rest using AWS KMS

Which Amazon RDS engine supports encryption at rest using AWS Key Management Service (KMS)?

A Amazon DynamoDB

B Amazon ElastiCache for Redis

C Amazon RDS for MySQL

D Amazon S3

💡 Hint

Focus on RDS engines and their encryption capabilities.

Amazon RDS for MySQL supports encryption at rest using AWS KMS. ElastiCache, DynamoDB, and S3 are different services with their own encryption methods.

❓ service_behavior

expert

Predict the behavior when launching an unsupported engine version in RDS

What happens if you try to launch an Amazon RDS instance with an engine version that is not supported by AWS?

A The launch request fails with an error indicating unsupported engine version.

B The instance launches but automatically upgrades to the nearest supported version.

C The instance launches but runs in a degraded mode with limited features.

D The instance launches successfully and AWS notifies you later about the unsupported version.

💡 Hint

Consider AWS's approach to unsupported configurations.

AWS prevents launching RDS instances with unsupported engine versions by failing the request immediately to avoid unstable or unsupported environments.