Microsoft Designing and Implementing Cloud Data Platform Solutions - 70-473 FREE EXAM DUMPS QUESTIONS & ANSWERS

You plan to create a data warehouse in Microsoft Azure for development purposes.
The data warehouse must not exceed 10 terabytes (TB) in size. You must minimize costs for the environment.
You need to create the data warehouse.
Which Transact-SQL statement should you run?

You need to configure a runbook to execute when a Microsoft Azure SQL database uses more than 80 percent of the Database Throughput Unit (DTU) resources.
What should you configure in the runbook?

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.
What should you include in the recommendation?

You plan to migrate a 150-GB on-premises database to a Microsoft Azure virtual machine.
The domains in your network are untrusted. The network has 1.5 Mbps of available bandwidth. You need to migrate the data to the Azure virtual machine as quickly as possible.
What should you use?

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.

You have a Microsoft SQL Server instance that hosts a database named DB1.
You plan to back up DB1 to Microsoft Azure Blob storage. You need to configure the required access to Azure blob storage for the planned backup.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You implement Microsoft Azure ExpressRoute.
You need to ensure that if the ExpressRoute connection is unavailable, you can manage the resources in Azure over a secure connection.
Which two actions should perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

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 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 Intelligent Insights to identify the slow queries and an Azure event hub to archive all the database events.
Does this meet the goal?

You are planning the migration of SQL01 to an Azure virtual machine.
You need to identify which service tier to use for the virtual machine. The solution must meet the business goals and the technical requirements.
Which virtual machine service tier should you identify?

You have a Microsoft Azure SQL database named Database1.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.

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 tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the Add-AzureRmSqlDatabase cmdlet from PowerShell.
Does this meet the goal?