ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 650 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03
Question #: 650
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

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 SOL 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
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by potomac at Nov. 7, 2023, 3:47 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
BillaRanga
Highly Voted 7 months, 2 weeks ago
Selected Answer: A
B - Not the LEAST operational Overhead. C - It is No-Sql - Not compatible with SQL server which is SQL D - MS Sql Server to MySQL may miss out some SQL Server functionalities. A - Read replicas for RDS is easy to create and also it is Asynchronous which should not be a problem for the analytics teams as they can bear 2-3 minutes delay
upvoted 7 times
...
superalaga
Highly Voted 9 months, 2 weeks ago
Selected Answer: A
You can migrate with both A&B but option A is LEAST operational overhead/ A: https://aws.amazon.com/tutorials/move-to-managed/migrate-sql-server-to-amazon-rds/ B: https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-a-microsoft-sql-server-database-to-aurora-mysql-by-using-aws-dms-and-aws-sct.html
upvoted 6 times
...
Firdous586
Most Recent 8 months, 2 weeks ago
A is the correct answer since RDS supports OLAP And aurora OLTP
upvoted 5 times
...
TariqKipkemei
9 months, 4 weeks ago
Selected Answer: A
Only Amazon RDS allows the creation of readable standby DB instances.
upvoted 4 times
...
potomac
10 months, 3 weeks ago
Selected Answer: A
A is the only choice
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago