Administering a SQL Database Infrastructure — Question 91

You administer a SQL Server 2016 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?

Answer options

• A. A domain user
• B. The BUILTIN\SYSTEM account
• C. A local user with Run as Service permissions
• D. The SQLBrowser account

Correct answer: A

Explanation

The correct answer is A, a domain user, because it provides the necessary permissions and authentication needed for a failover cluster. The BUILTIN\SYSTEM account (B) lacks the required cluster permissions, while a local user (C) does not have the necessary domain access, and the SQLBrowser account (D) is not intended for this purpose.