Microsoft 070-473 Actual Free Exam Questions & Community Discussion

Your environment contains a Microsoft Azure virtual machine and an Azure SQL database. The virtual machine has Microsoft SQL Server installed and contains several applications. You need to recommend a solution to migrate one of the applications to the Azure SQL database. The solution must minimize downtime.
Which solution should you recommend?

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 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 the performance issue.
What should you use?

What should you use to schedule the nightly jobs to meet the technical requirements?

You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?

You need to recommend a solution to meet the reporting requirements of App3.
What should you include in the recommendation?

You need to implement a solution to meet the technical requirements for the encryption of the data in Appl.
Which two features should you enable? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point

You have a server named SQL1 that has Microsoft SQL Server 2016 installed. SQL1 contains a database named DB1.
You need to ensure that a user named User1 can query dynamic management views to monitor DB1. The solution must minimize the number of permissions assigned to User1.
You create a login for User1.
Which permission should you grant to User1?