ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 2 question 11 discussion

Actual exam question from Microsoft's DP-700
Question #: 11
Topic #: 2
[All DP-700 Questions]

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 Hide Answer
Suggested Answer:
by 4371883 at Jan. 25, 2025, 9:27 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
8d6881f
Highly Voted 2 months, 4 weeks 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 10 times
...
MultiCloudIronMan
Most Recent 1 month, 3 weeks ago
NNY is correct
upvoted 3 times
...
prabhjot
2 months, 2 weeks ago
No Yes Yes Merge operation always runs, the table is not overwritten if condition not matched
upvoted 4 times
...
4371883
3 months 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago