A Company's Production Application Runs Online Transaction Processing (OLTP) Transactions

question 337

Multiple Choice

A company's production application runs online transaction processing (OLTP) transactions on an Amazon RDS MySQL DB instance. The company is launching a new reporting tool that will access the same data. The reporting tool must be highly available and not impact the performance of the production application. How can this be achieved?

• A) Create hourly snapshots of the production RDS DB instance.
• B) Create a Multi-AZ RDS Read Replica of the production RDS DB instance.
• C) Create multiple RDS Read Replicas of the production RDS DB instance. Place the Read Replicas in an Auto Scaling group.
• D) Create a Single-AZ RDS Read Replica of the production RDS DB instance. Create a second Single-AZ RDS Read Replica from the replica.

---

Definitions:

Vibrations

Oscillations or rapid motions back and forth or up and down, often referenced in physics, engineering, and environmental contexts.

Rail System

A network of tracks, stations, and supporting infrastructure for trains, providing transportation for passengers and freight.

Pollution Control Technology

Systems, devices, or practices designed to reduce, eliminate, or manage pollutants emanating from human activity to protect the environment.

Chemical Waste

Hazardous substances produced as byproducts of manufacturing processes, laboratory experiments, or other industrial activities, requiring careful disposal to prevent environmental damage.