What should you do to raise the level of security?

You are configuring a new SQL Server installation. The SQL Server instance will be used for both online
analytical processing (OLAP) and relational data. The data in the server is accessed frequently.
You can configure the services, startup type, and accounts used by the services that run on the server
according to the following table.
Service Startup type Account
SQL Server Automatic Local System
SQL Server Agent Automatic Local System
Analysis Services Automatic Local System
You want to raise the level of security on the server.
You need to minimize the surface area for potential attacks on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are configuring a new SQL Server installation. The SQL Server instance will be used for both online analytical processing (OLAP) and relational data. The data in the server is accessed frequently.
You can configure the services, startup type, and accounts used by the services that run on the server according to the following table.
Service Startup type Account
SQL Server Automatic Local System
SQL Server Agent Automatic Local System
Analysis Services Automatic Local System
You want to raise the level of security on the server.
You need to minimize the surface area for potential attacks on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A.
Change the Startup type property for all the services to Manual.

B.
Change the Startup type property for all the services to Disabled.

C.
Create a single non-administrative local user account and assign it to each of the services.

D.
Create three different non-administrative local user accounts and assign them to each of the services.



Leave a Reply 0

Your email address will not be published. Required fields are marked *