Administering a SQL Database Infrastructure — Question 124

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?

Answer options

• A. SqlOumperDumpFlags
• B. FailureConditionLevel
• C. HealthCheckTimeout
• D. SqlDumperDumpPath

Correct answer: B

Explanation

The correct answer is B, FailureConditionLevel, because it determines the conditions under which a failover will occur, including specific error types like query_processing errors. The other options either relate to different aspects of error handling or do not directly influence failover behavior.