PrepAway - Latest Free Exam Questions & Answers

Which advanced server option should you modify?

You have a SQL Server 2012 instance that hosts a single-user database.
The database does not contain user-created stored procedures or user-created functions.
You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?

PrepAway - Latest Free Exam Questions & Answers

A.
Scan for Startup Procs

B.
Enable Contained Databases

C.
Optimize for Ad hoc Workloads

D.
Allow Triggers to Fire Others

One Comment on “Which advanced server option should you modify?


Leave a Reply