Exam AZ-120 topic 3 question 35 discussion

Actual exam question from Microsoft's AZ-120

Question #: 35
Topic #: 3

You plan to automate a deployment of SAP NetWeaver on Azure virtual machines by using Azure Resource Manager templates. The database tier will consist of two instances of an Azure Marketplace Microsoft SQL Server 2017 virtual machine image that each has 8 TB of RAM.

Which task should you include in the templates used to deploy the SQL Server virtual machines?

A. Enable read caching on the disks used to store the SQL Server database log files.
B. Run the SQL Server setup and specify the /ACTION=INSTALL and /SQLMAXMEMORY switches.
C. Enable buffer pool extensions in SQL Server.
D. Run the SQL Server setup and specify the /ACTION=REBUILDDATABASE and /SQLCOLLATION switches.

Show Suggested Answer

Suggested Answer: B 🗳️

by tmtrg000 at April 23, 2023, 11:19 a.m.

Comments

Submit Cancel

tmtrg000

8 months ago

B. Run the SQL Server setup and specify the /ACTION=INSTALL and /SQLMAXMEMORY switches. When deploying SQL Server on Azure virtual machines, it's recommended to use a custom script extension in the Azure Resource Manager templates to automate the installation and configuration of SQL Server. By specifying the /ACTION=INSTALL and /SQLMAXMEMORY switches during the installation, you can ensure that SQL Server is configured with the appropriate maximum memory allocation for the virtual machine. This is especially important in scenarios where you have large amounts of RAM available on the virtual machine, such as in this case where the SQL Server virtual machine image has 8 TB of RAM.

upvoted 2 times

...