Which server configuration property should you set?

You administer a Microsoft SQL Server 2016 failover cluster.

You need to ensure that a failover occurs when the server diagnostics returns query_processing error.

Which server configuration property should you set?
A . SqlOumperDumpFlags
B . FailureConditionLevel
C . HealthCheckTimeout
D . SqlDumperDumpPath

View Answer

Answer: B

Explanation:

The SQL Server Database Engine resource DLL determines whether the detected health status is a condition for failure using the FailureConditionLevel property. The FailureConditionLevel property defines which detected health statuses cause restarts or failovers. Multiple levels of options are available, ranging from no automatic restart or failover to all possible failure conditions resulting in an automatic restart or failover.

References: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/failover-policy-forfailover-cluster-instances