SnowPro Core Certification — Question 741

What are valid sub-clauses to the OVER clause for a window function? (Choose two.)

Answer options

• A. GROUP BY
• B. LIMIT
• C. ORDER BY
• D. PARTITION BY
• E. UNION ALL

Correct answer: C, D

Explanation

The correct answers are C and D because 'ORDER BY' is used to define the order of rows within the partition, and 'PARTITION BY' divides the result set into partitions to which the window function is applied. The other options, such as 'GROUP BY', 'LIMIT', and 'UNION ALL', are not compatible with the OVER clause for window functions.