DP-700 Named Practice Questions

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table. The table contains the following columns. You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct. You need to prepare the data. Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Select 3 answers.

• AA. Date
• BB. ProductName
• CC. ProductColor
• DD. TransactionID
• EE. SalesAmount
• FF. ProductID

You have three users named User1, User2, and User3. You have the Fabric workspaces shown in the following table. You have a security group named Group1 that contains User1 and User3. The Fabric admin creates the domains shown in the following table. User1 creates a new workspace named Workspace3. You add Group1 to the default domain of Domain1. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Answer Yes or No for each statement in the exhibit.

Correct answer: Yes; No; No

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse! contains a table named Customer. Customer contains the following data. You have an internal Microsoft Entra user named User1 that has an email address of user1@contoso.com. You need to provide User1 with access to the Customer table. The solution must prevent User1 from accessing the CreditCard column. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Match each item to its target.

Correct answer: GRANT = SELECT; TO = [user1@contoso.com]