Your company has two offices. The offices are located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York
office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft SQL Server database that is hosted on a Microsoft Azure virtual machine. Currently, only
the users in the London office use the database.
You need to create a new firewall rule to provide the users in the New York office with access to the database.
The solution must protect the database from being accessed by users on the public Internet.
What should you do?

You have an organizational data mart that contains 3.5 TB of uncompressed data.
The size of the data is expected to grow 2 ТВ annually. Reporting is performed only during business hours.
You plan to move the data to the cloud.You need to design a cloud architecture for the data mart. The solution must minimize costs and administrative
overhead.
What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the
BEST answer.

DRAG DROP
You have four Microsoft Azure SQL databases.
You need to configure cross-database queries.
Which four statements should you use in sequence? To answer, move the appropriate statements from the list
of statements to the answer area and arrange them in the correct order.
Select and Place:

You have a Microsoft Azure SQL data warehouse.
During peak usage, you discover that the data warehouse fails to meet performance expectations.
You need to provide additional resources to the data warehouse.
What should you do?

You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in both
Microsoft Azure and on-premises.
It the network fails, you need to ensure that users can authenticate and connect to the resources available in
Azure.
Which two server roles should you deploy to Azure? Each correct answer presents part of the solution.

You have an on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group.
You are planning a backup solution for the database. Backups will run on a secondary replica.
You need to create a backup procedure for the database. The solution must ensure that the backups are stored
on-premises and in Microsoft Azure Blob storage.
Which two actions should you perform? Each correct answer presents part of the solution.

DRAG DROP
You have four Microsoft Azure SQL databases located on the same database server.
You need to configure the databases to be in an elastic database pool.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders
you select.
Select and Place:

You have a Microsoft Azure SQL database. The database is hosted in the West US region and uses the
Premium service tier. Users of the database are located in Los Angeles, New York, and Singapore.
The users in Singapore report that when they run reports against the database, the reports take a long time to
complete. The reports contain thousands of rows.
You need to recommend a solution to resolve the performance issue. The solution must maintain the
performance for the other users. What should you include in the recommendation?

You plan to implement a Microsoft Azure SQL database.
You need to create and manage the new database on a new server.
Which three cmdlets should you use? Each correct answer presents part of the solution.

You have a Microsoft Azure SQL database that is used for reporting.
You discover that some reports complete more quickly than other reports, even though the reports retrieve
approximately the same amount of data and use queries that have the same table structure.
You need to reduce the amount of time it takes to complete the reports.
What should you use?