Peter is a Data Engineer for Adatum Corporation. He is working on implementing tables on dedicatedSQL pools of Azure Synapse with T-SQL queries. He needs to use the GROUP BY clause for aggregating data to a summary set of rows. 
Which of the following three GROUP BY options are supported in the dedicated SQL pool of Azure Synapse?

Answer options:

A.GROUP BY with Hashing
B.GROUP BY with ROLLUP
C.GROUP BY with Replication
D.GROUPING SETS
E.GROUP BY with CUBE

Correct Answers: B, D and E 
Serverless SQL pool doesn’t support the GROUP BY options. The Dedicated SQL pool has limited options for supporting GROUP BY clause.
Option A is incorrect because there’s no such option for GROUP BY clause in a dedicated SQL pool as GROUP BY with hashing.
Option B is correct because with the UNION ALL the Rollup can be executed for GROUP BY rather than explicit usage of syntax.
For example: the following GROUP BY Statement can be executed with the ROLLUP option 

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-group-by-options