DP-500 Practice Test

DP-500 Practice Test practice questions, page 6 of 8, with answer review and explanations.

Question 26

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?

  1. displayHTML()
  2. display(df, summary=true)
  3. %%configure
  4. display(df)
  5. %%lsmagic

Question 27

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.

Question 28

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

Question 29

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.

Question 30

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.