nerdexam
Microsoft

70-450 · Question #133

One of the developers at your company has written a CLT stored procedures that's clever enough to call a web service and update database records based on local weather information. He has packaged…

The correct answer is A. DROP ASSEMBLY. You should drop an assembly using the DROP ASSEMBLY statement. If the assembly is drop the assembly until you drop those dependent objects as well:

Design and implement an optimized data maintenance solution

Question

One of the developers at your company has written a CLT stored procedures that's clever enough to call a web service and update database records based on local weather information. He has packaged and deployed this CLR stored procedure as .NET assembly. However, the code has a major bug and you have been asked to delete the assembly from SQL Server. Which command should you use?

Options

  • ADROP ASSEMBLY
  • BDELETE ASSEMBLY
  • CREMOVE ASSEMBLY
  • DCLEANUP ASSEMBLY

How the community answered

(25 responses)
  • A
    80% (20)
  • B
    4% (1)
  • C
    4% (1)
  • D
    12% (3)

Explanation

You should drop an assembly using the DROP ASSEMBLY statement. If the assembly is drop the assembly until you drop those dependent objects as well:

Topics

#CLR assembly#DROP ASSEMBLY#T-SQL DDL#stored procedures

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-450 Practice