Your business is building a new application that will store its entire customer database on a RDS MySQL database, and will have various applications and users that will query that data for different purposes. Large analytics jobs on the database are likely to cause other applications to not be able to get the query results they need to, before time out. Also, as your data grows, these analytics jobs will start to take more time, increasing the negative effect on the other applications. How do you solve the contention issues between these different workloads on the same data?
A) Enable Multi-AZ mode on the RDS instance
B) Use ElastiCache to offload the analytics job data
C) Create RDS Read-Replicas for the analytics work
D) Run the RDS instance on the largest size possible

Question

Quizplus · Accepted Answer

Creating RDS Read-Replicas allows you to offload read-heavy workloads like analytics from the primary database, reducing contention and improving performance for other applications.

Your Business Is Building a New Application That Will Store