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;