Exam 70-461 topic 1 question 166 discussion

Actual exam question from Microsoft's 70-461

Question #: 166
Topic #: 1

You use a Microsoft SQL Server database that contains a table. The table has records of customer orders.
Your company has three divisions that have the following names:
✑ East
✑ Central
✑ West
You need to create a query that displays the following information:
✑ The number of sales for each product (ProductName) grouped by the division (Division) that sold the product
✑ A column for each division
Which Transact-SQL query should you use?
A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: D
You can use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output. UNPIVOT performs the opposite operation to PIVOT by rotating columns of a table-valued expression into column values.
References:
https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

by lilupv at Sept. 7, 2020, 6:28 p.m.