nerdexam
Microsoft

DP-600 · Question #42

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might h

The correct answer is A. Yes. The df.summary() PySpark expression is suitable for calculating descriptive statistics like min, max, mean, and standard deviation for DataFrame columns.

Submitted by lukas.cz· Apr 18, 2026Explore and analyze data

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Fabric tenant that contains a new semantic model 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 string and numeric columns. Solution: You use the following PySpark expression: df.summary() Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(29 responses)
  • A
    83% (24)
  • B
    17% (5)

Why each option

The `df.summary()` PySpark expression is suitable for calculating descriptive statistics like min, max, mean, and standard deviation for DataFrame columns.

AYesCorrect

The `df.summary()` method computes various summary statistics for numeric columns (count, mean, stddev, min, max) and count for string columns, directly addressing the requirement to evaluate min, max, mean, and standard deviation. It provides a quick overview of the data's distribution across relevant columns.

BNo

The `df.summary()` method is specifically designed and commonly used for computing these types of descriptive statistics, making it an appropriate solution.

Concept tested: PySpark DataFrame descriptive statistics

Source: https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.DataFrame.summary.html

Topics

#PySpark#Spark DataFrame#Data exploration#Descriptive statistics

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice