nerdexam
Microsoft

70-516 · Question #120

70-516 Question #120: Real Exam Question with Answer & Explanation

Sign in or unlock 70-516 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.

Question

You are calling a stored procedure in SQL Server 2008 that returns a UDT as an output parameter. This UDT, called MyCompanyType, was created by your company. The UDT has a method called GetDetails that you want to execute in your client application. What must you do to execute the method? (Each correct answer presents part of a complete solution. Choose three.)

Options

  • ASet the SqlDbType of the parameter to SqlDbType.Udt.
  • BSet the UdtTypeName of the parameter to MyCompanyType.
  • CCall the ExecuteXmlReader method on the SqlCommand to serialize the UDT as XML.
  • DIn the client application, set a reference to the assembly in which the UDT is.

Unlock 70-516 to see the answer

You've previewed enough free 70-516 questions. Unlock 70-516 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.

Full 70-516 Practice