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

A is correct answer. This was in my exam

The best solution to address the timeouts and eliminate the impact of long-running reporting queries without disrupting order processing is:A

Reporting queries will point to read replica. Application will still point to primary db for write / read operations.

The correct answer to this question is A: Create a read replica. Move reporting queries to the read replica. This solution is designed to alleviate the load on the primary database used by the ordering application. By offloading the reporting queries to a read replica, the primary instance is freed up to handle operational transactions like order processing without contention from the resource-intensive reporting queries. This should effectively reduce or eliminate the timeouts currently experienced during order processing.

create the replica and all the report queries get data from that read replica.

B incorrect because ordering application needs to write data to the DB.

A. By moving the reporting queries to the read replica, the primary DB instance used for order processing is not affected by the long-running reporting queries. This helps eliminate timeouts during order processing while allowing employees to perform their queries without impacting the application's performance. B. While this can provide some level of load distribution, it does not specifically address the issue of timeouts caused by reporting queries during order processing. C. While DynamoDB offers scalability and performance benefits, it may require significant changes to the application's data model and querying approach. D. While this approach can help alleviate the impact on order processing, it does not address the requirement of eliminating timeouts without preventing employees from performing queries.

"A" is correct because is does not cause problems in the primary DB

reports = read replica

A is the correct answer. Creating an RDS MySQL read replica will allow the reporting queries to be isolated and run without affecting performance of the primary ordering application. Read replicas allow read-only workloads to be scaled out while eliminating contention with the primary write workload.

Question keyword "regular business hours" made D is incorrect. C migrate to Amazon DynamoDB (No-SQL) is meaningless, remove C. Answer B, create a "read replica", it is ok, but "ordering application pointed to read replica" is incorrect. A is correct answer. Easy question.

A sounds right

Using the primary instance continues with the problem

A. By moving the reporting queries to the read replica, the primary DB instance used for order processing is not affected by the long-running reporting queries. This helps eliminate timeouts during order processing while allowing employees to perform their queries without impacting the application's performance. B. While this can provide some level of load distribution, it does not specifically address the issue of timeouts caused by reporting queries during order processing. C. While DynamoDB offers scalability and performance benefits, it may require significant changes to the application's data model and querying approach. D. While this approach can help alleviate the impact on order processing, it does not address the requirement of eliminating timeouts without preventing employees from performing queries.

correct

A is correct.

Creating a read replica allows the company to offload the reporting queries to a separate database instance, reducing the load on the primary database used for order processing. By moving the reporting queries to the read replica, the ordering application running on the primary DB instance can continue to process orders without timeouts due to the long-running reporting queries. Option B is not a good solution because distributing the ordering application to the primary DB instance and the read replica does not address the issue of long-running reporting queries causing timeouts during order processing.