option?

Which task should you perform before you can create a utility control point by using the service account

option?
A . Disable the Microsoft SQL Server browser service
B . Start all Data Collector Sets (DCSs) in a Microsoft SQL Server instance
C . Enable named pipes on a Microsoft SQL Server instance
D . Configure the Microsoft SQL Server Agent service account to use an Active Directory Domain Services (AD DS) user account

View Answer

Answer: D

Explanation:

Utility Collection Set Account Specify a Windows domain account to run the SQL Server Utility collection set. This account is used as the SQL Server Agent proxy account for the SQL Server Utility collection set. Alternatively, you can use the existing SQL Server Agent service account. To pass validation requirements, use the following guidelines to specify the account. If you specify the SQL Server Agent service account option: The SQL Server Agent service account must be a Windows domain account that is not a built-in account like LocalSystem, NetworkService, or LocalService. References: https://docs.microsoft.com/en-us/sql/relational-databases/manage/create-a-sql-server-utility­control-point-sqlserver- utility