You administer a Microsoft SQL Server 2012 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
Explanation:
C
No, B: FailureConditionLevel 5 explicitly states :
System stored procedure sp_server_diagnostics returns ‘query_processing error’.
I say B.
B
https://msdn.microsoft.com/en-us/library/ff878664.aspx