Exam DP-700 topic 2 question 11 discussion

Actual exam question from Microsoft's DP-700

Question #: 11
Topic #: 2

HOTSPOT -
You are building a data loading pattern for Fabric notebook workloads.
You have the following code segment:

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by 4371883 at Jan. 25, 2025, 9:27 a.m.

Comments

Submit Cancel

8d6881f

Highly Voted 5 months ago

No No Yes. If anything goes wrong writing the existing table or when writing a new table (.targettable) the merge will not be executed.

upvoted 13 times

...

MultiCloudIronMan

Most Recent 3 months, 4 weeks ago

NNY is correct

upvoted 3 times

...

prabhjot

4 months, 3 weeks ago

No Yes Yes Merge operation always runs, the table is not overwritten if condition not matched

upvoted 4 times

...

4371883

5 months, 1 week ago

No; Yes: Yes Merge operation will always run, the matching_condition is part of the merge operation. But target table may not be overwritten if condition not met.

upvoted 4 times

xmh5025

1 month, 3 weeks ago

Even though the match_condition is part of the MERGE logic, that logic is skipped on the very first load because of the return inside the except block.

upvoted 2 times

...