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

Questions 11–15

1. 11foundation · easy

   Which of the following is a primary purpose of data profiling in the data analysis workflow?

   • ATo enforce data quality rules automatically
   • BTo create visualizations for stakeholders
   • CTo understand the structure, quality, and distributions of a dataset before analysis
   • DTo replace the need for data cleaning
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data analyst is studying the relationship between advertising spend and website traffic. The analyst calculates a Pearson correlation coefficient of 0.85. What is the most appropriate interpretation?

   • AThere is a strong positive linear relationship between advertising spend and website traffic.
   • BThe relationship is non-linear and cannot be measured by Pearson correlation.
   • CThere is a weak positive relationship between the two variables.
   • DAdvertising spend causes website traffic to increase.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   An e-commerce analyst notices that sales spike every November and dip in January. What analytical technique should the analyst use to confirm this pattern?

   • ACreate a scatter plot of sales versus day of year.
   • BPerform a time-series decomposition to separate trend, seasonality, and residual components.
   • CRun a hypothesis test comparing sales in November to the annual average.
   • DCompute the correlation coefficient between sales and month.
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   An analyst needs to present quarterly sales trends to executives who are not data-savvy. Which visualization would most effectively communicate the trend?

   • AA pie chart showing sales distribution by quarter.
   • BA line chart showing sales over time.
   • CA heatmap of sales by quarter and region.
   • DA scatter plot of sales versus quarter number.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A data analyst is profiling a dataset with a column that has many repeated values and a few unique values. What does this indicate?

   • AThe column contains many null values.
   • BThe column is a continuous numeric variable with high variance.
   • CThe column is a primary key.
   • DThe column is likely a categorical variable with a limited number of categories.
   Reveal Solution Discussion Select an answer first