A company is running a batch analysis every hour on their main transactional DB. running on an
RDS MySQL instance to populate their central Data Warehouse running on Redshift During the
execution of the batch their transactional applications are very slow.
When the batch completes they need to update the top management dashboard with the new
data The dashboard is produced by another system running on-premises that is currently started
when a manually-sent email notifies that an update is required The on-premises system cannot
be modified because is managed by another team.
How would you optimize this scenario to solve performance issues and automate the process as
much as possible?
A.
Replace RDS with Redshift for the batch analysis and SNS to notify the on-premises system to
update the dashboard
B.
Replace ROS with Redsnift for the oaten analysis and SQS to send a message to the onpremises system to update the dashboard
C.
Create an RDS Read Replica for the batch analysis and SNS to notify me on-premises system to
update the dashboard
D.
Create an RDS Read Replica for the batch analysis and SQS to send a message to the onpremises system to update the dashboard.
Explanation:
If you want to prevent your reporting and analytic processing from interfering with the
performance of your OLTP workload.”
If I understand the above statement correctly, they are saying to separate reporting and analytic
processing from OLTP. In other word, use RedShift for reporting and analytic processing and use
RDS for OLTP workload.