TAKE TEST: SKILL 2.2 QUIZ

Which selection is not a configuration setting for the server and database performance?

_______________ is a collection of hardware and software settings with the responsibility of managing how your computer manages power.

________________is the number of processors used to run a single T-SQL statement for each parallel plan execution.

The SQL server agent reads the application log and compares it to defined and configured alerts.

There are _______severity codes that are available when setting up alerts.

SQL Server Operators are aliases for ____________________which can receive notifications in the form of emails or pages when an alert has been generated.

Cardinality estimation cannot predict the number of rows a query is most likely to return.

The Query Optimizer Fixes configuration setting, enables or disables query optimization hotfixes regardless of the compatibility level of the database which is equivalent to trace flag_______________.

The MAX DOP configuration setting is similar to the server-level Max Degree or Parallelism configuration setting, but Max DOP is a database-level configuration setting.

_____________is a feature that provides real-time insights into query performance proactively.