Note: this question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in the series. Information and details provided in a question apply only to that question.
You are developing an application to track customer sales.
You need to create an object that meets to following requirements:
Run managed code packaged in an assembly that was created in the Microsoft.NET Framework and

uploaded in Microsoft SQL Server.
Run written a transaction and roll back if a failure occurs.

Run when a table is created or modified.

What should you create?
Correct Answer: B
Explanation/Reference:
Explanation:
The common language runtime (CLR) is the heart of the Microsoft .NET Framework and provides the execution environment for all .NET Framework code. Code that runs within the CLR is referred to as managed code.
With the CLR hosted in Microsoft SQL Server (called CLR integration), you can author stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates in managed code.
References: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/introduction-to-sql-server- clr-integration