Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has a database, which is hosted on a SQL Server 2012 instance, and supports an
essential business web application. The web application dynamically creates all T-SQL statements
without the use of stored procedures.
You have received instructions to increase the available data caching memory.
Which of the following actions should you take?

A.
You should consider configuring the Ole Automation Procedures option.

B.
You should consider configuring the max degree of parallelism option.

C.
You should consider configuring the ad hoc distributed queries option.

D.
You should consider configuring the Optimize for Ad hoc Workloads option.

Explanation: