Exam 70-761 topic 1 question 95 discussion

Actual exam question from Microsoft's 70-761

Question #: 95
Topic #: 1

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database that contains several connected tables. The tables contain sales data for customers in the United States only.
You have the following partial query for the database. (Line numbers are included for reference only.)

You need to complete the query to generate the output shown in the following table.

Which statement clause should you add at line 3?

A. GROUP BY
B. MERGE
C. GROUP BY ROLLUP
D. LEFT JOIN
E. GROUP BY CUBE
F. CROSS JOIN
G. PIVOT
H. UNPIVOT

Show Suggested Answer

Suggested Answer: E 🗳️
Example of GROUP BY CUBE result set:
In the following example, the CUBE operator returns a result set that has one grouping for all possible combinations of columns in the CUBE list and a grand total grouping.

References:
https://technet.microsoft.com/en-us/library/bb522495(v=sql.105).aspx

by safiullah at Aug. 16, 2019, 1:37 p.m.

Comments

Submit Cancel

safiullah

Highly Voted 5 years, 10 months ago

Hi, My feeling is this should be a GROUP BY ROLL UP because if you notice we have the following columns. COUNTRY, PROVINCE, CITY and in ROLL UP we will get the combinations in an hierarchy. First Combination : COUNTRY, PROVINCE, CITY Second COmbination: COUNTRY, PROVINCE Third Combination: COUNTRY FINAL combination: ALL This is what we see in the resultant table.

upvoted 45 times