Exam DP-700 topic 2 question 27 discussion

Actual exam question from Microsoft's DP-700

Question #: 27
Topic #: 2

HOTSPOT
-

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 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 Notebook1, 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 Notebook1. 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.

Show Suggested Answer

Suggested Answer:

by Azure-JL at April 18, 2025, 7:46 p.m.

Comments

Submit Cancel

13d2a97

Highly Voted 1 month, 1 week ago

whenMatchedUpdate is used to update existing records — here, just LastModified. whenNotMatchedInsert handles inserting new records into the target from the source. whenNotMatchedBySourceUpdate is key for handling records that are no longer present in the source and meet a time-based condition (older than 7 days), marking them as "inactive".

upvoted 7 times

...