DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ49

Monitor, configure, and optimize database resources

You have SQL Server running on an Azure virtual machine that hosts a database named DB1.

An application queries DB1 to generate a sales report.

You need to view the parameter values used the last time the query ran.

Which two actions should you take? Each correct answer represents part of the solution.

NOTE: Each correct selection is worth one point.

Choose two
Explanation

LAST_QUERY_PLAN_STATS enables retrieval of the last known actual execution plan for queries in the database, and that plan includes runtime parameter information. This capability operates on the lightweight query execution statistics profiling infrastructure. Both database-scoped configurations must be enabled for DB1; configuring master does not enable them for DB1. PARAMETER_SNIFFING controls compilation behavior and does not retain prior execution parameter values.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!