Posted on

Microsoft MCSE 70-473 Free Online Test

Currently, Microsoft MCSE 70-473 exam online test only provide 20 questions. Answer one question correctly, you can get 5 points. The content of these questions are the latest 70-473 exam questions. Please feel free to test your skill level.

If you have some opinions or suggestions about our 70-473 exam online test, please leave your message, we will improve it step by step.

Now, begin to test:

1. 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?

 
 
 
 

2. 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.

 
 
 
 
 

3. 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 the same table structure. You need to reduce the amount of time it takes to complete the reports. What should you use?

 
 
 
 

4. A customer plans to monitor the performance of a Microsoft Azure SQL Server database. You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DIU) percentage Which three metrics should you identify? Each correct answer presents part of the solution.

 
 
 
 
 
 

5. You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections. You need to identify whether he performance issues are related to the connection pooling. Which dynamic management view should you query?

 
 
 
 

6. You have Microsoft SQL Server 2014 installed on 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.

 
 
 
 
 

7. You have several SQL Server instances on Microsoft Azure machines. Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to 30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the virtual machines. You need to be notified automatically when the performance issue occurs. You want to achieve this goal by using the minimum amount of administrative effort.What should you configure?

 
 
 
 

8. 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?

 
 
 
 

9. You have a report that runs against a Microsoft Azure SQL database. The report takes more time to return results than expected. You add an index to a table in the database. You need to identify whether adding the index improves performance issue. What should you use?

 
 
 
 

10. 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?

 
 
 
 

11. You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template. You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual machine. The web app and the virtual machine will be on the same Azure virtual network. You need to ensure that the web app can access the SQL Server database.

 
 
 
 
 

12. 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 Windows Security log. Which two action should you perform? Each correct answer presents part of the solution.

 
 
 
 
 

13. You 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?

 
 
 
 

14. 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.

 
 
 
 
 

15. 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.

 
 
 
 
 
 

16. You are evaluating whether to replace CRM-B with an Azure virtual machine. You need to identify the required virtual machine service tier to replace CRM-B. The solution must meet the following requirements: Ensure that the database is stored in premium storage. Meet the business requirements. Which virtual machine service tier should you identify?

 
 
 
 

17. You are evaluating moving the data from WebData1 to an Azure SQL database. You need to recommend a solution to generate the consolidated report for billing. The solution must meet the business requirements.

 
 
 
 

18. You are planning the consolidation of the databases from Host1. You need to identify which methods to use to back up the data after the consolidation completes. What are two possible methods that achieve this goal? Each correct answer presents a complete solution.

 
 
 
 

19. You need to recommend a disaster recovery solution for the CRM application that meets the business requirements. What should you recommend?

 
 
 
 

20. You are planning the consolidation of the databases from Host1. You need to identify which methods to use to back up the data after the consolidation completes. What are two possible methods that achieve this goal? Each correct answer presents a complete solution

 
 
 
 

Question 1 of 20