Big Cyber Monday Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

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

Home
Microsoft
Microsoft Certified: Fabric Data Engineer Associate
DP-700
DP-700 Questions and Answers

Exam DP-700 Premium Access

View all detail and faqs for the DP-700 exam

Go to Exam

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

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

Questions # 1:

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

Options:

Answer

Answer:

Questions # 2:

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 # 3:

You need to create a workflow for the new book cover images.

Which two components should you include in the workflow? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

a notebook that uses Apache Spark Structured Streaming

a time-based schedule

an activator item

a data pipeline

a streaming dataflow

a blob storage action

Answer

E, F

Questions # 4:

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

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 # 5:

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 # 6:

You need to ensure that processes for the bronze and silver layers run in isolation How should you configure the Apache Spark settings?

Options:

Modify the number of executors.

Disable high concurrency.

Create a custom pool.

Set the default environment.

Answer

Questions # 7:

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 # 8:

You need to recommend a solution to resolve the MAR1 connectivity issues. The solution must minimize development effort. What should you recommend?

Options:

Add a ForEach activity to the data pipeline.

Configure retries for the Copy data activity.

Configure Fault tolerance for the Copy data activity.

Call a notebook from the data pipeline.

Answer

Questions # 9:

You need to recommend a solution for handling old files. The solution must meet the technical requirements. What should you include in the recommendation?

Options:

a data pipeline that includes a Copy data activity

a notebook that runs the VACUUM command

a notebook that runs the OPTIMIZE command

a data pipeline that includes a Delete data activity

Answer

Questions # 10:

You need to populate the MAR1 data in the bronze layer.

Which two types of activities should you include in the pipeline? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

ForEach

Copy data

WebHook

Stored procedure

Answer

A, B

Explanation

MAR1 has seven entities, each accessible via a different API endpoint. A ForEach activity is required to iterate over these endpoints to fetch data from each one. It enables dynamic execution of API calls for each entity.

The Copy data activity is the primary mechanism to extract data from REST APIs and load it into the bronze layer in Delta format. It supports native connectors for REST APIs and Delta, minimizing development effort.

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).