Which of the following is a best practice to reduce session blocking in a database?

Keep transactions as short as possible

Use long-running transactions to ensure consistency

Which T-SQL statement creates a nonclustered index on a table?

CREATE NONCLUSTERED INDEX IX_Column ON Table (Column)

CREATE INDEX IX_Column ON Table (Column) NONCLUSTERED

CREATE INDEX NONCLUSTERED IX_Column ON Table (Column)

ADD NONCLUSTERED INDEX IX_Column TO Table (Column)

You are using Query Store to analyze a query that has multiple execution plans. You notice that the query's performance varies significantly depending on the plan chosen. You want to force the best-performing plan to be used consistently. What should you do?

Clear the query store cache to reset plan selection.

Use the sp_query_store_force_plan stored procedure to force the desired plan.

Disable Query Store to prevent plan changes.

Set the database to a lower compatibility level.

Microsoft Certified:Azure Database Administrator Associate

Domain 3Objective 2

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

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 11–15

11foundation · easy
Which of the following is a best practice to reduce session blocking in a database?
Select an answer first
12foundation · easy
Which Query Store setting controls the maximum amount of data that Query Store can capture for a database?
Select an answer first
13foundation · easy
Which T-SQL statement creates a nonclustered index on a table?
Select an answer first
14foundation · easy
Which execution plan operator is typically the most efficient for retrieving a small number of rows using an index?
Select an answer first
15application · medium
You are using Query Store to analyze a query that has multiple execution plans. You notice that the query's performance varies significantly depending on the plan chosen. You want to force the best-performing plan to be used consistently. What should you do?
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 3)

Questions 11–15

Which of the following is a best practice to reduce session blocking in a database?

Which Query Store setting controls the maximum amount of data that Query Store can capture for a database?

Which T-SQL statement creates a nonclustered index on a table?

Which execution plan operator is typically the most efficient for retrieving a small number of rows using an index?

You are using Query Store to analyze a query that has multiple execution plans. You notice that the query's performance varies significantly depending on the plan chosen. You want to force the best-performing plan to be used consistently. What should you do?

Keep studying — Monitor, configure, and optimize database resources