Which of the following is a common method for detecting anomalies in a dataset?

Sorting the data in descending order

Using a z-score threshold to flag values that are far from the mean

Counting the number of rows in the table

Calculating the mean of the dataset

A subscription service wants to understand how user retention varies by the month in which users first subscribed. The data includes user_id, signup_date, and activity dates. Which analysis approach would best reveal this?

Create a pivot table of signup month versus total revenue.

Calculate the average number of logins per user overall.

Perform a cohort analysis grouping users by signup month and tracking their activity over subsequent months.

Compute the correlation between signup date and total logins.

In cohort analysis, what defines a cohort?

All users who have ever made a purchase

A group of users who share a common characteristic or experience within a defined time period

A data analyst is monitoring daily website traffic. The mean daily visits is 10,000 with a standard deviation of 1,000. On a holiday, visits drop to 5,000. What is the most appropriate action?

Compare the holiday traffic to the same holiday last year before deciding if it is an anomaly.

Ignore the drop as it is just a holiday effect.

Treat the drop as an anomaly and investigate for a technical issue.

Adjust the mean and standard deviation to exclude holiday data.

What is the primary purpose of data visualization in the data analysis process?

To store data in a visual format

To make the data look attractive

To replace the need for statistical analysis

To communicate insights effectively and support decision-making

Snowflake SnowPro Advanced:Data Analyst

Domain 1Objective 3

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

Part of the Data Analysis domain, which accounts for 32% of the SNOWPRO-ADVANCED-DATA-ANALYST exam.

33questions here

7free pages

10concepts

32%of the exam

Questions 21–25

21foundation · easy
Which of the following is a common method for detecting anomalies in a dataset?
Select an answer first
22application · medium
A subscription service wants to understand how user retention varies by the month in which users first subscribed. The data includes user_id, signup_date, and activity dates. Which analysis approach would best reveal this?
Select an answer first
23foundation · easy
In cohort analysis, what defines a cohort?
Select an answer first
24expert · hard
A data analyst is monitoring daily website traffic. The mean daily visits is 10,000 with a standard deviation of 1,000. On a holiday, visits drop to 5,000. What is the most appropriate action?
Select an answer first
25foundation · easy
What is the primary purpose of data visualization in the data analysis process?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-DATA-ANALYST

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-DATA-ANALYST” is a trademark of its owner, used for identification only.