Microsoft Exam Questions

You need to ensure that all SQL Server instances are consistently configured for the following aspec

You administer several SQL Server 2008 instances.
You need to ensure that all SQL Server instances are consistently configured for the
following aspects:
-Naming conventions -Security settings -Force index creation -Avoidance of data
fragmentation
What should you do?

A.
Use the Database Engine Tuning Advisor.

B.
Use the SQL Server Configuration Manager.

C.
Create a policy in Microsoft SQL Server Management Studio.

D.
Create a maintenance plan in Microsoft SQL Server Management Studio.

Explanation: