Exam 70-464 topic 1 question 101 discussion

Actual exam question from Microsoft's 70-464

Question #: 101
Topic #: 1

You have a database named Inventory. Inventory is stored on Microsoft Azure SQL Database and contains a table named ProductDetails.
For a given product, you need to retrieve the ProductID, Manufacturer, Weight, and ListPrice columns for all of the items in the ProductDetails table. The solution must ensure that the results can be joined to other tables.
Which Transact-SQL statement should you run?
A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: A
You can JOIN views with tables. You can use views just like tables in SELECTs.
In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

by Kepty at Nov. 22, 2020, 9:41 p.m.

Comments

Submit Cancel

Kepty

4 years, 5 months ago

No, it should be B - for given product so we have to filter results based on the input

upvoted 4 times

...

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam

Exam 70-464 topic 1 question 101 discussion

Comments

Kepty

SY0-701