DP-700 Exam Question 11

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.

DP-700 Exam Question 12

You have a Fabric deployment pipeline that uses three workspaces named Dev, Test, and Prod.
You need to deploy an eventhouse as part of the deployment process.
What should you use to add the eventhouse to the deployment process?
  • DP-700 Exam Question 13

    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.

    DP-700 Exam Question 14

    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?
  • DP-700 Exam Question 15

    You have a Fabric workspace named Workspace1 that contains the following items:
    * A Microsoft Power Bl report named Report1
    * A Power Bl dashboard named Dashboard1
    * A semantic model named Modell
    * A lakehouse name Lakehouse1
    Your company requires that specific governance processes be implemented for the items. Which items can you endorse in Fabric?