Exam 70-765 topic 3 question 1 discussion

Actual exam question from Microsoft's 70-765

Question #: 1
Topic #: 3

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.

Show Suggested Answer

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

by KC at June 14, 2020, 9:06 a.m.

Comments

Submit Cancel

KC

4 years, 11 months ago

How to set it up: http://www.nikoport.com/2018/11/01/azure-sql-db-readable-secondary/

upvoted 3 times

...