AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company has an on-premises MySQL database used by the global sales team with infrequent access patterns. The sales team requires the database to have minimal downtime. A database administrator wants to migrate this database to AWS without selecting a particular instance type in anticipation of more users in the future.
Which service should a solutions architect recommend?
Other
Community
UAnonymous
A
Amazon Aurora MySQL
B
Amazon Aurora Serverless for MySQL
C
Amazon Redshift Spectrum
D
Amazon RDS for MySQL
Explanation:
Explanation
Amazon Aurora Serverless for MySQL is the correct choice for this scenario because:
-
Infrequent access patterns: The sales team has infrequent access patterns, which makes serverless architecture ideal as it automatically scales capacity based on actual usage and can scale to zero when not in use, reducing costs.
-
Minimal downtime requirement: Aurora Serverless provides high availability with automatic failover and multi-AZ deployments, ensuring minimal downtime.
-
No instance type selection: The database administrator wants to avoid selecting a particular instance type. Aurora Serverless abstracts away instance management - you don't need to choose instance types, sizes, or manage scaling operations manually.
-
Anticipation of more users: Aurora Serverless automatically scales compute capacity up and down based on application demand, making it perfect for unpredictable or growing workloads.
-
MySQL compatibility: The company has an on-premises MySQL database, and Aurora Serverless for MySQL provides MySQL compatibility, making migration easier.
Why not the other options:
- A. Amazon Aurora MySQL: Requires selecting instance types and managing scaling manually, which doesn't meet the requirement of avoiding instance type selection.
- C. Amazon Redshift Spectrum: This is for querying data in S3, not for migrating an on-premises MySQL database. It's a data warehouse service, not a transactional database service.
- D. Amazon RDS for MySQL: Requires selecting instance types and managing scaling, similar to Aurora MySQL, and doesn't provide the automatic scaling capabilities of Aurora Serverless.
Key benefits of Aurora Serverless:
- Automatic scaling based on actual usage
- Pay-per-second billing
- No instance management required
- High availability with multi-AZ deployments
- MySQL compatibility for easy migration
Comments
Loading comments...