You need to implement the security policy and devise a method to evaluate the security policy against other database servers

You administer a SQL Server 2008 instance. You use an internal application based on SQL
Server 2008. The application uses Analysis Services and Reporting Services. Company
security policy requires that the surface area for all the deployed components of SQL Server
2008 be configured.
You need to implement the security policy and devise a method to evaluate the security
policy against other database servers.
What should you do?

You administer a SQL Server 2008 instance. You use an internal application based on SQL
Server 2008. The application uses Analysis Services and Reporting Services. Company
security policy requires that the surface area for all the deployed components of SQL Server
2008 be configured.
You need to implement the security policy and devise a method to evaluate the security
policy against other database servers.
What should you do?

A.
Edit the RSReportServer.config configuration file. Distribute the file to all database
servers that need to be configured

B.
Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers.
Implement the recommendations of the BPA.

C.
Create policies based on the appropriate facets. Apply the policies against a server group
that includes the database servers that need to be configured.

D.
Create a Transact-SQL script based on the sp_configure stored procedure. Use a
configuration server to rim the script against a server group that includes the database
servers that need to be configured



Leave a Reply 0

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