You are analyzing an execution plan for a query that joins three tables. The plan shows a hash join with a large memory grant and a warning about excessive memory usage. The query runs slowly and sometimes times out. You need to reduce the memory grant without changing the query logic. What should you do?

Force a nested loops join using a query hint.

Increase the database's MAXDOP to reduce memory grant per operator.

Update statistics on the join columns to improve cardinality estimates.

Use a columnstore index on the largest table.

You are analyzing a slow-running query in Azure SQL Database. The execution plan shows a large number of logical reads and a warning about a key lookup. The query uses a WHERE clause with a function on the indexed column. Which query construct modification is most likely to improve performance?

Increase the database's compatibility level to the latest version.

Rewrite the WHERE clause to avoid applying a function to the indexed column, such as using a range condition instead.

Use a table hint to force a clustered index scan.

Add a hint to force a parallel plan for the query.

Microsoft Certified:Azure Database Administrator Associate

Domain 3Objective 2

Monitor and Optimize Query Performance DP-300 Practice Questions (Page 5)

Part of the Monitor, configure, and optimize database resources domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 42 practice questions to prepare you well beyond it. (estimate)

42questions here

9free pages

10concepts

20–25%of the exam

Questions 21–25

21foundation · easy
Which operator in an execution plan indicates that the entire table is being read to find matching rows?
Select an answer first
22foundation · easy
Which Azure SQL Database feature uses machine learning to automatically detect performance anomalies and provide root cause analysis?
Select an answer first
23expert · hard
You are analyzing an execution plan for a query that joins three tables. The plan shows a hash join with a large memory grant and a warning about excessive memory usage. The query runs slowly and sometimes times out. You need to reduce the memory grant without changing the query logic. What should you do?
Select an answer first
24application · medium
You are analyzing a slow-running query in Azure SQL Database. The execution plan shows a large number of logical reads and a warning about a key lookup. The query uses a WHERE clause with a function on the indexed column. Which query construct modification is most likely to improve performance?
Select an answer first
25foundation · easy
Which dynamic management view provides information about sessions currently blocking other sessions in SQL Server?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Monitor and Optimize Query Performance DP-300 Practice Questions (Page 5)

Questions 21–25

Which operator in an execution plan indicates that the entire table is being read to find matching rows?

Which Azure SQL Database feature uses machine learning to automatically detect performance anomalies and provide root cause analysis?

You are analyzing a slow-running query in Azure SQL Database. The execution plan shows a large number of logical reads and a warning about a key lookup. The query uses a WHERE clause with a function on the indexed column. Which query construct modification is most likely to improve performance?

Which dynamic management view provides information about sessions currently blocking other sessions in SQL Server?

Keep studying — Monitor, configure, and optimize database resources