Microsoft Exam 70-465 Topic 2 Question 6 Discussion

Actual exam question for Microsoft's 70-465 exam

Question #: 6
Topic #: 2

You need to recommend a solution for the error handling of USP_4. The solution must handle errors for nested stored procedures in the code for USP_4.

What should you recommend?

AUse the @@ERROR variable in the nested stored procedures.

BUse the @@ERROR variable in USP_4.

CUse the RAISERROR command in the nested stored procedures.

DUse the RAISERROR command in USP_4.

Show Suggested Answer

Suggested Answer: C

* A stored procedure named USP_4 calls stored procedures in the Sales, Customers, and Inventory databases. The nested stored procedures read tables from the Sales, Customers, and Inventory databases. USP_4 uses an EXECUTE AS clause.

by Jacqueline at May 10, 2022, 03:59 AM

Limited Time Offer

25%

Off

Get Premium 70-465 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!