Microsoft Exam DP-600 Topic 3 Question 17 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 17
Topic #: 3

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.show()

Does this meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: B

The df.show() method also does not meet the goal. It is used to show the contents of the DataFrame, not to compute statistical functions. Reference = The usage of the show() function is documented in the PySpark API documentation.

by Jules at Jul 11, 2024, 02:21 PM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Janine

9 months ago

I'm sorry, but df.show() is not going to give us the statistical analysis we need. I think the correct answer is 'No' on this one. Let's move on to the next question, where we can hopefully find a more challenging problem to solve.

upvoted 0 times

Lucina

8 months ago

Yeah, we definitely need a different approach for this.

upvoted 0 times

...

Claudio

8 months ago

I agree, df.show() won't give us the stats we need.

upvoted 0 times

...

My

9 months ago

Haha, I've seen some lazy solutions in my day, but this takes the cake. df.show()? Really? I bet the answer is 'No' on this one.

upvoted 0 times

...

Jame

9 months ago

Nah, this isn't going to cut it. We need to dig deeper into the Spark DataFrame API to get the job done. What is this, PySpark for Dummies?

upvoted 0 times

...

Rima

9 months ago

Hmm, df.show() just prints the first few rows of the DataFrame. It doesn't actually calculate any statistical measures. I think we need to use functions like min(), max(), mean(), and stddev() to get the job done.

upvoted 0 times

...

Mitsue

9 months ago

Wow, that's a pretty basic solution. I'm not sure it's going to give us the full analysis we need. Where are the min, max, mean, and standard deviation calculations?

upvoted 0 times