Free Microsoft DP-700 Exam Dumps Questions & Answers

You have a Fabric workspace that contains an eventstream named EventStreaml. EventStreaml outputs events to a table named Tablel in a lakehouse. The streaming data is souiced from motorway sensors and represents the speed of cars.
You need to add a transformation to EventStream1 to average the car speeds. The speeds must be grouped by non-overlapping and contiguous time intervals of one minute. Each event must belong to exactly one window.
Which windowing function should you use?

• A.tumbling
• B.session
• C.sliding
• D.hopping

You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.
A user named User1 wants to use SQL to analyze the data in Lakehouse1.
You need to configure access for User1. The solution must meet the following requirements:
Provide User1 with read access to the table data in Lakehouse1.
Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.
Prevent User1 from accessing other items in Workspace1.
What should you do?

• A.Share Lakehouse1 with User1 directly and select Build reports on the default semantic model.
• B.Share Lakehouse1 with User1 directly and select Read all SQL endpoint data.
• C.Assign User1 the Viewer role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.
• D.Assign User1 the Member role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:
Orders
Customer
Employee
The Employee table contains Personally Identifiable Information (PII).
A data engineer is building a workflow that requires writing data to the Customer table, however, the user does NOT have the elevated permissions required to view the contents of the Employee table.
You need to ensure that the data engineer can write data to the Customer table without reading data from the Employee table.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Assign the data engineer the Contributor role for Workspace2.
• B.Assign the data engineer the Contributor role for Workspace1.
• C.Share Lakehouse1 with the data engineer.
• D.Assign the data engineer the Viewer role for Workspace2.
• E.Migrate the Employee table from Lakehouse1 to Lakehouse2.
• F.Create a new workspace named Workspace2 that contains a new lakehouse named Lakehouse2.
• G.Assign the data engineer the Viewer role for Workspace1.

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 [email protected].
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.

Correct Answer:

Explanation:

You have a Fabric workspace that contains a warehouse named Warehouse!. Warehousel contains a table named DimCustomers. DimCustomers contains the following columns:
* CustomerName
* CustomerlD
* BirthDate
* Email
You need to configure security to meet the following requirements:
* BirthDate in DimCustomer must be masked and display 1900-01-01.
* Email in DimCustomer must be masked and display only the first leading character and the last five characters.
How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE:
Each correct selection is worth one point.

Correct Answer:

Explanation: