nerdexam
MicrosoftMicrosoft

DP-600 · Question #88

DP-600 Question #88: Real Exam Question with Answer & Explanation

The correct answer is B: descriptive. Creating visualizations that show the distribution of retained vs. churned customers across geography, product count, age, and tenure is descriptive analytics. Descriptive analytics answers 'what happened' by summarizing and presenting historical data in an understandable form. C

Submitted by rania.sa· Apr 18, 2026Explore and analyze data

Question

You have a Fabric tenant that contains customer churn data stored as Parquet files in OneLake. The data contains details about customer demographics and product usage. You create a Fabric notebook to read the data into a Spark DataFrame. You then create column charts in the notebook that show the distribution of retained customers as compared to lost customers based on geography, the number of products purchased, age, and customer tenure. Which type of analytics are you performing?

Options

  • Adiagnostic
  • Bdescriptive
  • Cprescriptive
  • Dpredictive

Explanation

Creating visualizations that show the distribution of retained vs. churned customers across geography, product count, age, and tenure is descriptive analytics. Descriptive analytics answers 'what happened' by summarizing and presenting historical data in an understandable form. Column charts showing distribution across dimensions are a hallmark of descriptive analysis. This work does NOT qualify as diagnostic (no root cause investigation), predictive (no model forecasting future churn), or prescriptive (no recommendations for action). The goal here is simply to understand and describe the existing churn patterns in the data.

Topics

#Types of analytics#Descriptive analytics#Data exploration#Data visualization

Community Discussion

No community discussion yet for this question.

Full DP-600 PracticeBrowse All DP-600 Questions