1. What is ROW_NUMBER() ? Junior A. a window function giving a unique sequential number with no ties B. returns all left rows plus matching right rows (NULLs where none match) C. a clause (Snowflake/BigQuery) filtering on a window function without a subquery D. a window function giving ties the same rank but skipping the next rank(s)
2. Which term means: "a window function giving a unique sequential number with no ties"? Junior A. ROW_NUMBER() B. CTE C. WHERE vs HAVING D. LEFT JOIN
3. Which statement is correct? Junior A. ROW_NUMBER() — a window function giving a unique sequential number with no ties B. ROW_NUMBER() — a window function giving ties the same rank with no gaps C. ROW_NUMBER() — a clause (Snowflake/BigQuery) filtering on a window function without a subquery D. ROW_NUMBER() — WHERE filters rows before aggregation; HAVING filters groups after
4. What is RANK() ? Junior A. a named temporary result set defined with WITH for readability/reuse B. wrapping a partition column in a function, which disables pruning C. a window function giving ties the same rank but skipping the next rank(s) D. WHERE filters rows before aggregation; HAVING filters groups after
5. Which term means: "a window function giving ties the same rank but skipping the next rank(s)"? Junior A. LEFT JOIN B. RANK() C. partition pruning defeat D. CTE
6. Which statement is correct? Junior A. RANK() — a window function giving a unique sequential number with no ties B. RANK() — a window function giving ties the same rank with no gaps C. RANK() — a named temporary result set defined with WITH for readability/reuse D. RANK() — a window function giving ties the same rank but skipping the next rank(s)
7. What is DENSE_RANK() ? Junior A. returns all left rows plus matching right rows (NULLs where none match) B. a clause (Snowflake/BigQuery) filtering on a window function without a subquery C. WHERE filters rows before aggregation; HAVING filters groups after D. a window function giving ties the same rank with no gaps
8. Which term means: "a window function giving ties the same rank with no gaps"? Junior A. RANK() B. CTE C. DENSE_RANK() D. LEFT JOIN
9. Which statement is correct? Junior A. DENSE_RANK() — a window function giving a unique sequential number with no ties B. DENSE_RANK() — a window function giving ties the same rank with no gaps C. DENSE_RANK() — a window function giving ties the same rank but skipping the next rank(s) D. DENSE_RANK() — returns all left rows plus matching right rows (NULLs where none match)
10. What is WHERE vs HAVING ? Junior A. wrapping a partition column in a function, which disables pruning B. WHERE filters rows before aggregation; HAVING filters groups after C. a window function giving ties the same rank but skipping the next rank(s) D. a window function giving a unique sequential number with no ties
11. Which term means: "WHERE filters rows before aggregation; HAVING filters groups after"? Junior A. LEFT JOIN B. ROW_NUMBER() C. partition pruning defeat D. WHERE vs HAVING
12. Which statement is correct? Junior A. WHERE vs HAVING — WHERE filters rows before aggregation; HAVING filters groups after B. WHERE vs HAVING — a clause (Snowflake/BigQuery) filtering on a window function without a subquery C. WHERE vs HAVING — a named temporary result set defined with WITH for readability/reuse D. WHERE vs HAVING — a window function giving ties the same rank with no gaps
13. What is QUALIFY ? Mid A. returns all left rows plus matching right rows (NULLs where none match) B. a named temporary result set defined with WITH for readability/reuse C. a window function giving ties the same rank but skipping the next rank(s) D. a clause (Snowflake/BigQuery) filtering on a window function without a subquery
14. Which term means: "a clause (Snowflake/BigQuery) filtering on a window function without a subquery"? Mid A. LEFT JOIN B. QUALIFY C. RANK() D. partition pruning defeat
15. Which statement is correct? Mid A. QUALIFY — a window function giving ties the same rank with no gaps B. QUALIFY — a clause (Snowflake/BigQuery) filtering on a window function without a subquery C. QUALIFY — WHERE filters rows before aggregation; HAVING filters groups after D. QUALIFY — returns all left rows plus matching right rows (NULLs where none match)
16. What is CTE ? Mid A. WHERE filters rows before aggregation; HAVING filters groups after B. wrapping a partition column in a function, which disables pruning C. a window function giving a unique sequential number with no ties D. a named temporary result set defined with WITH for readability/reuse
17. Which term means: "a named temporary result set defined with WITH for readability/reuse"? Mid A. WHERE vs HAVING B. RANK() C. CTE D. partition pruning defeat
18. Which statement is correct? Mid A. CTE — WHERE filters rows before aggregation; HAVING filters groups after B. CTE — a named temporary result set defined with WITH for readability/reuse C. CTE — a window function giving ties the same rank but skipping the next rank(s) D. CTE — wrapping a partition column in a function, which disables pruning
19. What is LEFT JOIN ? Junior A. returns all left rows plus matching right rows (NULLs where none match) B. a window function giving ties the same rank with no gaps C. WHERE filters rows before aggregation; HAVING filters groups after D. a clause (Snowflake/BigQuery) filtering on a window function without a subquery
20. Which term means: "returns all left rows plus matching right rows (NULLs where none match)"? Junior A. DENSE_RANK() B. CTE C. RANK() D. LEFT JOIN
21. Which statement is correct? Junior A. LEFT JOIN — a named temporary result set defined with WITH for readability/reuse B. LEFT JOIN — a window function giving a unique sequential number with no ties C. LEFT JOIN — returns all left rows plus matching right rows (NULLs where none match) D. LEFT JOIN — WHERE filters rows before aggregation; HAVING filters groups after
22. What is partition pruning defeat ? Senior A. WHERE filters rows before aggregation; HAVING filters groups after B. wrapping a partition column in a function, which disables pruning C. a named temporary result set defined with WITH for readability/reuse D. returns all left rows plus matching right rows (NULLs where none match)
23. Which term means: "wrapping a partition column in a function, which disables pruning"? Senior A. CTE B. partition pruning defeat C. ROW_NUMBER() D. WHERE vs HAVING
24. Which statement is correct? Senior A. partition pruning defeat — wrapping a partition column in a function, which disables pruning B. partition pruning defeat — a window function giving ties the same rank with no gaps C. partition pruning defeat — a window function giving a unique sequential number with no ties D. partition pruning defeat — a named temporary result set defined with WITH for readability/reuse