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 590 discussion

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

A company migrated a MySQL database from the company's on-premises data center to an Amazon RDS for MySQL DB instance. The company sized the RDS DB instance to meet the company's average daily workload. Once a month, the database performs slowly when the company runs queries for a report. The company wants to have the ability to run reports and maintain the performance of the daily workloads.

Which solution will meet these requirements?

  • A. Create a read replica of the database. Direct the queries to the read replica.
  • B. Create a backup of the database. Restore the backup to another DB instance. Direct the queries to the new database.
  • C. Export the data to Amazon S3. Use Amazon Athena to query the S3 bucket.
  • D. Resize the DB instance to accommodate the additional workload.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by TiagueteVital at Sept. 3, 2023, 12:11 a.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
TariqKipkemei
8 months, 4 weeks ago
Selected Answer: A
queries for reports = read replica
upvoted 3 times
...
Guru4Cloud
11 months, 1 week ago
Selected Answer: A
Create a read replica of the database. Direct the queries to the read replica.
upvoted 4 times
...
Eminenza22
11 months, 2 weeks ago
Selected Answer: A
This is the most cost-effective solution because it does not require any additional AWS services. A read replica is a copy of a database that is synchronized with the primary database. You can direct the queries for the report to the read replica, which will not affect the performance of the daily workloads
upvoted 4 times
...
TiagueteVital
11 months, 3 weeks ago
Selected Answer: A
Clearly the right choice, with a read replica all the queries needed for a report are done in the replica, leaving the primary on best perfomance for write
upvoted 3 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