FROM carts GROUP BY cartId

FROM carts GROUP BY cartId

Expected result:

cartId items

1 [1,100,200,300,250]
A . FLATTEN, COLLECT_UNION
B. ARRAY_UNION, FLATTEN
C. ARRAY_UNION, ARRAY_DISTINT
D. ARRAY_UNION, COLLECT_SET
E. ARRAY_DISTINCT, ARRAY_UNION

View Answer

Answer: D

Explanation:

COLLECT SET is a kind of aggregate function that combines a column value from all rows into a unique list ARRAY_UNION combines and removes any duplicates,

Graphical user

interface, application

Description automatically generated with medium confidence