How do you build the database architecture in order to …

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 US.
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?

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 US.
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?

A.
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.

B.
For each regional deployment, use RDS MySQL with a master in the region and send hourly RDS
snapshots to the HQ region.

C.
Use Direct Connect to connect all regional MySQL deployments to the HQ region and reduce
network latency for the batch process.

D.
For each regional deployment, use RDS MySQL with a master in the region and a read replica In
the HQ region.

E.
For each regional deployment, use MySQL on EC2 with a master in the region and send hourly
EBS snapshots to the HQ region.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


anusha

anusha

Agree Answer is A because Mysql RDS supports read replica in different regions.

John

John

correct answer is D:
For each regional deployment, use RDS MySQL with a master in the region and a read replica In
the HQ region.