Question 16
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 hierarchy of managers and employees must be queried to return each employee's full reporting path. The depth of the hierarchy can vary over time. Which technique should you use?
- AA recursive common table expression
- BA CHECK constraint
- CA persisted computed column with hard-coded levels
- DA scalar function that returns a random path