Exam 70-761 topic 1 question 162 discussion

Actual exam question from Microsoft's 70-761

Question #: 162
Topic #: 1

You are building a stored procedure named SP1 that calls a stored procedure named SP2.
SP2 calls another stored procedure named SP3 that returns a Recordset. The Recordset is stored in a temporary table.
You need to ensure that SP2 returns a text value to SP1.
What should you do?

A. Create a temporary table in SP2, and then insert the text value into the table.
B. Return the text value by using the ReturnValue when SP2 is called.
C. Add the txt value to an OUTPUT parameter of SP2.
D. Create a table variable in SP2, and then insert the text value into the table.

Show Suggested Answer

Suggested Answer: C 🗳️

by lh2607 at Dec. 15, 2020, 7:11 p.m.