You need to ensure that all SQL Server instances are consistently configured for the following aspects…?

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?

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:



Leave a Reply 0

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