DP-600 Practice Test

DP-600 Practice Test practice questions, page 4 of 9, with answer review and explanations.

Question 16

You are analyzing the data in a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. You need to use the Chart view in the notebook to explore the data manually. Which function should you run to make the data available in the Chart view?

  1. displayHTML
  2. show
  3. write
  4. display

Question 17

You have a Fabric tenant that contains a Microsoft Power BI report named Report1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?

  1. Reference the columns in the Python code by index.
  2. Modify the Sort Column By property for all columns.
  3. Add a unique field to each row.
  4. Modify the Summarize By property for all columns.

Question 18

You have a Fabric tenant that contains a semantic model. The model contains data about retail stores. You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return a table of stores that have opened since December 1, 2023. How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Question 19

You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows. You view the query in Power Query as shown in the following exhibit. What can you identify about the pickupLongitude column?

  1. The column has duplicate values.
  2. All the table rows are profiled.
  3. The column has missing values.
  4. There are 935 values that occur only once.

Question 20

You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dataset named DS1. You need to ensure read-write access to DS1 is available by using XMLA endpoint. What should be modified first?

  1. the DS1 settings
  2. the WS1 settings
  3. the C1 settings
  4. the Tenant1 settings