Exit 70-462 Administering Microsoft SQL Server 2012/2014 Databases
Question 1 of 5
0% complete
Q1 Single choice

Which of the following statements will set the maximum amount of system memory that is managed by the SQL Server Memory Manager to 4GB?

  • A

    sp_configure `max memory', 4;

  • B

    ALTER SYSTEM SET `max server memory'=4096;

  • C

    sp_configure `max server memory', 4;

  • D

    sp_configure `max server memory', 4096;

Previous Next