Administering Microsoft Azure SQL Solutions DP-300 Exam Questions

Preparing for the DP-300 exam is simple with CertsPoint. We offer easy-to-understand study materials that help you learn the most important exam topics. You can study using our PDF questions, practice online with a real exam-style test, or use the desktop practice software. Choose the study method that works best for you and prepare at your own pace.

At CertsPoint, we keep our DP-300 practice questions up to date. Whenever the exam syllabus or objectives change, we update our study materials so you always learn the latest topics. This helps you save time, avoid outdated content, and feel more confident when you take your exam.

Question #16 (Topic: All Exam Questions)

You have an Azure SQL database named db1 on a server named server1.

You need to modify the MAXDOP settings for db1.

What should you do?

Connect to db1 and run the sp_configure command.

Connect to the master database of server1 and run the sp_configure command.

Configure the extended properties of db1.

Modify of db1.

Correct Answer: D

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism

Question #17 (Topic: All Exam Questions)

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 SQL Server 2019 on an Azure virtual machine.

You are troubleshooting performance issues for a query in a SQL Server instance.

To gather more information, you query sys.dm_exec_requests and discover that the wait type is

PAGELATCH_UP and the wait_resource is 2:3:905856.

You need to improve system performance.

Solution: You create additional tempdb files.

Does this meet the goal?

A. True

B. False

Correct Answer: A

Explanation:

Reference:

https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduceallocation

contention

Question #18 (Topic: All Exam Questions)

You have SQL Server on an Azure virtual machine.

You need to add a 4-TB volume that meets the following requirements:

Maximizes IOPs

Uses premium solid state drives (SSDs)

What should you do?

Attach two mirrored 4-TB SSDs.

Attach a stripe set that contains four 1-TB SSDs.

Attach a RAID-5 array that contains five 1-TB SSDs.

Attach a single 4-TB SSD.

Correct Answer: B

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storageconfiguration?

tabs=windows2016

Question #19 (Topic: All Exam Questions)

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log identifies that several tables are missing indexes.

You need to ensure that indexes are created for the tables.

What should you do?

RuntheDBCC SQLPERF command.

Run the dbcc dbreindex command.

Modify the automatic tuning settings for db1.

Modify the Query Store settings for db1.

Correct Answer: C

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview

Question #20 (Topic: All Exam Questions)

You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.

You need to limit the number of IOPs that App2 queries generate on SQL1.

Which two actions should you perform on SQL1? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Enable query optimizer fixes.

Enable Resource Governor.

Enable parameter sniffing

Create a workload group.

Configure In-memory OLTP.

Run the Database Engine Tuning Advisor.

Next Question

Correct Answer: B, D

Explanation:

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resourcegovernor?

view=sql-server-ver15

« Prev Page: 4 / 5