Question

Purpose of syspolicy_system_health_state in policy based management is ______________

(a) Displays one row for each Policy-Based Management policy

(b) Organize policies when you have many policies

(c) Displays the time when policies were executed, the result of each execution, and details about errors if any occurred

(d) None of the mentioned

This question was addressed to me in an international level competition.

Origin of the question is Policy Based Management topic in portion Enterprise Data Management of SQL Server

Answer 1

Correct answer is (a) Displays one row for each Policy-Based Management policy

For explanation: Use the syspolicy_system_health_state view to programmatically check the policy health of the server.