Free Microsoft DP-300 Exam Dumps Questions & Answers

Drag and Drop Question
You have an Azure SQL managed instance named SQLMI1 that has Resource Governor enabled and is used by two apps named App1 and App2.
You need to configure SQLMI1 to limit the CPU and memory resources that can be allocated to App1.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation:
1. The resource pool provides and limits the resources required by the application
2. The workload group uses the resource pool it is associated with
3. The classifier function assign the incoming session to the workload group
4. Modify resource governor to apply configuration changes
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/create-and-test-a-classifier-user-defined-function?view=sql-server-ver15

You have a Microsoft SQL Server 2022 instance.
You need to troubleshoot failing SQL Agent Jobs.
Which command should you run?

• A.  EXEC sp_trace_setfilter
• B.  EXEC sp_read_error_log;
• C.  EXEC sp_help_jobserver
• D.  EXEC sp_help_jobsteplog

Hotspot Question
You have an Azure SQL database named DB1 in the General Purpose service tier.
You need to monitor DB1 by using SQL Insights.
What should you include in the solution? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation:
SQL Insights stores its data in one or more Log Analytics workspaces.
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-enable?view=azuresql#create-log-analytics-workspace

You have a failover cluster deployed to Microsoft Azure virtual machines.
You plan to deploy a new Microsoft SQL instance to the cluster.
The instance will host one database that has 10 file groups.
You provision 10 disks for the instance.
You need to recommend a storage solution that always provides the fastest possible reads for the database.
What should you include in the recommendation?

• A.  dynamic disks that use striping
• B.  dynamic disks that use mirroring
• C.  a storage space
• D.  one file group per disk

Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1.
You have an Azure subscription.
You plan to migrate db1 to an Azure SQL managed instance.
You need to create the SQL managed instance. The solution must minimize the disk latency of the instance.
Which service tier should you use?

• A.  Hyperscale
• B.  General Purpose
• C.  Business Critical
• D.  Premium