Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 138

You have an Azure Synapse Analytics notebook.

You run the %%sql 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.

Answer options

• A. type
• B. range
• C. missing
• D. unique
• E. ordinal

Correct answer: A, C, D

Explanation

The command display(df1, summary = true) provides essential statistics about the DataFrame. The attributes type, missing, and unique give insights into the data types and data characteristics, while range and ordinal are not part of the summary output in this context.