PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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