exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 2 question 40 discussion

Actual exam question from Microsoft's DP-700
Question #: 40
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:

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
vernillen
Highly Voted 3 weeks, 2 days ago
So... it's very simple: "The target table will always be overwritten." -> No. Because it will only overwrite everything/create the table when it doesn't already exist. So it will TRY to get the delta table, and if it doesn't, then it will create the table. 2. The merge operation will always run. -> No, this is basic python. "In your code, any raised exceptions trigger the associated except clause. Note that where you have multiple except clauses, your program will run only the first one that triggers and then ignore the rest." So if your first exception is triggered, the second one will not succeed. 3. The code supports incremental loading and the initial table creation. -> Yes. If the first try succeeds (and the first exception isn't triggered) it will execute the second try. In the second try, it will merge. The initial creation of the table is done when the first except is triggered (and the table doesn't exist). Hope this helps more rather than some simple combination shouting
upvoted 8 times
...
smanzana
Most Recent 2 weeks, 3 days ago
No No Yes
upvoted 1 times
...
mr_corte
3 weeks, 6 days ago
N, Y, Y
upvoted 2 times
...
DarioReymago
4 weeks ago
I think it is Y Y N
upvoted 1 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
Loading ...