Microsoft Exam 70-464 Topic 8 Question 1 Discussion

Actual exam question for Microsoft's 70-464 exam

Question #: 1
Topic #: 8

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?

AOptimize for Ad hoc Workloads

BEnable Contained Databases

CAllow Triggers to Fire Others

DScan for Startup Procs

Show Suggested Answer

Suggested Answer: A

by Franklyn at May 06, 2022, 09:43 PM

Limited Time Offer

25%

Off

Get Premium 70-464 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!