Administering Relational Databases on Microsoft Azure — Question 45

You have an Azure SQL managed instance named SQLMI1 that has the following settings:

• vCores: 4
• Service tier: General Purpose
• Hardware generation: Standard-series (Gen5)

You discover that memory pressure on SQLMI1 is high.

You need to reduce the memory pressure on SQLMI1. The solution must minimize costs.

What should to do?

Answer options

• A. Enable the Query Store.
• B. Change vCores to 8.
• C. Change Hardware generation to Premium-series.
• D. Change Service tier to Business Critical.

Correct answer: B

Explanation

Increasing the vCores to 8 will provide more memory resources, thus alleviating the memory pressure on SQLMI1. The other options either do not directly address memory issues or would incur additional costs without effectively solving the problem.