You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 database that makes use of the Analysis Services and Reporting Services. However,
installed components at Domain.com adhere to the Domain.com security policy.
You have received instruction to ensure that you adhere to the Domain.com security policy.
What should you do?
A.
You should consider changing the configuration of the SQL Server Best Practices Analyzer
(BPA) and assign the least amount of privilege.
B.
You should consider changing the Default Resource Pool configuration file and run it again.
C.
You should consider developing a Transact-SQL script based on the sp_configure stored procedure.
D.
You should consider developing policies based on the security policy before applying the
policies against a server group which contains the database servers which need to be set.