Microsoft
DP-300 · Question #326
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…
The correct answer is A. Enable the Query Store. The Query Store option is a cost-effective way to reduce memory pressure on a managed Azure SQL instance. The Query Store stores temporary data used by queries in the cloud, reducing the memory requirements of the managed Azure SQL instance.
Submitted by krish.m· Mar 6, 2026Monitor, configure, and optimize database resources
Question
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?
Options
- AEnable the Query Store.
- BChange vCores to 8.
- CChange Hardware generation to Premium-series.
- DChange Service tier to Business Critical.
How the community answered
(35 responses)- A43% (15)
- B34% (12)
- C9% (3)
- D14% (5)
Explanation
The Query Store option is a cost-effective way to reduce memory pressure on a managed Azure SQL instance. The Query Store stores temporary data used by queries in the cloud, reducing the memory requirements of the managed Azure SQL instance.
Community Discussion
No community discussion yet for this question.