Free Access Microsoft.DP-500.v2024-06-18.q131 Practice Test (Page 24)

Question 111

You have the Power BI workspaces shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Question 112

You have the Power BI workspaces shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Question 113

You need to populate the CustomersWithProductScore table.
How should you complete the stored procedure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 114

You have a Power Bl dataset that contains the following measure.

You need to improve the performance of the measure without affecting the logic or the results. What should you do?

A.Replace both calculate functions by using a variable that contains the calculate function.

B.Create a variable and replace the values for [sales Amount].

C.Remove the alternative result of blank( ) from the divide function.

D.Remove "calendar'[Flag] = "YTD" from the code.

Question 115

You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as
shown in the following exhibit.