YOU’RE RUNNING SQL SERVER 64-BIT AND WANT TO MAKE SURE THAT SQL SE...

10. You’re running SQL Server 64-bit and want to make sure that SQL Server

doesn’t take too much memory. Which of these options would achieve that?

A. Set Maximum Server Memory (MB) using sp_configure

B. Assign the SQL Service account the Lock Pages in Memory privilege

C. Set Maximum Server Memory (MB) using SQL Server Management

Studio

D. Start SQL Server with the -g switch passing the maximum memory as a

parameter

Correct Answer and Explanation: A and C. Maximum Server Memory con-

trols how much memory SQL Server will use and can be configured using

Management Studio or with sp_configure. B is incorrect because this would

make a 64-bit SQL Server use AWE to lock memory pages; it wouldn’t pre-

vent it from taking too much memory. D is incorrect because the -g switch

controls how much reserved memory SQL Server allocates; it won’t prevent

it from taking too much.