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


Leave a Reply