BenchMark Quizzes by MDFT Pro

Evaluate Statistical Measures in Fabric

You work for MDFT Pro, a well-known training agency that uses Microsoft Fabric for data analysis. You have a Fabric tenant that contains business data in OneLake.

You use a Fabric notebook to read the data into a Spark DataFrame. You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the numeric columns.

Solution: You use the following PySpark expression:

df.explain().show()

Does this meet the goal?

Choose the correct answer from the options below.

Explanations for each answer:

Yes is incorrect. The explain().show() method is used to display the execution plan of a DataFrame operation, showing how Spark will process the data. It does not calculate any statistical measures like min, max, mean, or standard deviation. To calculate these statistics, you should use the describe() function instead, which automatically computes count, mean, standard deviation, min, and max values for all numeric columns in the DataFrame.
No is correct.

Learn more about the describe function:

DataFrame Describe

Exam Preparation Quiz

Evaluate Statistical Measures in Fabric