Exam 70-461 topic 1 question 115 discussion

Actual exam question from Microsoft's 70-461

Question #: 115
Topic #: 1

Your application contains a stored procedure for each country. Each stored procedure accepts an employee identification number through the @EmpID parameter.
You need to build a single process for each employee that will execute the appropriate stored procedure based on the country of residence.
Which approach should you use?

A. A SELECT statement that includes CASE
B. Cursor
C. BULK INSERT
D. View
E. A user-defined function

Show Suggested Answer

Suggested Answer: E 🗳️
SQL Server user-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. The return value can either be a single scalar value or a result set.

by marco13 at June 1, 2020, 11:50 a.m.

Comments

Submit Cancel

gi48

4 years, 4 months ago

B is the correct answer

upvoted 1 times

...

Dimples205

4 years, 7 months ago

Based on the limitations on UDF's they cannot call SP's

upvoted 1 times

...

marco13

4 years, 11 months ago

Surely the answer here is instead B: Cursor (even though usage is generally not recommended, if avoidable). You cannot call a stored procedure from within a UDF.

upvoted 3 times

...

Exam 70-461 All Questions

View all questions & answers for the 70-461 exam

Exam 70-461 topic 1 question 115 discussion

Comments

gi48

Dimples205

marco13

SY0-701