You are the SharePoint architect for a company that implements SharePoint 2013. The company uses SQL
Server 2012 R2.
You must build and run a database maintenance plan.
Which two actions should you perform? Each correct answer presents part of the solution.
A.
Run the DBCC CHECKALLOC, DBCC CHECKTABLE, and DBCC CHECKCATALOG commands on all databases.
B.
Perform database shrink operations on all databases.
C.
Configure the database to autogrow at a fixed percentage.
D.
Run the DBCC CHECKDB command on all databases.
E.
Monitor CPU, memory, cache/hit ratio, and the I/O subsystem.
F.
Enable auto-creation of statistics.
Explanation:
https://technet.microsoft.com/en-us/library/cc262731(v=office.14).aspx