Snowflake Quiz — Intermediate SQL & Semi-Structured Data

1. How do you create a CTE (Common Table Expression) in Snowflake?

2. Which SQL function is used to flatten a VARIANT/JSON array in Snowflake?

3. How do you query a nested JSON field customer.name stored in VARIANT column data?

4. How do you calculate a running total using a window function?

5. How do you get the top 3 highest sales per region using window functions?

6. How do you query a Parquet file stored in a stage in Snowflake?

7. How do you extract all values from a JSON array stored in VARIANT column data.items?

8. How do you create an external stage in Snowflake?

9. How do you extract the month from a DATE column order_date?

10. How do you merge new data into an existing table in Snowflake?