Question 8
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 finance application calls a stored procedure that posts invoice payments. The procedure must validate input, update multiple tables atomically, and return a consistent error message if validation fails. Which implementation should you recommend?
- AUse a stored procedure with TRY...CATCH, explicit transactions, and THROW for error handling.
- BGenerate ad hoc UPDATE statements in the application for each table.
- CUse a trigger on every table to infer the payment workflow.
- DStore the invoice workflow in JSON and process it asynchronously without validation.