Online Access Free DP-700 Exam Questions

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse! contains a table named Customer. Customer contains the following data.

You have an internal Microsoft Entra user named User1 that has an email address of [email protected].
You need to provide User1 with access to the Customer table. The solution must prevent User1 from accessing the CreditCard column.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains the following columns that store string values:
* FirstName
* Phone
* Email
You have two Microsoft Entra security groups named Group1 and Group2. The members of both groups can query Table1 and see full values for FirstName, Phone, and Email.
You need to configure Table1 to meet the following requirements:
. The members of Group1 must see masked values for Phone, showing only the last three characters of each phone number.
. The Group1 members must see unmasked values for FirstName.
. The members of Group2 must see unmasked values for all the columns.
. The solution must use Fabric warehouse-supported permissions and T-SQL.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

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?

• A.Create an Azure Stream Analytics job.
• B.Enable Extended Events for DB1.
• C.Create a read-only replica of DB1.
• D.Enable change data capture (CDC) for DB1.

You have a Fabric workspace that contains a lakehouse named Lakehouse1. a Dataflow Gen2 named Dataflow1, and a pipeline named Pipeline1. Dataflow1 loads data into Lakehouse1.
You need to ensure that Dataflow1always performs a full data load into Lakehouse1. The solution must minimize how long it takes to load the data.
What should you do?

• A.Change the pipeline templates.
• B.To Dataflow1, add a data preview.
• C.To Pipeline1, add an activity to invoke a SQL script.
• D.For Dataflow1.set Update method to Replace.

You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit.
(Click the Exhibit tab.) What will occur the next time Pipelinel tuns?

• A.Execute procedure1 will run first, and then Copy_kdi will run.
• B.Execute procedurel will run and Copy_kdi will be skipped.
• C.Copy.kdi will run and Execute procedurel will be skipped.
• D.Copy.kdi will run first, and then Execute procedurel will run.
• E.Both activities will run simultaneously.
• F.Both activities will be skipped.