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 wants to migrate its on-premises Microsoft SQL Server Enterprise edition database to AWS. The company's online application uses the database to process transactions. The data analysis team uses the same production database to run reports for analytical processing. The company wants to reduce operational overhead by moving to managed services wherever possible.
Which solution will meet these requirements with the LEAST operational overhead?
Other
Community
UAnonymous
A
Migrate to Amazon RDS for Microsoft SQL Server. Use read replicas for reporting purposes
B
Migrate to Microsoft SQL Server on Amazon EC2. Use Always On read replicas for reporting purposes
C
Migrate to Amazon DynamoDB. Use DynamoDB on-demand replicas for reporting purposes
D
Migrate to Amazon Aurora MySQL. Use Aurora read replicas for reporting purposes
Explanation:
Explanation
Correct Answer: A
Why Option A is correct:
- Managed Service: Amazon RDS for Microsoft SQL Server is a fully managed relational database service that minimizes operational overhead. AWS handles database administration tasks like provisioning, patching, backup, recovery, and scaling.
- Read Replicas: RDS supports read replicas that can offload reporting workloads from the primary database, improving performance for both transactional and analytical processing.
- SQL Server Compatibility: Since the company is already using Microsoft SQL Server Enterprise edition, migrating to RDS for SQL Server provides the smoothest migration path without requiring application changes.
- Reduced Operational Overhead: This solution aligns perfectly with the requirement to "reduce operational overhead by moving to managed services wherever possible."
Why other options are incorrect:
Option B (Microsoft SQL Server on Amazon EC2):
- This requires managing EC2 instances, which means the company would be responsible for OS patching, database installation, configuration, backup, and recovery.
- Higher operational overhead compared to RDS.
- While Always On read replicas can be used, this solution doesn't minimize operational overhead as requested.
Option C (Amazon DynamoDB):
- DynamoDB is a NoSQL database, not a relational database like SQL Server.
- Migrating from SQL Server to DynamoDB would require significant application changes and data model redesign.
- DynamoDB is not suitable for complex SQL queries and transactional processing that SQL Server applications typically require.
- This would create high migration complexity and operational overhead during transition.
Option D (Amazon Aurora MySQL):
- Aurora MySQL is a MySQL-compatible database, not SQL Server compatible.
- Migrating from SQL Server to MySQL would require significant application changes, schema conversion, and potential data type mapping issues.
- While Aurora is a managed service, the migration effort and application changes would create substantial operational overhead.
Key Considerations:
- The requirement emphasizes "LEAST operational overhead" - this means choosing the most managed solution that requires minimal changes.
- RDS for SQL Server provides the best balance of managed service benefits while maintaining compatibility with existing SQL Server applications.
- Read replicas effectively separate transactional and analytical workloads, improving performance without requiring separate database technologies.
Comments
Loading comments...