70-465 · Question #28
70-465 Question #28: Real Exam Question with Answer & Explanation
Sign in or unlock 70-465 to reveal the answer and full explanation for question #28. The question stem and answer options stay visible for context.
Question
You are building a stored procedure for a SQL Azure database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet the following requirements: - If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded. - If any errors occur, a row must be added to an audit table, and the original error must be returned to the caller of the stored procedure. What should you include in the design?
Options
- AAn implicit transaction that has XACT_ABORT enabled
- BAn explicit transaction that has XACT_ABORT disabled
- CAn implicit transaction that has error handling enabled
- DAn explicit transaction that has error handling enabled
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.