Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
TariqKipkemei
12 months ago
Selected Answer: A
queries for reports = read replica
upvoted 2 times
...
Guru4Cloud
1 year, 2 months ago
Selected Answer: A
Create a read replica of the database. Direct the queries to the read replica.
upvoted 3 times
...
Eminenza22
1 year, 2 months 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 3 times
...
TiagueteVital
1 year, 2 months 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 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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