Question 21
DP-800 is a newly released exam. These practice questions reflect our best current understanding — the exact wording and question formats may change in the live exam until the certification matures. Use them to learn the concepts, not to memorize.
DP-800 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →You need to calculate a rolling 30-day sales average per region and also rank the top-selling products within each region. The query must remain set-based and readable. Which approach should you recommend?
- AUse a cursor to iterate through each region and product.
- BUse window functions with PARTITION BY and ORDER BY.
- CExport the data to CSV and calculate the rankings in Excel.
- DCreate a trigger that writes aggregate rows during every insert.