Microsoft - Limited Time Discount Offer - Ends In 1d 00h 00m 00s Coupon code: Y2430OFF
  1. Home
  2. Microsoft
  3. DP-300 Dumps
  4. Free DP-300 Questions

Free DP-300 Questions for Microsoft DP-300 Exam as PDF & Practice Test Software

Page:    1 / 14   
Total 311 questions

Question 1

You have an Azure subscription that contains the following resources:

* 10 Azure SQL databases

* Five Azure SQL managed instances

* Five instances of SQL Server on Azure Virtual Machines

You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort. What should you include in the solution?



Answer : B


Question 2

You have an instance of SQL Server on Azure Virtual Machines named SQL1.

SQL1 contains an Extended Events session named session! that captures Microsoft SQL Server events.

You need to correlate the session events with events captured by Event Tracing for Windows (ETW).

What should you do for session1?



Answer : B


Question 3

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.

You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.

Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.



Answer : A, C, D


Question 4

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet.

You execute the following Transact-SQL statements.

You need to reduce the time it takes to perform analytic queries on the database.

Which configuration should you enable?



Answer : D


Question 5

You have an instance of SQL Server on Azure Virtual Machines named VM1.

You need to implement a disaster recovery solution that meets the following requirements:

* Returns the solution to an operational state within 15 minutes of a failure

* Can perform disaster recovery testing in an isolated environment

* Minimizes administrative effort

What should you include in the solution?



Page:    1 / 14   
Total 311 questions