2017 Feb. New Microsoft Exam 70-473 Dumps (PDF & VCE) Released in wwww.Braindump2go.com Today!

1.|2017 NEW 70-473 Exam Dumps (PDF & VCE)  51Q&As Download:
http://www.braindump2go.com/70-473.html

2.|2017 NEW 70-473 Exam Questions & Answers:
https://1drv.ms/f/s!AvI7wzKf6QBjgj9HEHLj9WfLoVPZ

QUESTION 38
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.

A.    a Microsoft Azure SQL data warehouse
B.    a Microsoft SQL Server virtual machine
C.    a Microsoft Azure HDInsight cluster
D.    a Microsoft Azure SQL database

Answer: A
Explanation:
https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-what-is/

QUESTION 39
You have Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application. Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.

A.    the Job Activity Monitor
B.    Database Engine Tuning Advisor
C.    dynamic management views
D.    SQL Server Extended Events
E.    SQL metrics in Azure Diagnostics for the virtual machine

Answer: CD

QUESTION 40
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 you use?

A.    Update-AzureVM
B.    Stop-AzureVM
C.    Suspend-VM
D.    Stop-VM

Answer: B
Explanation:
https://msdn.microsoft.com/en-us/library/azure/dn495269.aspx

QUESTION 41
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.

A.    Configure the Audit policy change policy.
B.    Assign the Generate security audits user right.
C.    Configure the Audit object access policy.
D.    Assign the Log on as a service user right.
E.    Configure the Audit the access of global system objects policy.

Answer: BC
Explanation:
https://msdn.microsoft.com/en-us/library/cc645889.aspx

QUESTION 42
Drag and Drop Question
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 to drag the split bar between panes or scroll to view content.
 
Answer:
 
QUESTION 43
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?

A.    Index Tuning Wizard
B.    Database Engine Tuning Advisor
C.    Azure Throughput Analyzer
D.    Azure SQL Database Index Advisor

Answer: D


!!!RECOMMEND!!!

1.|2017 NEW 70-473 Exam Dumps (PDF & VCE) 51Q&As Download:
http://www.braindump2go.com/70-473.html

2.|2017 NEW 70-473 Study Guide Video:
https://youtu.be/tICdA_6YJPs