Microsoft
70-432 · Question #70
You are the administrator of a SQL Server 2008 instance. There is an internal application which uses Analysis Services and Reporting Services. According to the requirement of company security…
The correct answer is A. You should create policies based on the appropriate facets. Apply the policies against a. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. There is an internal application which uses Analysis Services and Reporting Services. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?
Options
- AYou should create policies based on the appropriate facets. Apply the policies against a
- BYou should create a Transact-SQL script based on the sp_configure stored procedure.
- CYou should edit the RSReportServer.config configuration file.
- DYou should analyze your database servers by using the SQL Server Best Practices
How the community answered
(50 responses)- A76% (38)
- B14% (7)
- C4% (2)
- D6% (3)
Community Discussion
No community discussion yet for this question.