Question #1669
A company is migrating its on-premises Microsoft SQL Server database to AWS. Their application handles OLTP workloads, while the analytics team runs complex queries on the same database. The company wants to minimize management efforts by using managed services. Which solution meets these requirements with the LEAST operational overhead?
Migrate to Amazon RDS for SQL Server. Use read replicas for analytics.
Migrate to SQL Server on EC2. Use transactional replication for analytics.
Migrate to Amazon DocumentDB. Use global clusters for analytics.
Migrate to Amazon Redshift. Use materialized views for analytics.
Explanation
Answer A is correct because:
- Amazon RDS is a managed service, reducing administrative tasks like patching, backups, and scaling.
- Read replicas allow the analytics team to run complex queries on a replicated copy, preventing performance impacts on the OLTP workload.
Other options are incorrect because:
- B (EC2): Requires manual management of SQL Server on EC2, increasing operational overhead.
- C (DocumentDB): A NoSQL database incompatible with SQL Server, requiring application redesign.
- D (Redshift): A data warehouse unsuitable for OLTP workloads.
Key Points: Use managed services (RDS) for minimal overhead; read replicas separate OLTP and analytics workloads.
Answer
The correct answer is: A