nerdexam
Microsoft

DP-500 · Question #93

You are assigned to explore data by using Azure Synapse Analytics. You have decided to use Synapse Spark notebook to explore the data. You can read the data using Spark's Dataframe API or SQL API…

The correct answer is C. By switching from Table view to Chart view in the cells output pane. Azure Synapse Spark notebooks include a built-in Chart view toggle in the cell output pane that visualizes tabular results instantly without any additional code.

Explore and visualize data

Question

You are assigned to explore data by using Azure Synapse Analytics. You have decided to use Synapse Spark notebook to explore the data. You can read the data using Spark's Dataframe API or SQL API into Spark Cluster's memory. Data is displayed in a tabular format as an output. As the number of rows returned is very high, you want to visualize the data within Spark Notebook itself quickly without any additional line of code. How do you achieve this?

Options

  • ABy using a python library called Matplotlib meant for data visualization
  • BBy using a python library called Seaborn meant for data visualization
  • CBy switching from Table view to Chart view in the cells output pane
  • DBy clicking on Open Spark UI link available below the right side of the cell

How the community answered

(33 responses)
  • B
    3% (1)
  • C
    91% (30)
  • D
    6% (2)

Why each option

Azure Synapse Spark notebooks include a built-in Chart view toggle in the cell output pane that visualizes tabular results instantly without any additional code.

ABy using a python library called Matplotlib meant for data visualization

Matplotlib requires writing additional Python code to create plot objects and render them, which contradicts the requirement for no additional lines of code.

BBy using a python library called Seaborn meant for data visualization

Seaborn also requires writing additional Python code and depends on Matplotlib as a backend, violating the no-additional-code requirement.

CBy switching from Table view to Chart view in the cells output paneCorrect

Within the output area of each Synapse Spark notebook cell, a toolbar allows users to switch from the default Table view to Chart view. This built-in visualization renders the DataFrame or SQL result as a configurable chart - bar, line, scatter, etc. - without requiring any additional code, library imports, or configuration, directly satisfying the stated requirement.

DBy clicking on Open Spark UI link available below the right side of the cell

The Open Spark UI link launches the Apache Spark cluster monitoring and job execution interface, not a data visualization view of cell output.

Concept tested: Built-in chart view in Azure Synapse Spark notebooks

Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-development-using-notebooks

Topics

#Azure Synapse Analytics#Spark Notebook#Data Visualization#Notebook UI

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice