Question 133
DP-300 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →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.
- AEnable query optimizer fixes.
- BEnable Resource Governor.
- CEnable parameter sniffing.
- DCreate a workload group.
- EConfigure In-memory OLTP.
- FRun the Database Engine Tuning Advisor.
- GReduce the Max Degree of Parallelism value.