PrepAway - Latest Free Exam Questions & Answers

You need to optimize performance for users running repo…

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?

PrepAway - Latest Free Exam Questions & Answers

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.

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


Leave a Reply