Database

Correct Answer: MySQL

MySQL is not a supported query language for Amazon Neptune. Amazon Neptune is a graph database service that supports popular graph query languages such as Apache TinkerPop Gremlin, openCypher, and W3C SPARQL 1.1. MySQL, on the other hand, is a relational database management system that uses SQL (Structured Query Language) for querying and managing data. While Neptune focuses on graph data models and traversal queries, MySQL is designed for traditional relational data and SQL-based queries. Therefore, MySQL is not compatible with Amazon Neptune's graph-oriented architecture and query capabilities.

Correct Answer: Automatically scales compute and memory capacity based on application demand

Amazon Aurora Serverless automatically scales compute and memory capacity based on the demand of the application. This allows it to efficiently handle variable and unpredictable workloads by provisioning the necessary resources on-demand. The other options either provide a fixed capacity, require manual scaling, or only scale storage capacity automatically, which do not fully capture the key benefit of Aurora Serverless in automatically scaling both compute and memory based on application needs.

Correct Answer: Amazon RDS automatically performs database software patching

Amazon RDS (Relational Database Service) is a managed database service provided by AWS. It automatically handles database software patching, which eliminates the need for manual patching and simplifies database maintenance. RDS also provides automatic backup and restore capabilities, allowing for easy data recovery and protection. Additionally, RDS instances can be accessed from different Availability Zones, enabling high availability and fault tolerance. However, RDS still requires capacity planning and provisioning, as users need to specify the desired instance size and storage capacity.