MENU
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?
Suggested Answer: B
Get Premium DP-600 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
30 comments · newest first
SA
Sanda
11 months ago
Seems too simple, I doubt it meets the goal.
GE
Gertude
11 months ago
I agree, you need more than just show() for those calculations.
LA
Latonia
11 months ago
Wait, does df.show() even calculate anything?
LA
Launa
12 months ago
Definitely a no, you need aggregation functions for that.
SA
Salome
12 months ago
That just shows the DataFrame, not the stats.
AD
Adell
1 year ago
I might be confused, but I feel like df.show() is more for visualization. We probably need to apply some functions to get min, max, mean, and standard deviation.
RO
Rosamond
1 year ago
I practiced a similar question where we had to compute statistics, and I recall that just showing the DataFrame wouldn't suffice. I would say No.
HA
Hannah
1 year ago
I'm not entirely sure, but I remember we need to use functions like describe() or agg() to get those stats. df.show() seems too basic for this.
GL
Glennis
1 year ago
I think using df.show() just displays the DataFrame, but it doesn't calculate any statistics. So, I'm leaning towards No.
FR
Francine
1 year ago
Hmm, I'm a bit unsure about this one. The question says the solution is to use `df.show()`, but that doesn't sound right. I'll double-check the PySpark documentation to make sure I'm understanding the correct approach for calculating those statistics. Better to be sure I'm on the right track.
RA
Ranee
1 year ago
Okay, I think I've got this. The `df.show()` command won't meet the goal since it just prints the data, not the statistical analysis. I'll need to use functions like `df.agg()` to calculate the min, max, mean, and standard deviation for each column. That should do the trick.
TR
Truman
1 year ago
I'm a bit confused here. Doesn't the question ask us to evaluate the data and calculate those statistics? The `df.show()` command just displays the data, it doesn't actually perform any calculations. I'll need to look into the PySpark functions for computing those metrics.
ST
Stefany
1 year ago
Hmm, this looks like a straightforward data analysis task. I think I can handle this - I'll just use the `df.show()` command to display the data and then calculate the min, max, mean, and standard deviation for each column.
JO
Jovita
1 year ago
Azure SQL Database is definitely the right choice here. It's a fully managed service that handles all the maintenance and updates for you.
MO
Mozelle
1 year ago
I'm not totally confident, but I feel like development is more of a bottom-up task… or is it?
VE
Veronika
1 year ago
I practiced something similar, and lost sales data being untracked seems like a big issue too. Is D worth considering?
JA
Janine
2 years 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.
LU
Lucina
2 years ago
Yeah, we definitely need a different approach for this.
CL
Claudio
2 years ago
I agree, df.show() won't give us the stats we need.
MY
My
2 years 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.
JA
Jame
2 years 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?
RI
Rima
2 years 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.
MI
Mitsue
2 years 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?
LE
Leatha
2 years ago
B) No
CO
Colene
2 years ago
B) No
SH
Shizue
2 years ago
A) Yes
RO
Rolland
2 years ago
I agree with Regenia. We should use appropriate functions to calculate the statistics.
ST
Stevie
2 years ago
But df.show() will only display the data, not calculate the statistics.
RE
Regenia
2 years ago
I disagree. We need to use functions like min, max, mean, and stddev.
ST
Stevie
2 years ago
I think the solution is correct.