What should you do?

Topic 3, Deploy and migrate applications

A company has an on-premises Microsoft SQL Server 2014 environment. The company has a main office in Seattle, and remote offices in Amsterdam and Tokyo. You plan to deploy a Microsoft Azure SQL Database instance to support a new application. You expect to have 100 users from each office.

In the past, users at remote sites reported issues when they used applications hosted at the Seattle office.

You need to optimize performance for users running reports while minimizing costs.

What should you do?
A . Implement an elastic pool.
B . Implement a standard database with readable secondaries in Asia and Europe, and then migrate the application.
C . Implement replication from an on-premises SQL Server database to the Azure SQL Database instance.
D . Deploy a database from the Premium service tier.

View Answer

Answer: B

Explanation:

References:https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-transact-sql#add-secondary-database