ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 911 - SAA-C03 discussion

Report
Export

A company is planning to migrate an on-premises online transaction processing (OLTP) database that uses MySQL to an AWS managed database management system. Several reporting and analytics applications use the on-premises database heavily on weekends and at the end of each month. The cloud-based solution must be able to handle read-heavy surges during weekends and at the end of each month.

Which solution will meet these requirements?

A.

Migrate the database to an Amazon Aurora MySQL cluster. Configure Aurora Auto Scaling to use replicas to handle surges

Answers
A.

Migrate the database to an Amazon Aurora MySQL cluster. Configure Aurora Auto Scaling to use replicas to handle surges

B.

Migrate the database to an Amazon EC2 instance that runs MySQL. Use an EC2 instance type that has ephemeral storage. Attach Amazon EBS Provisioned IOPS SSD (io2) volumes to the instance.

Answers
B.

Migrate the database to an Amazon EC2 instance that runs MySQL. Use an EC2 instance type that has ephemeral storage. Attach Amazon EBS Provisioned IOPS SSD (io2) volumes to the instance.

C.

Migrate the database to an Amazon RDS for MySQL database. Configure the RDS for MySQL database for a Multi-AZ deployment, and set up auto scaling

Answers
C.

Migrate the database to an Amazon RDS for MySQL database. Configure the RDS for MySQL database for a Multi-AZ deployment, and set up auto scaling

D.

Migrate from the database to Amazon Redshift. Use Amazon Redshift as the database for both OLTP and analytics applications.

Answers
D.

Migrate from the database to Amazon Redshift. Use Amazon Redshift as the database for both OLTP and analytics applications.

Suggested answer: A

Explanation:

A. Aurora MySQL: Handles OLTP workloads efficiently with built-in replication and auto-scaling capabilities.

B. EC2 with MySQL: Requires heavy manual maintenance and does not scale seamlessly.

C. RDS for MySQL: Limited in auto-scaling compared to Aurora.

D. Redshift: Primarily for OLAP, not suitable for OLTP workloads.


asked 29/11/2024
muhammad ikram
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first