DRAG DROP

You need to identify the appropriate data architecture for App1. The solution must support the planned changes.

Which storage platforms should you identify for App1? To answer, drag the appropriate storage platforms to the correct data types. Each storage platform may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content

NOTE: Each correct selection is worth one point

Reveal Solution Hide Solution

Correct Answer:

You need to implement a solution to meet the technical requirements for the encryption of the data in Appl.

Which two features should you enable? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point

Reveal Solution Hide Solution

Which database platform should App3 use?

Reveal Solution Hide Solution

You need to prepare the Azure environment for the planned migration of DB1. The solution must meet the requirements of the finance department.

Which two tasks should you perform in Azure? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

DRAG DROP

You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database.

You need to configure firewall rules to meet the following requirements:

Which Azure endpoint ports should you open? To answer, drag the appropriate ports to the correct types of access. Each port may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

You have a Microsoft SQL Server instance on a Microsoft Azure virtual machine.

The members of an Active Directory group named HelpDesk can log in to the SQL Server instance. You need to ensure that the members of HelpDesk can query dynamic management views and

gather performance metrics from the SQL Server instance.

Which three actions should you perform? Each correct answer presents part of the solution.

Reveal Solution Hide Solution

You have a Microsoft Azure SQL database.

You need to ensure that you can use the Always Encrypted feature for the database.

Which two components should you configure? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Your company has two offices 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 Azure SQL database. Currently, only the users in the London office use the

database. You plan to provide the users in the New York office with access to the database. You need to ensure that the New York office users can access the database.

Which command should you execute?

Reveal Solution Hide Solution

You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine. You need to ensure that all SQL Server audits are written to the Windows Security log.

Which two actions should you perform? Each correct answer presents part of the solution.

Reveal Solution Hide Solution

DRAG DROP

You hire a new employee to assist in the management of a Microsoft Azure SQL database.

You need to ensure that the employee can query dynamic management views.

Which three 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.

Reveal Solution Hide Solution