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?
AProvision an Amazon DynamoDB database with default read and write capacity settings.
BProvision an Amazon Aurora database with a minimum capacity of 1 Aurora capacity unit (ACU).
CProvision an Amazon Aurora Serverless v2 database with a minimum capacity of 1 Aurora capacity unit (ACU).
DProvision an Amazon RDS for MySQL database with 2 GiB of memory.