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

Questions 26–30

1. 26foundation · easy

   Which Snowflake function computes the median of a numeric column?

   • APERCENTILE_CONT(0.5)
   • BMODE
   • CAVG
   • DMEDIAN
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   What does a p-value represent in hypothesis testing?

   • AThe probability of observing the data, or something more extreme, assuming the null hypothesis is true
   • BThe probability that the null hypothesis is true
   • CThe probability of making a Type I error
   • DThe probability that the alternative hypothesis is true
   Reveal Solution Discussion Select an answer first
4. 28expert · hard

   A telecom company finds that customers who contact support more than 3 times in a month have a 50% higher churn rate. What is the most actionable recommendation?

   • AProactively reach out to customers who exceed 3 support contacts in a month to address their issues.
   • BIncrease prices for customers who contact support frequently.
   • CReduce the number of support contacts allowed per month.
   • DIgnore the finding as it is just correlation.
   Reveal Solution Discussion Select an answer first
5. 29expert · hard

   An analyst needs to present a complex analysis of sales trends across multiple regions and product lines to a non-technical executive. The goal is to highlight which regions are underperforming. Which visualization approach is most effective?

   • AA line chart for each region showing sales over time.
   • BA bar chart comparing total sales by region, with underperforming regions highlighted.
   • CA heatmap with regions on one axis and time on the other, colored by sales performance.
   • DA scatter plot of sales versus profit for each region.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A data analyst at a retail company receives a new dataset containing daily sales transactions. Before performing any analysis, the analyst wants to understand the data's structure and quality. Which initial step should the analyst take?

   • AExecute a data profiling query to examine data types, null values, distinct counts, and value distributions.
   • BRun a query to compute the mean and median of the sales amount column.
   • CCreate a visualization of sales over time to identify trends.
   • DUse the SUM and COUNT functions to aggregate total sales and number of transactions.
   Reveal Solution Discussion Select an answer first