You have a database for a mission-critical web application. The database is stored on a SQL Server 2012
instance and is the only database on the instance.
The application generates all T-SQL statements dynamically and does not use stored procedures. You need to
maximize the amount of memory available for data caching.
Which advanced server option should you modify?
A.
Optimize for Ad hoc Workloads
B.
Enable Contained Databases
C.
Allow Triggers to Fire Others
D.
Scan for Startup Procs