Exam 70-761 topic 1 question 198 discussion

Actual exam question from Microsoft's 70-761

Question #: 198
Topic #: 1

You run the following Transact-SQL statement:

You use the table to store data about training courses: when they finished the location, and the number of participants in the courses.
You need to display a result set that shows aggregates for all possible combinations of the number of participants.
Which Transact-SQL statement should you run?

A. SELECT CourseID, CourseDate, SUM(NumParticipants) FROM CourseParticipants GROUP BY CourseID, CourseDate
B. SELECT CourseID, CourseDate, SUM(DISTINCT NumParticipants) FROM CourseParticipants GROUP BY CourseID, CourseDate
C. SELECT CourseID, CourseDate, SUM(NumParticipants) FROM CourseParticipants GROUP BY CourseID, CourseDate WITH CUBE
D. SELECT CourseID, CourseDate, SUM(DISTINCT NumParticipants) FROM CourseParticipants GROUP BY CourseID, CourseDate WITH ROLLUP

Show Suggested Answer

Suggested Answer: C 🗳️
The WITH CUBE clause causes the query to compute all possible totals
References:
https://blogs.msdn.microsoft.com/craigfr/2007/09/27/aggregation-with-cube/

by lh2607 at Dec. 15, 2020, 7:51 p.m.

Comments

Submit Cancel

lh2607

4 years, 4 months ago

Correctimundo

upvoted 3 times

...

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 198 discussion

Comments

lh2607

SY0-701