Free Microsoft 070-473 Exam Dumps Questions & Answers

You are provisioning a virtual machine in Microsoft Azure to host a Microsoft SQL Server database named DB1.
The tempdb database on the SQL server is not expected to grow to more than 20 GB during the next five years.
You add a 1-TB disk to the virtual machine and configure the disk as drive F.
The disk is not configured for read or write caching.
You need to reduce the amount of time required to read data from DB1 and tempdb.
On which drive should you place each database? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, white others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are managing a Microsoft Azure SQL database.
Users of the database report that queries to the database are slow to return results.
You need to recommend a solution to identify the most likely cause of the slow queries and to archive all database events for at least 90 days.
Solution: You deploy Application Insights to identify the slow queries and Query Store to archive all the database events.
Does this meet the goal?

• A.  Yes
• B.  No

A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
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.  Deploy Database to a Microsoft Azure VM
• B.  Deploy Database to a Microsoft Azure SQL Database
• C.  Copy Database
• D.  Extract Data-tier Application

Your company has a data center located in Europe. The company has a 10 Mbps connection to the Internet that is 80 percent saturated on average. You have an on-premises Microsoft SQL Server database that is 6 TB. You plan to migrate the database the database to Microsoft Azure.
You need to recommend a solution to migrate the database to Azure. The solution must meet the following requirements:
- Ensure that the database is hosted in the West US region.
- Minimize any changes to the current network infrastructure.
- Minimize the amount of time required to migrate the database.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.

• A.  Use the BACKUP to URL option and use Azure Blob storage as the location.
• B.  Use a database DACPAC file to export the database.
• C.  Use a database BACPAC file to export the database.
• D.  Use the Azure Import/Export service.
• E.  Configure Azure ExpressRoute and copy the data files to a virtual machine.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result these questions will not appear in the review screen.
You have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the database resource in Azure.
Does this meet the goal?

• A.  Yes
• B.  No