Snowflake Quiz — Advanced SQL & Semi-Structured Analytics

1. How do you perform a lateral join with a VARIANT column containing JSON arrays?

2. How do you calculate a moving average of sales over 7 days using a window function?

3. How do you pivot rows to columns in Snowflake?

4. How do you merge JSON data from a staging table into a main table?

5. How do you extract multiple nested fields from VARIANT column in a single query?

6. How do you calculate the cumulative sum of sales partitioned by region?

7. How do you filter only the latest record per customer from a historical table?

8. How do you combine multiple JSON arrays from different columns into one?

9. How do you compute percentage contribution of each region's sales to total sales?

10. How do you perform a semi-join to fetch records existing in another table?