A company is migrating its application to AWS and requires a database solution that supports transactional SQL queries. Additionally, the company wants to minimize administrative overhead by ensuring that OS patching and database engine maintenance are handled by AWS. Which two of the following options represent correct services or architectural decisions for this setup? (Select TWO.)
- Deploying Amazon Aurora to run the transactional database workloadsAnswer
- Selecting a managed service like Amazon RDS to offload database engine patching and OS maintenance to AWSAnswer
- CUsing Amazon DynamoDB to store the transactional relational schemas and run complex SQL JOIN queries
- DRunning the database engine on a single Amazon EC2 instance alongside the application code to keep resources tightly coupled
- EConfiguring client-side controls to manage physical security and access authorization to the AWS data center hosting the database
Answer
The correct choices are deploying Amazon Aurora to run transactional database workloads and selecting a managed service like Amazon RDS to offload patching and OS maintenance to AWS.
Deploying Amazon Aurora and selecting Amazon RDS are correct because both are fully managed relational database services that support SQL queries and transactional workloads. As managed services, they automatically handle infrastructure provisioning, operating system patching, and database engine maintenance, reducing administrative overhead for the customer.
Step-by-Step Solution
Key Concept
AWS managed relational database services, such as Amazon RDS and Amazon Aurora, provide standard SQL transactional support while offloading database administration tasks (like OS patching and database engine updates) to AWS under the Shared Responsibility Model.