You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. You have received instructions to
ensure that the entire SQL Server samples are set to comply with the following requirements.
* Security configurations should be accommodated
* Data fragmentation should be avoided
* Naming conventions should be accommodated
* Force index creation should be accommodated
What should you do?
A.
You should consider using the Process Control Tool.
B.
You should consider creating a policy in Microsoft SQL Server Management Studio.
C.
You should consider creating a maintenance plan in Microsoft SQL Server Management Studio.
D.
You should consider creating a recovery plan using the Web Service Tool.