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

Questions 6–10

1. 6expert · hard

   A data analyst is profiling a large dataset and notices that a numeric column has 15% null values and a few extreme outliers. The analyst needs to decide how to handle these issues before analysis. Which approach is most appropriate?

   • ALeave the data as is and proceed with analysis.
   • BImpute null values with the mean and cap outliers at the 99th percentile.
   • CRemove all rows with null values and outliers to ensure a clean dataset.
   • DInvestigate the nulls and outliers to understand their cause before deciding on a treatment.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which window function in Snowflake assigns a unique sequential integer to each row within a partition, starting at 1 for the first row in each partition?

   • ANTILE()
   • BDENSE_RANK()
   • CROW_NUMBER()
   • DRANK()
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A logistics company observes a sudden 20% drop in delivery success rates over the past week. The analyst needs to determine if this is a real trend or an anomaly. Which approach should the analyst take?

   • ACalculate the mean success rate for the past year and compare it to the current week.
   • BUse a control chart to see if the drop exceeds expected variation.
   • CCompare the current week's success rate to the same week last year.
   • DImmediately investigate all failed deliveries to find the cause.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   After analyzing customer churn data, an analyst finds that customers who do not use a feature within the first week are 3 times more likely to churn. What is the most actionable recommendation?

   • ARecommend that the company discontinue the feature.
   • BAdvise the company to ignore the finding as it is not actionable.
   • CSuggest that the company increase the price of the product.
   • DSend a targeted onboarding email encouraging new users to try the feature within the first week.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A product team claims that a new website layout increases average session duration. The analyst has session duration data from before and after the change. What statistical method should the analyst use to validate this claim?

   • APerform a two-sample t-test to compare the means of the two groups.
   • BCompute the correlation between layout change and session duration.
   • CCalculate the mean session duration for both periods and compare them visually.
   • DUse a time-series decomposition to identify the effect of the layout change.
   Reveal Solution Discussion Select an answer first