Exam DP-500 topic 1 question 26 discussion

Actual exam question from Microsoft's DP-500

Question #: 26
Topic #: 1

You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data.
You need to review statistics for a DataFrame that includes:

The column name -

The column type -

The number of distinct values -
Whether the column has missing values
Which function should you use?

A. displayHTML()
B. display(df, summary=true)
C. %%configure
D. display(df)
E. %%lsmagic

Show Suggested Answer

Suggested Answer: B 🗳️

by AT96 at Dec. 10, 2022, 10:04 a.m.

Comments

Submit Cancel

AT96

Highly Voted 2 years, 6 months ago

Correct answer

upvoted 7 times

Maazi

2 years, 6 months ago

True, B is correct Ref: https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization

upvoted 5 times

...

metiii

Most Recent 1 year, 7 months ago

Selected Answer: B

Today I took this exam and there was a question with some similarities to this one. The question was something like this: What information does this function give us: display(df, summary=true)? There were 6 choices and we had to choose three, these are the correct answers: Type, Missing & Unique The only other thing that this function gives us is the column's name. https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization#displaydf-summary-view

upvoted 3 times

...

orionduo

1 year, 10 months ago

Correct answer. You can use display(df, summary = true) to check the statistics summary of a given Apache Spark DataFrame that include the column name, column type, unique values, and missing values for each column. You can also select on specific column to see its minimum value, maximum value, mean value and standard deviation.

upvoted 1 times

...

Tranter

2 years, 1 month ago

i retract my previous answer sns.pairplot(iris, hue="species")

upvoted 1 times

...

DarioReymago

2 years, 2 months ago

Selected Answer: B

B Correct answer

upvoted 2 times

...