Free DP-500 Exam Braindumps (page: 10)

Page 10 of 46

HOTSPOT (Drag and Drop is not supported)
You are using an Azure Synapse notebook to create a Python visual.

You run the following code cell to import a dataset named Iris.



A sample of the data is shown in the following table.



You need to create the visual shown in the exhibit. (Click the Exhibit tab.)



How should you complete the Python code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: pairplot
A pairs plot allows us to see both distribution of single variables and relationships between two variables. Pair plots are a great method to identify trends for follow-up analysis and, fortunately, are easily implemented in Python!

Example, let’s plot data using pairplot:
From the picture below, we can observe the variations in each plot. The plots are in matrix format where the row name represents x axis and column name represents the y axis. The main-diagonal subplots are the univariate histograms (distributions) for each attribute.



Box 2: sepal_width
sepal_width is displayed with a height of 2.5 (between 2.0 and 4.5).

Incorrect:
Not boxplot: In descriptive statistics, a box plot or boxplot is a method for graphically demonstrating the locality, spread and skewness groups of numerical data through their quartiles. In addition to the box on a box plot, there can be lines (which are called whiskers) extending from the box indicating variability outside the upper and lower quartiles.


Reference:

https://medium.com/analytics-vidhya/pairplot-visualization-16325cd725e6



You are creating a Power BI single-page report.

Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.

You need to ensure that the users can consume content on a report page in a logical order.

What should you configure on the report page?

  1. the X position
  2. the bookmark order
  3. the layer order
  4. the tab order

Answer(s): D

Explanation:

Tab order is the order in which users interact with the items on a page using the keyboard. Generally, we want tab order to be predictable and to closely match the visual order on the page (unless there is a good reason to deviate).

Note: If you are using the keyboard to navigate in a Power BI report, the order in which you arrive at visuals will not follow your vision unless you set the new tab order property. If you have low or no vision, this becomes an even bigger issue because you may not be able to see that you are navigating visuals out of visual order because the screen reader just reads whatever comes next.


Reference:

https://datasavvy.me/2018/12/26/tab-order-enhances-power-bi-report-accessibility/



HOTSPOT (Drag and Drop is not supported)
You have an Azure Synapse workspace named Workspace1.

You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five rows.

How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: sqlanalytics
Read from a SQL Pool table with Spark
// Read the table we just created in the sql pool as a Spark dataframe
val spark_read = spark.read.
sqlanalytics(s"$sql_pool_name.dbo.PublicHoliday")
spark_read.show(5, truncate = false)

Box 2: spark_read.show
Sample output:


Reference:

https://github.com/Azure-Samples/Synapse/blob/main/Notebooks/Scala/03%20Read%20and%20write%20from%20SQL%20pool%20table.ipynb



You have a Power BI report that contains the table shown in the following exhibit.



The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns.

You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.

What should you do?

  1. Add alt text to explain the information that each color conveys.
  2. Change the icons to use a different shape for each color.
  3. Move the conditional formatting icons to a tooltip report.
  4. Remove the icons and use red, yellow, and green background colors instead.

Answer(s): A

Explanation:

Report accessibility checklist, All Visuals.
* Ensure alt text is added to all non-decorative visuals on the page.
* Avoid using color as the only means of conveying information. Use text or icons to supplement or replace the color.
* Check that your report page works for users with color vision deficiency.
* Etc.

Incorrect:
Not D: Themes, contrast and colorblind-friendly colors
You should ensure that your reports have enough contrast between text and any background colors.
Certain color combinations are particularly difficult for users with color vision deficiencies to distinguish. These include the following combinations:

green and red
green and brown
blue and purple
green and blue
light green and yellow
blue and grey
green and grey
green and black

Avoid using these colors together in a chart, or on the same report page.


Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-creating-reports



Page 10 of 46



Post your Comments and Discuss Microsoft DP-500 exam with other Community members:

Summer commented on July 28, 2024
Wonderful site. It helped me pass my exam. Way to go guys!
UNITED STATES
upvote

Siyya commented on January 19, 2024
might help me to prepare for the exam
Anonymous
upvote

Siyya commented on January 19, 2024
might help me to prepare for the exam
Anonymous
upvote

siyaa commented on January 19, 2024
helped me understand the material better.
Anonymous
upvote

Bunny commented on June 19, 2023
Good Content
Anonymous
upvote

Demetrius commented on June 01, 2023
Important and useful
Anonymous
upvote

Kartoos commented on April 06, 2023
The practice exam was an important part of my preparation and helped me understand the material better.
FRANCE
upvote