PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

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

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


Leave a Reply