Which two database objects should you use?

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

View Answer

Answer: BD

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).

Incorrect Answers:

A: A table valued function cannot be called from indexed view

C: The Stored procedure cannot be called inside of a View.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-transact-sql