You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that
meets the following requirements:
Takes an input variable
Returns a table of values
Cannot be referenced within a view
Which object should you use?
A.
Scalar-valued function
B.
Inline function
C.
User-defined data type
D.
Stored procedure
Could someone explain the logic behind this answer?
0
0
no
0
0
A and C aren’t correct. B – there is no such thing called inline function, only inline table valued function
0
0
There is but you can reference it with in a view.
https://technet.microsoft.com/en-us/library/ms189294(v=sql.105).aspx
0
0
Correct is D: Stored Procedure
0
0
Procedure cannot be referenced within a view Hence D
0
0
What’s more, part of the new 200Q 70-461 dumps FYI:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0