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 makes use of SQL Server 2012 instance in their environment.
ABC.com’s SQL Server 2012 instance includes a single-user database that has no user-created
stored procedures or user-created functions configured. You have been instructed to make sure
that the memory used for query plan caching is reduced.
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 Optimize for Ad hoc Workloads option.

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

Explanation: