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.
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
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