A data scientist is analyzing website traffic data stored in Snowflake. The data includes daily page views for different pages. The data scientist suspects that the variance of page views for a particular page, 'home', has significantly increased recently. Which of the following steps and Snowflake SQL queries could be used to identify a potential change in the variance of 'home' page views over time (e.g., comparing variance before and after a specific date)? Select all that apply.

Correct Answer: B,C,D,E
Options B, C, D and E are correct. Option B directly compares the variance before and after a date, allowing for a direct assessment of change. Option C uses a window function for a rolling variance calculation, revealing trends over time. Option D creates a histogram, which helps visualize the distribution and identify shifts in spread. Option E calculates standard deviation before and after a date. Option A, while calculating the overall variance, doesn't provide insight into changes over time.