SAA-C03 · Question #304
A company has an ordering application that stores customer information in Amazon RDS for MySQL. During regular business hours, employees run one-time queries for reporting purposes. Timeouts are occur
The correct answer is A. Create a read replica. Move reporting queries to the read replica.. Amazon RDS for MySQL supports the creation of read replicas, which are read-only copies of the primary database instance. By offloading read-heavy operations, such as reporting queries, to a Performance Improvement: The primary DB instance is relieved from the additional load, re
Question
A company has an ordering application that stores customer information in Amazon RDS for MySQL. During regular business hours, employees run one-time queries for reporting purposes. Timeouts are occurring during order processing because the reporting queries are taking a long time to run. The company needs to eliminate the timeouts without preventing employees from performing queries. What should a solutions architect do to meet these requirements?
Options
- ACreate a read replica. Move reporting queries to the read replica.
- BCreate a read replica. Distribute the ordering application to the primary DB instance and the read
- CMigrate the ordering application to Amazon DynamoDB with on-demand capacity.
- DSchedule the reporting queries for non-peak hours.
How the community answered
(38 responses)- A79% (30)
- B5% (2)
- C13% (5)
- D3% (1)
Explanation
Amazon RDS for MySQL supports the creation of read replicas, which are read-only copies of the primary database instance. By offloading read-heavy operations, such as reporting queries, to a Performance Improvement: The primary DB instance is relieved from the additional load, reducing the likelihood of timeouts during order processing. Data Consistency: Read replicas use asynchronous replication, ensuring that they have up-to- date data for accurate reporting. Scalability: Multiple read replicas can be created to handle increased read traffic. This approach allows employees to continue running necessary reports without impacting the performance of the ordering application.
Community Discussion
No community discussion yet for this question.