DP-600 Free Practice Questions — Page 4

Question 31

HOTSPOT - You have a Fabric tenant that contains a workspace named Workspace1 and a user named DBUser. Workspace1 contains a lakehouse named Lakehouse1. DBUser does NOT have access to the tenant. You grant DBUser access to Lakehouse1 as 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 32

HOTSPOT - You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains the following data. You need to create a T-SQL statement that will denormalize the tables and include the ContractType and StartDate attributes in the results. The solution must meet the following requirements: • Include attributes from matching rows in the Contract table. • Ensure that all the rows from the Employee table are preserved. • Return the total number of employees per contract type for all the contract types that have more than two employees. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 33

You plan to use Fabric to store data. You need to create a data store that supports the following: • Writing data by using T-SQL • Multi-table transactions • Dynamic data masking Which type of data store should you create?

Question 34

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 35

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 36

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 37

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 38

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 39

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 40

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.