Q20 — AWS SAA-C03 Ch.6

Question 20 of 65 | ← Chapter 6

Q385. A company runs an application on AWS. The application receives inconsistent amounts of usage.The application uses AWS Direct Connect to connect to an on-premises MySQL-compatible database.The on- premises database consistently uses a minimum of 2 GiB of memory. The company wants to migrate the on-premises database to a managed AWS service. The company wants to use auto scaling capabilities to manage unexpected workload increases. Which solution will meet these requirements with the LEAST administrative overhead?

Correct Answer: C. Provision an Amazon Aurora Serverless v2 database with a minimum capacity of 1 Aurora capacity unit (ACU)

Explanation

Amazon Aurora Serverless v2 is a fully managed,-demand, auto-scaling relational database service provided by AWS. automatically scales up or down based on the application's workload, allowing for efficient resource utilization and cost savings.By choosing Amazon Aurora Serverless v2, the company can offload the administrative tasks of managing database capacity to AWS. The service automatically scales the database capacity based on the workload, eliminating the need for manual scaling or provisioning.Option A (Provisioning an Amazon DynamoDB database) may not be suitable for migrating an existing MySQL-compatible database as it uses a different data model (NoSQL). Additionally, DynamoDB does not directly support auto-scaling based workload.Option B (Provisioning an Amazon Aurora database with a minimum capacity of 1 ACU) requires manual capacity management and does not provide the same level of auto-scaling capabilities as Aurora Serverless v2.Option D (Provisioning an Amazon RDS for MySQL database with 2 GiB of memory) also requires manual capacity management and does not offer the same level of auto-scaling capabilities as Aurora Serverless v2.