Microsoft Exam DP-500 Topic 9 Question 46 Discussion

Actual exam question for Microsoft's DP-500 exam

Question #: 46
Topic #: 9

You have an Azure Synapse Analytics notebook.

You run the xxsq1 magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.

display (df1, summary = true)

Which three attributes will be returned by the command? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Atype

Brange

Cmissing

Dunique

Eordinal

Show Suggested Answer

Suggested Answer: A, C, D

by Latonia at Jul 15, 2024, 05:01 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Selma

4 months ago

That's a good point, unique could also be one of the attributes returned.

upvoted 0 times

...

Madalyn

4 months ago

I'm not sure about missing, I think it might be unique instead.

upvoted 0 times

...

Glendora

4 months ago

Hah, leave it to the Azure experts to make a simple data display command so complicated. Next they'll be asking us to write Spark SQL queries in our sleep.

upvoted 0 times

Paola

4 months ago

C) missing

upvoted 0 times

...

Ivette

4 months ago

B) range

upvoted 0 times

...

Tiera

4 months ago

A) type

upvoted 0 times

...

Reid

5 months ago

Hold up, are we sure about that? I thought display() only gave you the column names, data types, and maybe the first few rows. Where are you getting all these advanced stats from?

upvoted 0 times

...

Lewis

5 months ago

I agree with Selma, those attributes make sense for a summary display.

upvoted 0 times

...

Felix

5 months ago

I'm pretty sure B and E are also part of the answer. You need to know the range and ordinal nature of the data to fully understand the DataFrame.

upvoted 0 times

...

Selma

5 months ago

I think the attributes returned will be type, range, and missing.

upvoted 0 times

...

Leandro

5 months ago

C, D, and missing are definitely the right attributes. The display() function in Synapse Analytics gives you the summary statistics including missing values and unique values.

upvoted 0 times

Alaine

4 months ago

That's correct, the summary option in display() gives you those attributes.

upvoted 0 times

...

Toi

4 months ago

Yes, the display() function provides summary statistics like missing and unique values.

upvoted 0 times

...

Xuan

4 months ago

I agree, C, D, and missing are the attributes returned by the command.

upvoted 0 times

...