2.1 Identify Data Trends, Patterns, and Insights by Using BigQuery and Jupyter Notebooks ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 3)

Questions 11–13

1. 11application · medium

   A subscription service wants to understand why some customers cancel within the first month. They have a BigQuery table with signup_date, cancel_date, and plan_type. An analyst needs to identify the most effective way to analyze this data to find patterns. Which approach should they take?

   • ACreate a new column indicating whether the customer canceled within 30 days, then compare the proportion of early cancellations across plan types.
   • BCalculate the average time to cancellation for each plan type and plot it as a bar chart.
   • CQuery the total number of cancellations and the total number of signups, then compute the overall cancellation rate.
   • DPlot a histogram of cancel_date for all customers.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data scientist is analyzing customer churn data in a Jupyter notebook. They have a pandas DataFrame with columns: customer_id, churn (boolean), and monthly_charges. They want to visualize the distribution of monthly charges for churned vs. non-churned customers to spot patterns. Which visualization should they create?

   • AA line chart with monthly_charges on the x-axis and churn on the y-axis.
   • BA histogram of monthly_charges, with one histogram for churned customers and one for non-churned customers, overlaid or side-by-side.
   • CA scatter plot with monthly_charges on the x-axis and customer_id on the y-axis, colored by churn.
   • DA bar chart with the average monthly_charges for churned and non-churned customers.
   Reveal Solution Discussion Select an answer first
3. 13application · medium

   A data analyst is exploring a dataset of customer reviews with a sentiment score (ranging from -1 to 1) and a review length (number of characters). They want to see if there is a relationship between review length and sentiment. Which visualization should they create?

   • AA scatter plot with review length on the x-axis and sentiment score on the y-axis.
   • BA bar chart with review length on the x-axis and average sentiment on the y-axis.
   • CA line chart with sentiment score on the x-axis and review length on the y-axis.
   • DA histogram of sentiment scores.
   Reveal Solution Discussion Select an answer first