What should you use?
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…
70-473
What should you do?
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…
Which three actions should you perform?
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.…
Which two actions should you perform?
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…
Which command should you execute?
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…
Which two components should you configure?
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 A. the Column Master…
Which three actions should you perform?
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…
What should you enable?
You need to ensure that the performance statistics for the research department are collected. What should you enable? A. Query Performance Insight B. Scale and Configuration C. Dynamic Data Masking D. Index advisor
What should you identify?
You are evaluating the use of active geo-replication for one of the research department databases. You need to identify which service tier to use for the database. The solution must meet the department requirements and the business requirements What should…
Which task should you instruct the leaders to use from SQL Server Management Studio?
You need to tell the research project leaders how to migrate their databases. Which task should you instruct the leaders to use from SQL Server Management Studio? A. Extract Data-tier Application B. Deploy Database to a Microsoft Azure VM C.…