nerdexam
Microsoft

70-450 · Question #147

Stored procedures, triggers and functions can all be written in CLR compatible languages in SQL Server 2008. Why would someone want to use CLR store procedures rather than standard T- SQL stored…

The correct answer is A. Type safety. See the full explanation below for the reasoning.

Question

Stored procedures, triggers and functions can all be written in CLR compatible languages in SQL Server 2008. Why would someone want to use CLR store procedures rather than standard T- SQL stored procedures?

Options

  • AType safety
  • BThey are faster
  • CThey require less development effort
  • DT-SQL is outdated and CLR languages are a better choice

How the community answered

(19 responses)
  • A
    74% (14)
  • B
    5% (1)
  • C
    5% (1)
  • D
    16% (3)

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice