You have a Fabric workspace named Workspace1. Your company acquires GitHub licenses.You need to configure source control for Workpace1 to use GitHub. The solution must follow the principle of least privilege. Which permissions do you require to ensure that you can commit code to GitHub?

Actions (Read and write) and Contents (Read and write)

Contents (Read) and Commit statuses (Read and write)

You have a Fabric workspace that contains a lakehouse named Lakehousel.You plan to create a data pipeline named Pipeline! to ingest data into Lakehousel. You will use a parameter named paraml to pass an external value into Pipeline1!. The paraml parameter has a data type of intYou need to ensure that the pipeline expression returns param1 as an int value.How should you specify the parameter value?

'@{pipeline().parameters.paraml}'

'@pipeline(). parameters. paraml'

'@{pipeline().parameters.paraml}'

'@{pipeline().parameters.[paraml]}'

'@{pipeline().parameters.paraml}-

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.

Set the Retry setting of the Notebook activity to 2.

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

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

Set the Retry setting of the Notebook activity to 2.

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

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

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

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

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

You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit.

Both activities will run simultaneously.

Both activities will be skipped.

Execute procedurel will run and Copy_kdi will be skipped.

Copy.kdi will run and Execute procedurel will be skipped.

Execute procedure1 will run first, and then Copy_kdi will run.

Copy.kdi will run first, and then Execute procedurel will run.

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_032. Notebook.Ol3. Notebook_02Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

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

Add dependencies to the execution of Note boo k_02.

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

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

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

Add dependencies to the execution of Note boo k_02.

Add dependencies to the execution of Notebook_03.

You have an Azure SQL database named DB1.In a Fabric workspace, you deploy an eventstream named EventStreamDBI to stream record changes from DB1 into a lakehouse.You discover that events are NOT being propagated to EventStreamDBI.You need to ensure that the events are propagated to EventStreamDBI.What should you do?

Enable change data capture (CDC) for DB1.

Create a read-only replica of DB1.

Create an Azure Stream Analytics job.

Enable Extended Events for DB1.

Enable change data capture (CDC) for DB1.

You have a Fabric warehouse named DW1 that contains a Type 2 slowly changing dimension (SCD) dimension table named DimCustomer. DimCustomer contains 100 columns and 20 million rows. The columns are of various data types, including int, varchar, date, and varbinary.You need to identify incoming changes to the table and update the records when there is a change. The solution must minimize resource consumption.What should you use to identify changes to attributes?

a hash function to compare the attributes in the source table.

a direct attributes comparison for the attributes in the source table.

a hash function to compare the attributes in the DimCustomer table.

a direct attributes comparison across the attributes in the DimCustomer table.

a hash function to compare the attributes in the source table.

You have a Fabric workspace named Workspace1.You plan to configure Git integration for Workspacel by using an Azure DevOps Git repository. An Azure DevOps admin creates the required artifacts to support the integration of Workspacel Which details do you require to perform the integration?

the organization, project. Git repository, and branch

the project, Git repository, branch, and Git folder

the organization, project. Git repository, and branch

the Git repository URL and the Git folder

the personal access token (PAT) for Git authentication and the Git repository URL

Microsoft DP-700 Practice Test 3 - Free Online Exam Prep & Questions

Question 1 / 20

HOTSPOT

You have a Fabric workspace that contains a lakehouse named Lakehousel. Lakehousel contains a table named Status_Target that has the following columns:

* Key

* Status

* LastModified

The data source contains a table named Status.Source that has the same columns as Status_Target. Status.Source is used to populate Status_Target. In a notebook name Notebook!, you load Status_Source to a DataFrame named sourceDF and Status_Target to a DataFrame named targetDF. You need to implement an incremental loading pattern by using Notebook-!. The solution must meet the following requirements:

* For all the matching records that have the same value of key, update the value of LastModified in Status_Target to the value of LastModified in Status_Source.

* Insert all the records that exist in Status_Source that do NOT exist in Status_Target.

* Set the value of Status in Status_Target to inactive for all the records that were last modified more than seven days ago and that do NOT exist in Status.Source.

How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-700 Practice Test 3

Question

Microsoft DP-700 Practice Tests

Practice Tests