AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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?
Other
Community
UAnonymous
A
Create a read replica. Move reporting queries to the read replica.
B
Create a read replica. Distribute the ordering application to the primary DB instance and the read replica.
C
Migrate the ordering application to Amazon DynamoDB with on-demand capacity.
D
Schedule the reporting queries for non-peak hours.
Explanation:
Explanation
Correct Answer: A
Why Option A is correct:
- Read replicas in Amazon RDS allow you to offload read traffic from the primary database instance.
- By moving reporting queries (which are read-only) to a read replica, you separate the read workload from the write workload.
- This prevents the long-running reporting queries from interfering with the order processing (write operations) on the primary instance.
- Employees can still perform their reporting queries during business hours without causing timeouts in the ordering application.
- This solution maintains the existing architecture while solving the performance issue.
Why Option B is incorrect:
- Distributing the ordering application between primary and read replica is not appropriate because:
- Read replicas have asynchronous replication, which means there might be replication lag
- Ordering applications typically require strong consistency for write operations
- Splitting the application could lead to data consistency issues
Why Option C is incorrect:
- Migrating to DynamoDB is a major architectural change that:
- Would require significant application rework
- Might not be suitable for relational data structures
- Doesn't address the immediate problem of separating read and write workloads
- Is an over-engineered solution for this specific issue
Why Option D is incorrect:
- Scheduling queries for non-peak hours:
- Doesn't meet the requirement that employees need to perform queries during business hours
- Limits business flexibility
- Doesn't solve the underlying architectural issue of mixed read/write workloads
Key AWS Concepts:
- Amazon RDS Read Replicas: Provide read scalability by creating copies of your primary database that can serve read traffic
- Read/Write Separation: A common pattern where read-heavy workloads are directed to read replicas while write operations go to the primary instance
- Performance Isolation: Separating different types of workloads to prevent interference
Best Practice: Using read replicas for reporting and analytics workloads is a standard AWS best practice to maintain application performance while supporting business intelligence needs.
Comments
Loading comments...