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.ForEach
• B.Copy data
• C.WebHook
• D.Stored procedure

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a data pipeline named Pipeline1 and a notebook named Notebook1. Pipeline1 contains an activity that is used to run Notebook1. Pipeline! is scheduled to run every
10 minutes.
You receive an alert that Pipeline! failed during the notebook execution activity.
You need to identify in which cell the failure occurred.
What should you do from Monitor in the Fabric admin center?

• A.Select the entry for the notebook execution, and then view the item snapshot.
• B.Select the entry for the notebook execution, and then select the logs.
• C.Select the entity for the pipeline execution, and then view the activity run.
• D.Select the entry for the pipeline execution, and then select the output.

Comment: *

Name: *

Email: *

Verification: *

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:
BikepointID
Street
Neighbourhood
No_Bikes
No_Empty_Docks
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?

• A.Yes
• B.no

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a large table named Table1. Table1 contains 2 billion rows.
You have a data source that generates a data file every 30 minutes The file contains only changes that occurred since the last file was generated.
You plan to deploy a data pipeline that will process each data file when it is generated and load the contents into Table1. You need to recommend which loading pattern to use for the following operations:
* Create new records.
* Delete existing records.
The solution must support the versioning of existing records.
What should you recommend for each operation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

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.Create two stages in the DAG definition. Add notebook_03 to the first stage. Add notebook_01 and notebook_02 to the second stage.
• B.Move the notebook_03 declaration to the top of the DAG definition. Add a concurrency to notebook_02 and notebook_01.
• C.Create a second DAG definition. Move notebook_03 and notebook_02 to the new DAG definition
• D.Move the declaration of notebook 03 to the top of the DAG definition. Add a new stage that contains notebook 01 and notebook 02.

Comment: *

Name: *

Email: *

Verification: *