Perform Data Analysis with SQL SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 1)

Questions 1–3

1. 1foundation · easy

   Which SQL clause is used to filter groups after an aggregation has been performed?

   • AGROUP BY
   • BHAVING
   • CWHERE
   • DORDER BY
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A marketing analyst needs to find the first purchase date for each customer from the PURCHASES table (CUSTOMER_ID, PURCHASE_DATE). The analyst also needs to know how many days elapsed between each customer's first and second purchase. Which query correctly computes this?

   • ASELECT CUSTOMER_ID, PURCHASE_DATE AS FIRST_PURCHASE, LEAD(PURCHASE_DATE) OVER (PARTITION BY CUSTOMER_ID ORDER BY PURCHASE_DATE) AS SECOND_PURCHASE, DATEDIFF('day', PURCHASE_DATE, LEAD(PURCHASE_DATE) OVER (PARTITION BY CUSTOMER_ID ORDER BY PURCHASE_DATE)) AS DAYS_BETWEEN FROM PURCHASES QUALIFY ROW_NUMBER() OVER (PARTITION BY CUSTOMER_ID ORDER BY PURCHASE_DATE) = 1;
   • BSELECT CUSTOMER_ID, MIN(PURCHASE_DATE) AS FIRST_PURCHASE, DATEDIFF('day', MIN(PURCHASE_DATE), MAX(PURCHASE_DATE)) AS DAYS_BETWEEN FROM PURCHASES GROUP BY CUSTOMER_ID;
   • CSELECT CUSTOMER_ID, MIN(PURCHASE_DATE) AS FIRST_PURCHASE, DATEDIFF('day', MIN(PURCHASE_DATE), LAG(PURCHASE_DATE) OVER (PARTITION BY CUSTOMER_ID ORDER BY PURCHASE_DATE)) AS DAYS_BETWEEN FROM PURCHASES GROUP BY CUSTOMER_ID;
   • DSELECT CUSTOMER_ID, MIN(PURCHASE_DATE) AS FIRST_PURCHASE, DATEDIFF('day', MIN(PURCHASE_DATE), NTH_VALUE(PURCHASE_DATE, 2) OVER (PARTITION BY CUSTOMER_ID ORDER BY PURCHASE_DATE)) AS DAYS_BETWEEN FROM PURCHASES GROUP BY CUSTOMER_ID;
   Reveal Solution Discussion Select an answer first
3. 3foundation · easy

   Which SQL function is used to transform a string to all uppercase characters?

   • ALOWER
   • BUPPER
   • CTRIM
   • DLENGTH
   Reveal Solution Discussion Select an answer first