You are designing the database for a new application. The application will have 7,500 users located in New York and 2,500 users located in Paris. Users of the application will load large amounts of da

Deploying Microsoft Azure virtual machines with AlwaysOn Availability Groups allows for creating regional primary replicas, enabling users to write data to a database instance in their nearest region, which significantly minimizes data loading latency.

Merge Replication, while allowing local updates, can be complex for large-scale multi-regional cloud deployments and the option is incomplete for covering both user groups with local instances.

This option only specifies a primary database in the West Europe region, which would not minimize latency for the 7,500 users located in New York.

Peer-to-Peer Replication supports multiple writable nodes and could minimize latency but the option is incomplete, not specifying how it would provide a complete solution for both regions.

Utilizing Microsoft Azure SQL databases with separate primary databases deployed in the East US region for New York users and the West Europe region for Paris users ensures that each user group can write data to their geographically closest database, thus minimizing latency.