Which of the following is a recommendation for installing SQL Server 2012 for optimal logical security?
A)install it on a dedicated server not shared with other services
B)install it on hardware with appropriate physical access controls
C)install it on a domain controller
D)install it on a server with several other services

Question

Quizplus · Accepted Answer

Installing SQL Server 2012 on a dedicated server not shared with other services is the best choice for optimal logical security, as it reduces the surface area for potential attacks and allows for more precise access controls. Installing it on hardware with appropriate physical access controls is also important for physical security, but not directly related to logical security. Installing it on a domain controller or a server with several other services can increase the risk of security vulnerabilities and should be avoided.

Which of the Following Is a Recommendation for Installing SQL