You need to create an indexed view that requires logic statements to manipulate the data that the view displays.
Which two database objects should you use? Each correct answer presents a complete solution.
A.
a user-defined table-valued function
B.
a CRL function
C.
a stored procedure
D.
a user-defined scalar function
Explanation:
You can create a database object inside an instance of SQL Server that is programmed in an assembly created
in the Microsoft .NET Framework common language runtime (CLR). Database objects that can leverage the
rich programming model provided by the common language runtime include aggregate functions, functions,
stored procedures, triggers, and types.