exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 2 question 54 discussion

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

You are planning an Azure solution that will aggregate streaming data.
The input data will be retrieved from tab-separated values (TSV) files in Azure Blob storage.
You need to output the maximum value from a specific column for every two-minute period in near real-time. The output must be written to Blob storage as a
Parquet file.
What should you use?

  • A. Azure Data Factory and mapping data flows
  • B. Azure Data Factory and wrangling data flows
  • C. Azure Stream Analytics window functions
  • D. Azure Databricks and Apache Spark SQL window functions
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-outputs#parquet-output-batching-window-properties

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
cadio30
Highly Voted 4 years ago
Appropriate answer is C as the Azure Stream Analytics can perform aggregation syntax using MAX then output it in blob storage/ADLS Gen2
upvoted 13 times
...
erssiws
Most Recent 3 years, 11 months ago
The Databricks spark SQL by default works with batch mode. It won't fulfill the near real-time requirement
upvoted 1 times
...
Rob77
4 years ago
Both ASA and Databricks should be able to do it now
upvoted 1 times
...
niwe
4 years, 1 month ago
I think correct answer is D
upvoted 3 times
ZodiaC
3 years, 11 months ago
Make no SENSE
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 ...