DP-600 Free Practice Questions — Page 3

Question 21

HOTSPOT - You are creating a report and a semantic model in Microsoft Power BI Desktop. The Value measure has the expression 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 22

You have a Fabric tenant that contains a semantic model. You need to modify object-level security (OLS) for the model. What should you use?

Question 23

You have a Fabric tenant named Tenant1 that contains a lakehouse named Lakehouse1. You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. The solution must minimize development effort. What should you use to add the data?

Question 24

DRAG DROP - You have a Fabric workspace named Workspace1. You have three groups named Group1, Group2, and Group3. You need to assign a workspace role to each group. The solution must follow the principle of least privilege and meet the following requirements: • Group1 must be able to write data to Workspace1, but be unable to add members to Workspace1. • Group2 must be able to configure and maintain the settings of Workspace1. • Group3 must be able to write data and add members to Workspace1, but be unable to delete Workspace1. Which workspace role should you assign to each group? To answer, drag the appropriate roles to the correct groups. Each role 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 25

You have a Fabric workspace named Workspace1 that is assigned to a newly created Fabric capacity named Capacity1. You create a semantic model named Model1 and deploy Model1 to Workspace1. You need to publish changes to Model1 directly from Tabular Editor. What should you do?

Question 26

You have a Fabric workspace named Workspace1. Workspace1 contains multiple semantic models, including a model named Model1. Model1 is updated by using an XMLA endpoint. You need to increase the speed of the write operations of the XMLA endpoint. What should you do?

Question 27

HOTSPOT - You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns. You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row. How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 28

HOTSPOT - You have a KQL database that contains a table named Readings. You need to query Readings and return the results shown in the following table. How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 29

You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the current month. You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline. Which type of activity should you add?

Question 30

HOTSPOT - You have a Fabric warehouse that contains a table named Table1. Table1 contains the following data. You need to create a T-SQL statement that meets the following requirements: • Outputs the item name of each item and returns a null value if the item name is longer than 20 characters • Outputs the PurchaseDate value in the format of МММ dd, yy How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.