You are a database developer. You plan to design a database solution by using SQL Server
2008. The database includes a table that contains the following product inventory
information: ·Department ·Class ·Item ·Quantity You plan to write a query that produces the
sum of quantity data broken into the following groups. ·Department ·Department and Class
·Department and Item ·Department, Class, and Item You need to write the query by using
the minimum possible number of Transact-SQL statements. What should you recommend?

A.
Write a single query that contains a GROUP BY clause.

B.
Write a single query that contains a GROUP BY WITH CUBE clause.

C.
Write a single query that contains a GROUP BY WITH ROLLUP clause.

D.
Write a single query that contains a GROUP BY GROUPING SETS clause.