What should the company do to meet these data storage requirements with the LEAST amount of operational overhead?
Use Amazon EC2 in multiple Regions to host separate databases
Use Amazon RDS cross-Region replication
Use Amazon DynamoDB global tables
Use AWS Database Migration Service (AWS DMS)
Explanations:
Using Amazon EC2 in multiple Regions to host separate databases would require significant operational overhead for managing instances, backups, scaling, and maintenance across Regions. This approach complicates data management and availability.
Amazon RDS cross-Region replication allows for read replicas in different Regions, but it still requires operational management of RDS instances and does not provide a fully managed global database solution. This could lead to increased complexity and overhead.
Amazon DynamoDB global tables are specifically designed for global applications, providing multi-Region, fully managed database solutions with automatic replication. This setup minimizes operational overhead while ensuring low-latency access to data for users worldwide.
AWS Database Migration Service (AWS DMS) is primarily used for migrating databases and does not provide a solution for ongoing data storage and accessibility across multiple Regions. It would not meet the requirement for real-time data access in a global context.