AWS Certified Solutions Architect – Professional — Question 68

Your company has HQ in Tokyo and branch offices all over the world and is using a logistics software with a multi-regional deployment on AWS in Japan, Europe and USA. The logistic software has a 3-tier architecture and currently uses MySQL 5.6 for data persistence. Each region has deployed its own database.
In the HQ region you run an hourly batch process reading data from every region to compute cross-regional reports that are sent by email to all offices this batch process must be completed as fast as possible to quickly optimize logistics.
How do you build the database architecture in order to meet the requirements?

Answer options

• A. For each regional deployment, use RDS MySQL with a master in the region and a read replica in the HQ region
• B. For each regional deployment, use MySQL on EC2 with a master in the region and send hourly EBS snapshots to the HQ region
• C. For each regional deployment, use RDS MySQL with a master in the region and send hourly RDS snapshots to the HQ region
• D. For each regional deployment, use MySQL on EC2 with a master in the region and use S3 to copy data files hourly to the HQ region
• E. Use Direct Connect to connect all regional MySQL deployments to the HQ region and reduce network latency for the batch process

Correct answer: A

Explanation

Option A is correct because using RDS MySQL with a master in each region and a read replica in the HQ region allows for efficient data retrieval, helping to quickly generate reports. The other options either involve slower methods of data transfer, such as EBS snapshots or S3 file copies, which do not meet the performance requirements necessary for timely logistics optimization.