Skip to main content

DP-700 Real Exam Questions

Implementing Data Engineering Solutions Using Microsoft Fabric

159 questions available · Page 1 of 16

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

You must build a Power Automate flow that activates whenever a new entry is added to a SharePoint list.

Which option represents the appropriate trigger for this flow?

  1. A

    When an item is modified

  2. B

    When an item is created

  3. C

    When an item is deleted

  4. D

    When a new document is uploaded

Show answer and explanation

Correct answer: B

Question 2 Hotspot

HOTSPOT

Your company has three newly created data engineering teams named Team1, Team2, and Team3 that plan to use Fabric.

The teams have the following personas:

1. Team1 consists of members who currently use Microsoft Power BI. The team wants to transform data by using by a low-code approach.
2. Team2 consists of members that have a background in Python programming. The team wants to use
PySpark code to transform data.
3. Team3 consists of members who currently use Azure Data Factory. The team wants to move data between source and sink environments by using the least amount of effort.

You need to recommend tools for the teams based on their current personas.

What should you recommend for each team? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question diagram
Show answer and explanation
Correct answer diagram
Question 3 Single choice

Your company has a sales department that uses two Fabric workspaces named Workspace1 and Workspace2.

The company decides to implement a domain strategy to organize the workspaces. You need to ensure that a user can perform the following tasks:

1. Create a new domain for the sales department.
2. Create two subdomains: one for the east region and one for the west region.

3. Assign Workspace1 to the east region subdomain.
4. Assign Workspace2 to the west region subdomain.

The solution must follow the principle of least privilege.

Which role should you assign to the user?

  1. A

    workspace Admin

  2. B

    domain admin

  3. C

    domain contributor

  4. D

    Fabric admin

Show answer and explanation

Correct answer: D

Question 4 Single choice

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures.

You discover that the daily data load takes longer than expected.

You need to monitor Warehouse1 to identify the names of users that are actively running queries.

Which view should you use?

  1. A

    sys.dm_exec_connections

  2. B

    sys.dm_exec_requests

  3. C

    queryinsights.long_running_queries

  4. D

    queryinsights.frequently_run_queries

  5. E

    sys.dm_exec_sessions

Show answer and explanation

Correct answer: E

Question 5 Single choice

You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1.

You have a deployment pipeline named deployPipeline1 that is used to deploy Workspace1 to Workspace2.

Workspace1 and Workspace2 are currently synchronized.

You restructure Workspace1 by adding a folder named Folder1 and moving Pipeline1 to Folder1.

You use deployPipeline1 to deploy Workspace1 to Workspace2.

What occurs to Workspace2?

  1. A

    Folder1 is created, Pipeline1 moves to Folder1, and Lakehouse1 is deployed.

  2. B

    Only Pipeline1 and Lakehouse1 are deployed.

  3. C

    Folder1 is created, and Pipeline1 and Lakehouse1 move to Folder1.

  4. D

    Only Folder1 is created and Pipeline1 moves to Folder1.

Show answer and explanation

Correct answer: A

Question 6 Single choice

You have a Fabric workspace named Workspace1 that is connected to a GitHub repository named repo1. Workspace1 contains the items shown in the following table.

You modify Semanticmodel1, Semanticmodel2, and Report2.

You need to commit the changes to repo1.

What is the minimum number of commits you should perform?

  1. A

    1

  2. B

    2

  3. C

    3

  4. D

    4

Show answer and explanation

Correct answer: A

Explanation

To commit the updates for the two semantic models and the second report to the GitHub repository, the minimum number of commits required is one. In Microsoft Fabric's Git integration, you can select multiple changed items simultaneously and commit them in a single batch.

Key Factors for Committing Batch Operations: The Fabric Source Control pane allows you to check the boxes next to all modified items (the two semantic models and the second report) and click Commit once.

Item Support: All the items mentioned (Semantic Models, Power BI Reports, and Dataflow Gen2) are supported for Git integration in Fabric.

Commit Logic: Git integration in Fabric does not force a "one commit per item" rule. As long as the items are in the same workspace and connected to the same branch, they can be grouped into one revision.

References:
https://community.fabric.microsoft.com/t5/Issues/Semantic-Model-and-Report-Syncing-Issues-with-Git-Integration/idi-p/3980544

Question 7 Single choice

You must monitor long-running warehouse queries and identify the users executing them.

Which view should you use?

  1. A

    sys.dm_exec_requests

  2. B

    queryinsights.long_running_queries

  3. C

    sys.dm_exec_connections

  4. D

    sys.dm_exec_sessions

Show answer and explanation

Correct answer: B

Question 8 Single choice

A semantic model refresh is failing due to missing credentials. You need to authenticate using secrets stored in Azure Key Vault.

Which notebook utility should you use?

  1. A

    notebookutils.credentials.getSecret

  2. B

    notebookutils.session.get

  3. C

    notebookutils.fs.mount

  4. D

    notebookutils.secrets.store

Show answer and explanation

Correct answer: A

Question 9 Single choice

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:

1. BikepointID
2. Street
3. Neighbourhood
4. No_Bikes
5. No_Empty_Docks
6. Timestamp

You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.

Solution: You use the following code segment:

Does this meet the goal?

  1. A

    Yes

  2. B

    No

Show answer and explanation

Correct answer: B

Question 10 Single choice

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Table1.

You analyze Table1 and discover that Table1 contains 2,000 Parquet files of 1 MB each.

You need to minimize how long it takes to query Table1.

What should you do?

  1. A

    Disable V-Order and run the OPTIMIZE command.

  2. B

    Disable V-Order and run the VACUUM command.

  3. C

    Run the OPTIMIZE and VACUUM commands.

Show answer and explanation

Correct answer: C