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.
Suggested Answer:AC🗳️
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.
correct answers AD:
A: table valued function can be called from index view TESTED.
B: CRL doesnt exist, exist CLR
C: Store procedure cant be called from view
D: scalar function CAN be called from view
A clustered index can't reference a TVF or MSTVF in the SELECT statement, but it can still be elsewhere such as in the WHERE clause. CLR functions aren't database objects, and stored procedures can't be invoked from a view, so I'd pick A,D.
https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver15
I think it A and D (both of them have user-defined functions)
You can even use a user-defined function to query an indexed view, and with parameter
support, improve its functionality.
A,C
a user-defined table-valued function can return what we wanted expression values as long as we specify schemabinding option.
stored procedure with table value variable as output parameter could also achieve the same purpose.
B,D doesn't meet requirement since CLR function is not a DB object and scalar function didn't meet requirement of returning multiple rows.
If you create a function with option "SCHEMABINDING" you can use user-defined function table and scalar
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.70-761 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Tazul
Highly Voted 5 years, 8 months agoVermonster
Most Recent 4 years, 4 months agokimalto452
4 years, 4 months agojulie2020
4 years, 9 months agokimalto452
4 years, 4 months agoAlaskanBumblebee
4 years, 9 months agoTakecare
4 years, 10 months agokimalto452
4 years, 4 months agoAnette
4 years, 11 months agojortizhuedo
5 years, 1 month agoRobintang0924
5 years, 4 months agomattia_88
5 years, 6 months ago