Administering Microsoft Azure SQL Solutions DP-300 Exam Questions
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