A Company Is Running a Batch Analysis Every Hour on Their

question 614

Multiple Choice

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 RDS with Redshift for the oaten analysis and SQS to send a message to the on-premises 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 on-premises system to update the dashboard.

---

Definitions:

HR Planning

The process of identifying and addressing the human resources needs of an organization to achieve its business goals.

Strategic Plan

A systematic process of envisioning a desired future and translating this vision into broadly defined goals or objectives and a sequence of steps to achieve them.

Attrition

A natural departure of employees from organizations through quits, retirements, and deaths.

Values-Based Hiring

Values-based hiring is a recruitment strategy that focuses on aligning a candidate's personal values with the organization's values to ensure cultural fit and shared goals.