Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Microsoft
Microsoft Certified: Fabric Data Engineer Associate
DP-700
Implementing Data Engineering Solutions Using Microsoft Fabric Questions and Answers

Pass the Microsoft Certified: Fabric Data Engineer Associate DP-700 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam DP-700 Premium Access

View all detail and faqs for the DP-700 exam

Go to Exam

720 Students Passed

84% Average Score

90% Same Questions

Viewing page 2 out of 5 pages

Viewing questions 11-20 out of questions

Questions # 11:

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1.

You plan to deploy Warehouse1 to a new workspace named Workspace2.

As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort.

What should you use?

Options:

a database project

a deployment pipeline

a Python script

a T-SQL script

Answer

Explanation

A deployment pipeline in Fabric allows you to deploy assets like warehouses, datasets, and reports between different workspaces (such as from Workspace1 to Workspace2). One of the key features of a deployment pipeline is the ability to check for invalid references before deployment. This can help identify issues with assets, such as broken links or dependencies, ensuring the deployment is successful without introducing errors. This is the most efficient way to verify references and manage the deployment with minimal development effort.

Questions # 12:

You need to implement the solution for the book reviews.

Which should you do?

Options:

Create a Dataflow Gen2 dataflow.

Create a shortcut.

Enable external data sharing.

Create a data pipeline.

Answer

Explanation

The requirement specifies that Litware plans to make the book reviews available in the lakehouse without making a copy of the data. In this case, creating a shortcut in Fabric is the most appropriate solution. A shortcut is a reference to the external data, and it allows Litware to access the book reviews stored in Amazon S3 without duplicating the data into the lakehouse.

Questions # 13:

HOTSPOT

You need to troubleshoot the ad-hoc query issue.

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 # 13

Options:

Answer

Answer:

Explanation

A screenshot of a computer Description automatically generated

SELECT last_run_start_time, last_run_command: These fields will help identify the execution details of the long-running queries.

FROM queryinsights.long_running_queries: The correct solution is to check the long-running queries using the queryinsights.long_running_queries view, which provides insights into queries that take longer than expected to execute.

WHERE last_run_total_elapsed_time_ms > 7200000: This condition filters queries that took more than 2 hours to complete (7200000 milliseconds), which is relevant to the issue described.

AND number_of_failed_runs > 1: This condition is key for identifying queries that have failed more than once, helping to isolate the problematic queries that cause failures and need attention.

Questions # 14:

You need to resolve the sales data issue. The solution must minimize the amount of data transferred.

What should you do?

Options:

Spilt the dataflow into two dataflows.

Configure scheduled refresh for the dataflow.

Configure incremental refresh for the dataflow. Set Store rows from the past to 1 Month.

Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Year.

Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.

Answer

Explanation

The sales data issue can be resolved by configuring incremental refresh for the dataflow. Incremental refresh allows for only the new or changed data to be processed, minimizing the amount of data transferred and improving performance.

The solution specifies that data older than one month never changes, so setting the refresh period to 1 Month is appropriate. This ensures that only the most recent month of data will be refreshed, reducing unnecessary data transfers.

Questions # 15:

What should you do to optimize the query experience for the business users?

Options:

Enable V-Order.

Create and update statistics.

Run the VACUUM command.

Introduce primary keys.

Answer

Questions # 16:

You need to ensure that the authors can see only their respective sales data.

How should you complete the statement? To answer, drag the appropriate values the correct targets. Each value 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 # 16

Options:

Answer

Answer:

Questions # 17:

You have a Fabric lakehouse that contains the resources shown in the following table.

Question # 17

You need to use a notebook to query for customers in the United States and load the filtered data into USCustomers. The solution must minimize the number of scripts used.

Which statement should you use?

Options:

customers.write.format( " parquet " ).mode( " append " ).saveAsTable( " USCustomers " )

customers.write.format( " delta " ).mode( " overwrite " ).save( " Tables/USCustomers " )

customers.write.format( " delta " ).mode( " overwrite " ).saveAsTable( " USCustomers " )

customers.write.format( " parquet " ).mode( " append " ).save( " Tables/USCustomers " )

Answer

Questions # 18:

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. You perform the following actions:

• Connect Workspace1 to a Git repository and select the main branch.

• Create a new branch named feature! and modify Lakehouse1.

• Merge the changes from feature1 into the main branch.

You need to ensure that the changes are available in Workspace1. The solution must minimize changes to Workspace1 What should you do?

Options:

Disconnect Workspace1 from the Git repository and reconnect Workspace1 to the main branch.

From Workspace1, select Source control, and then select Updates

From Workspace1, select Source control, and then select Commit

Switch Workspace1 to the feature1 branch and refresh the workspace.

Answer

Questions # 19:

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:

Create a new domain for the sales department.

Create two subdomains: one for the east region and one for the west region.

Assign Workspace1 to the east region subdomain.

Assign Workspace2 to the west region subdomain.

The solution must follow the principle of least privilege.

Which role should you assign to the user?

Options:

workspace Admin

domain admin

domain contributor

Fabric admin

Answer

Questions # 20:

You have a Fabric workspace that contains a semantic model named Modell. You need to monitor the refresh history of Model 1 and visualize the refresh history in a chart. What should you use?