Q47 — AWS SAA-C03 Ch.11

Question 47 of 100 | ← Chapter 11

Q747. 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?

Correct Answer: A. Migrate to Amazon RDS for Microsoft SOL Server. Use read replicas for reporting purposes

Explanation

To meet the requirements of reducing operational overhead and migrating the on-premises Microsoft SQL Server Enterprise edition database to AWS, while also supporting transaction processing and analytical reporting, the solution that would require the least operational overhead is:A. Migrate to Amazon RDS for Microsoft SQL Server. Use read replicas for reporting purposes.Option A, migrating to Amazon RDS for Microsoft SQL Server and using read replicas for reporting purposes, is the solution that requires the least operational overhead. Amazon RDS is a managed database service that automates administrative tasks such as patching, backups, and software updates. By migrating to Amazon RDS for Microsoft SQL Server, the company can offload the operational overhead of managing the database infrastructure to AWS. Amazon RDS provides read replicas that can be used for reporting purposes, allowing the data analysis team to run analytical reports without impacting the performance of the production database. The read replicas are automatically updated asynchronously, reducing the operational complexity of managing separate reporting instances.Option B, migrating to Microsoft SQL Server on Amazon EC2 and using Always On read replicas for reporting purposes, involves managing and maintaining the SQL Server instances on EC2. While Always On read replicas can provide high availability and scalability, they require additional operational effort to set up, configure, and manage the SQL Server instances on EC2.Option C, migrating to Amazon DynamoDB, is not suitable for this scenario. DynamoDB is a NoSQL database service that does not support SQL queries and does not have built-in support for running analytical reports. It would require significant effort to redesign the application and migrate the data to DynamoDB, which may not be feasible depending on the requirements of the existing application.Option D, migrating to Amazon Aurora MySQL and using Aurora read replicas for reporting purposes, is not the best choice for this scenario. While Aurora is a highly scalable and managed database service, it is based on MySQL and may not provide the necessary compatibility with the existing Microsoft SQL Server database. Additionally, Aurora read replicas are primarily designed for scaling read workloads rather than running analytical reports.Therefore, the solution that meets the requirements of reducing operational overhead, migrating the Microsoft SQL Server database to AWS, and supporting transaction processing and analytical reporting with the least operational overhead is A: Migrate to Amazon RDS for Microsoft SQL Server. Use read replicas for reporting purposes.