ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 565 - SAA-C03 discussion

Report
Export

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?

A.
Migrate to Amazon RDS for Microsoft SQL Server. Use read replicas for reporting purposes.
Answers
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.
Answers
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.
Answers
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.
Answers
D.
Migrate to Amazon Aurora MySQL. Use Aurora read replicas for reporting purposes.
Suggested answer: A

Explanation:

Amazon RDS for Microsoft SQL Server is a fully managed service that offers SQL Server 2014, 2016, 2017, and 2019 editions while offloading database administration tasks such as backups, patching, and scaling. Amazon RDS supports read replicas, which are read-only copies of the primary database that can be used for reporting purposes without affecting the performance of the online application. This solution will meet the requirements with the least operational overhead, as it does not require any code changes or manual intervention.

1provides an overview of Amazon RDS for Microsoft SQL Server and its benefits.

2 explains how to create and use read replicas with Amazon RDS.

asked 16/09/2024
Billy Raymond
31 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first