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
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
Leave a Reply