Derive Insights from Datasets SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 4)

Questions 16–20

1. 16application · medium

   A marketing analyst wants to compare monthly sales performance across different product categories for the past year. The data is stored in a table with columns: sale_date, category, and amount. Which SQL approach would best summarize this data?

   • AUse a window function with PARTITION BY category and ORDER BY sale_date to compute running totals.
   • BUse GROUP BY on category and sale_date, then compute SUM(amount).
   • CUse GROUP BY category, DATE_TRUNC('month', sale_date) and compute SUM(amount).
   • DUse a pivot query to transform categories into columns and months into rows.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which statistical measure is most sensitive to extreme values (outliers) in a dataset?

   • AMedian
   • BStandard deviation
   • CMode
   • DMean
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   What is the key characteristic of an actionable recommendation?

   • AIt is based on personal opinion
   • BIt is vague and general to apply to many situations
   • CIt is only applicable to technical audiences
   • DIt is specific, measurable, and tied to a business decision
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which statistical measure quantifies the strength and direction of a linear relationship between two variables?

   • ACorrelation coefficient
   • BStandard deviation
   • CVariance
   • DMean
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   What is a cross-tabulation (crosstab) used for in data analysis?

   • ATo compute the mean of a numeric variable
   • BTo identify outliers in a dataset
   • CTo summarize the relationship between two categorical variables
   • DTo sort data by a numeric column
   Reveal Solution Discussion Select an answer first