Question 11
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 →A procedure must accept optional filters for region, product category, and date range without introducing SQL injection risk. Which implementation should you recommend?
- AUse dynamic SQL built with string concatenation from user input.
- BUse sp_executesql with parameterized inputs.
- CStore all filters in a screenshot for manual review.
- DCreate one procedure per possible filter combination only.