Which two database objects should you use?

Posted by: Pdfprep Category: 70-761 Tags: , ,

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

Your email address will not be published.