Exam 70-461 topic 1 question 224 discussion

Actual exam question from Microsoft's 70-461

Question #: 224
Topic #: 1

You are developing an application that uses data residing in two databases named Inventory and Accounting on a single Microsoft SQL Server 2012 server.
You plan to provide a record set from tables in the Inventory database. You write the following query:

You need to create this query as a permanent database object that can be joined to other queries. The other queries will be run from the Accounting database.
Neither database allows cross-database ownership.
Which Transact-SQL statement should you use?
A.

B.

C.

D.

E.

Show Suggested Answer

Suggested Answer: B
A table-valued function returns a single rowset (unlike stored procedures, which can return multiple result shapes). Because the return type of a table-valued function is Table, you can use a table-valued function anywhere in SQL that you can use a table. You can also treat the table-valued function just as you would a table.
References:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/how-to-use-table-valued-user-defined-functions

by lilupv at Sept. 3, 2020, 8:48 a.m.

Comments

Submit Cancel

lilupv

4 years, 9 months ago

Why not view?

upvoted 1 times

...