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 #21 (Topic: All Exam Questions)
HOTSPOT
You have an Azure SQL database.
You are reviewing a slow performing query as shown in the following exhibit.
A.
Correct Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-querystatistics?
view=sql-server-ver15
Question #22 (Topic: All Exam Questions)
You have an Azure SQL managed instance.
You need to gather the last execution of a query plan and its runtime statistics. The solution must
minimize the impact on currently running queries.
What should you do?
Correct Answer: C
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-managementviews/
sys-dm-exec-query-plan-stats-transact-sql?view=sql-server-ver15
Question #23 (Topic: All Exam Questions)
HOTSPOT
You have an Azure SQL database named db1 on a server named server1.
You use Query Performance Insight to monitor db1.
You need to modify the Query Store configuration to ensure that performance monitoring data is
available as soon as possible.
Which configuration setting should you modify and which value should you configure? To answer,
select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
A.
Correct Answer: A
Question #24 (Topic: All Exam Questions)
You have an Azure SQL Database managed instance.
The instance starts experiencing performance issues.
You need to identify which query is causing the issue and retrieve the execution plan for the query.
The solution must minimize administrative effort.
What should you use?
Correct Answer: D
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performanceby
using-the-query-store?view=sql-server-ver15