Exam DP-300 topic 3 question 28 discussion

Actual exam question from Microsoft's DP-300

Question #: 28
Topic #: 3

You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Enable query optimizer fixes.
B. Enable Resource Governor.
C. Enable parameter sniffing.
D. Create a workload group.
E. Configure In-memory OLTP.
F. Run the Database Engine Tuning Advisor.
G. Reduce the Max Degree of Parallelism value.

Show Suggested Answer

Suggested Answer: BD 🗳️

by o2091 at Nov. 12, 2021, 10:44 p.m.

Comments

Submit Cancel

Singii

Highly Voted 2 years, 4 months ago

Selected Answer: BD

The given answer is correct.

upvoted 9 times

...

ladistar

Most Recent 1 year ago

Per ChatGPT, BD is the correct answer.

upvoted 1 times

...

mhmodsaid

2 years, 1 month ago

Selected Answer: BD

The given answer is correct.

upvoted 3 times

...

smaa

2 years, 4 months ago

Answer is B and D from what I understood. From Microsoft docs: Resource Governance To enforce resource limits, Azure SQL Database uses a resource governance implementation that is based on SQL Server Resource Governor, modified and extended to run in the cloud. In SQL Database, multiple resource pools and workload groups, with resource limits set at both pool and group levels, provide a balanced Database-as-a-Service. User workload and internal workloads are classified into separate resource pools and workload groups. User workload on the primary and readable secondary replicas, including geo-replicas, is classified into the SloSharedPool1 resource pool and UserPrimaryGroup.DBId[N] workload groups, where [N] stands for the database ID value. In addition, there are multiple resource pools and workload groups for various internal workloads.

upvoted 4 times

...