Drag and drop
You need to recommend a solution to implement high availability for Listings database.
Which three actins should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You company has two offices located in London and New York.
The London office has a public IP of 184.108.40.206 and a private IP subnet of 192.168.4.0/24. The New
York office has a public IP of 220.127.116.11 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?
A. EXECUTE sp_set_database_firewall_rule N’New York, ‘18.104.22.168’, ‘255.255’
B. EXECUTE sp_set_database_firewall_rule N’New York, ‘192.168.8.0’, ‘192.168.8.255’;
C. EXECUTE sp_set_database_firewall_rule N’New York, ‘192.168.8.0’, ‘255.255.255.0’;
D. EXECUTE sp_set_database_firewall_rule N’New York, ‘22.214.171.124’, ‘126.96.36.199’;
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned by using the classic deployment model and is on the Standard GS5 service tier.
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should use?
You plan to implement row-level security for the CWDB database.
You create the fn_limitusers function under the restriction schema.
You need to create the Policy.
How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element may be used once, more than once, or not at all. You may need to drag the splitbar between panes or scroll to view content.
Drag and drop
You need to configure auditing to meet the technical requirements.
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.
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the Standard D3 service tier.
All of the data files for the databases on the virtual machine are located on a single volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of PAGEIOLATCH_SH waits associated to the tempdb data files.
You need to resolve the performance issues.
What should you do?
A. Move the tempdb data files to drive D
B. Move the tempdb data files to drive C
C. Change the service tier of the virtual machine to Standard D12.
D. Change the service tier of the virtual machine to Standard DS3.
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?
A. Move the Azure SQL database from the West US region to the East Asia region.
B. Implement Azure ExpressRoute for the subscription.
C. Configure a readable geo-replica in the East Asia region.
D. Configure pagination for the report.
You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in both Microsoft Azure and on-premises.
If the network fails, you need to ensure that users can authenticate and connect to the resources available in Azure.
Which two server role should you deploy to Azure? Each correct answer presents part of the solution.
A. Active Directory Federation Services
B. Active Directory Certificate Services
C. DHCP Server
D. Active Directory Domain Services
E. DNS Server
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:
. Access the database remotely.
. Manage the server remotely by using Windows PowerShell.
. Manage the server remotely by using Remote Desktop.
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 drag the split bar between panes or scroll to view content.
Drag and 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.