Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Free Practice Test

Question 1

You have a Fabric workspace named Workspace1 that contains three notebooks named notebook_01, notebook_02, and notebook_03.
You are building a new notebook in Workspace1 that will contain the following Directed Acyclic Graph (DAG) definition.

You need to modify the DAG definition to meet the following requirements:
* Ensure that notebook.01 and notebook_02 run in parallel.
* Ensure that notebook_02 only runs after the execution of notebook_03 is complete.
How should you modify the DAG definition?

A. Move the notebook_03 declaration to the top of the DAG definition. Add a concurrency to notebook_02 and notebook_01.

B. Create a second DAG definition. Move notebook_03 and notebook_02 to the new DAG definition

C. Move the declaration of notebook 03 to the top of the DAG definition. Add a new stage that contains notebook 01 and notebook 02.

D. Create two stages in the DAG definition. Add notebook_03 to the first stage. Add notebook_01 and notebook_02 to the second stage.

Correct Answer: D

Question 2

You have two Fabric workspaces named Workspace1 and Workspace2.
You have a Fabric deployment pipeline named deployPipeline1 that deploys items from Workspace1 to Workspace2. DeployPipeline1 contains all the items in Workspace1.
You recently modified the items in Workspaces1.
The workspaces currently contain the items shown in the following table.

Items in Workspace1 that have the same name as items in Workspace2 are currently paired.
You need to ensure that the items in Workspace1 overwrite the corresponding items in Workspace2. The solution must minimize effort.
What should you do?

A. Run deployPipeline1 without modifying the items in Workspace2.

B. Delete all the items in Workspace2, and then run deployPipeline1.

C. Rename each item in Workspace2 to have the same name as the items in Workspace1.

D. Back up the items in Workspace2, and then run deployPipeline1.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
Users report that from OneLake file explorer, they cannot see the data from the eventhouse.
You enable OneLake availability for the eventhouse.
What will be copied to OneLake?

A. no data

B. only the existing data in the eventhouse

C. only new data added to the eventhouse

D. both new data and existing data in the eventhouse

E. only data added to new databases that are added to the eventhouse

Correct Answer: C

Question 4

HOTSPOT
You have an Azure Event Hubs data source that contains weather data.
You ingest the data from the data source by using an eventstream named Eventstream1. Eventstream1 uses a lakehouse as the destination.
You need to batch ingest only rows from the data source where the City attribute has a value of Kansas. The filter must be added before the destination. The solution must minimize development effort.
What should you use for the data processor and filtering? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Question 5

You have a Fabric workspace that contains a takehouse and a semantic model named Model1.
You use a notebook named Notebook1 to ingest and transform data from an external data source.
You need to execute Notebook1 as part of a data pipeline named Pipeline1. The process must meet the following requirements:
* Run daily at 07:00 AM UTC.
* Attempt to retry Notebook1 twice if the notebook fails.
* After Notebook1 executes successfully, refresh Model1.
Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. From the Schedule settings of Notebook1, set the time zone to UTC.

B. From the Schedule settings of Pipeline1, set the time zone to UTC.

C. Set the Retry setting of the Semantic model refresh activity to 2.

D. Place the Semantic model refresh activity after the Notebook activity and link the activities by using an On completion condition.

E. Place the Semantic model refresh activity after the Notebook activity and link the activities by using the On success condition.

F. Set the Retry setting of the Notebook activity to 2.

Correct Answer: B,E,F

Question 6

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.

A. Copy data

B. ForEach

C. Stored procedure

D. WebHook

Correct Answer: A,B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

You have a KQL database that contains a table named Readings.
You need to build a KQL query to compare the Meter-Reading value of each row to the previous row base on the ilmestamp value A sample of the expected output is shown in the following table.

Correct Answer:

Explanation:

Question 8

You have a Fabric workspace that contains an eventstream named Eventstream1. Eventstream1 processes data from a thermal sensor by using event stream processing, and then stores the data in a lakehouse.
You need to modify Eventstream1 to include the standard deviation of the temperature.
Which transform operator should you include in the Eventstream1 logic?

A. Aggregate

B. Expand

C. Union

D. Group by

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

You are building a Fabric notebook named MasterNotebookl in a workspace. MasterNotebookl contains the following code.

You need to ensure that the notebooks are executed in the following sequence:
1. Notebook_03
2. Notebook.Ol
3. Notebook_02
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Move the declaration of Notebook_03 to the top of the Directed Acyclic Graph (DAG) definition.

B. Add dependencies to the execution of Note boo k_02.

C. Move the declaration of Notebook_02 to the bottom of the Directed Acyclic Graph (DAG) definition.

D. Add dependencies to the execution of Notebook_03.

E. Split the Directed Acyclic Graph (DAG) definition into three separate definitions.

F. Change the concurrency to 3.

Correct Answer: A,B

Welcome to TestSimulate

Microsoft Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Free Practice Test