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

Exam DP-200 All Questions

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

Exam DP-200 topic 2 question 51 discussion

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

You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval. The output will be sent to a Delta Lake table.
Which output mode should you use?

  • A. complete
  • B. update
  • C. append
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
Append Mode: Only new rows appended in the result table since the last trigger are written to external storage. This is applicable only for the queries where existing rows in the Result Table are not expected to change.
Incorrect Answers:
A: Complete Mode: The entire updated result table is written to external storage. It is up to the storage connector to decide how to handle the writing of the entire table.
B: Update Mode: Only the rows that were updated in the result table since the last trigger are written to external storage. This is different from Complete Mode in that Update Mode outputs only the rows that have changed since the last trigger. If the query doesn't contain aggregations, it is equivalent to Append mode.
Reference:
https://docs.databricks.com/getting-started/spark/streaming.html
by memo43 at May 19, 2021, 8:33 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
ramelas
3 years, 4 months ago
"The solution will count new events in five-minute intervals and report only events that arrive during the interval." it is COMPLETE, not append
upvoted 1 times
uzairahm
2 years, 9 months ago
It is a delta lake in destination so you could write the complete results to output as well but what would be the criteria of managing in delta lake is not clear so i would go with append as each five minutes interval count results would go in as a separate row in destination
upvoted 1 times
...
...
memo43
3 years, 11 months ago
answer is CORRECT
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