Exam 70-765 topic 3 question 89 discussion

Actual exam question from Microsoft's 70-765

Question #: 89
Topic #: 3

You use Microsoft Azure Resource Manager to deploy two new Microsoft SQL Server instances in an Azure virtual machine (VM). VM has 28 gigabytes (GB) of memory. The instances are named Instance1 and Instance2, respectively.
The various databases on the instances have the following characteristics:

You run the following Transact-SQL statements:

You need to configure each SQL Server instance to correctly allocate memory.
What should you do?

A. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:
B. A. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:
C. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:
D. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:

Show Suggested Answer

Suggested Answer: D 🗳️
Incorrect Answers:
A, C: The awefeature will be removed in newer version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
B: Automatic soft-NUMA is disabled by default, and this setting is not relevant here.
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server

by manman at July 18, 2019, 1:17 p.m.

Comments

Submit Cancel

Varad

Highly Voted 5 years, 9 months ago

D. On Instance1, run the following Transact-SQL code: sp_configure 'max server memory', 18432 RECONFIGURE On Instance2, run the following Transact-SQL code: sp_configure 'min server memory', 6144 RECONFIGURE

upvoted 6 times

...

manman

Most Recent 6 years, 1 month ago

Option D in incomplete

upvoted 2 times

...