DP-200 Azure Data Processing and Pipelines 3

Question 1

In Azure Stream Analytics, what does a tumbling window function do?

Accepted Answer

Segments a stream into non-overlapping, fixed-duration time buckets

Answer

Tumbling windows divide a stream into fixed, non-overlapping intervals, with each event belonging to exactly one window.

Question 2

Which Azure Stream Analytics window type allows events to be included in multiple overlapping windows?

Accepted Answer

Hopping window

Answer

Hopping windows have a fixed size but advance by a hop interval smaller than the window size, causing windows to overlap and events to appear in multiple windows.

Question 3

What is the role of a reference input in Azure Stream Analytics?

Accepted Answer

To provide a static or slowly changing dataset for lookups and enrichment

Answer

A reference input in Stream Analytics is a slow-changing dataset (e.g., a CSV in Blob Storage) joined against the streaming input for data enrichment.

Question 4

In Azure Stream Analytics, what does setting a late arrival tolerance policy accomplish?

Accepted Answer

It allows events arriving within the tolerance window to be included in the correct time-based computation

Answer

Late arrival tolerance allows Stream Analytics to wait a specified duration for out-of-order events before finalizing window results.

Question 5

Which output sink in Azure Stream Analytics is best suited for storing aggregated results in a relational format for BI reporting?

Accepted Answer

Azure SQL Database

Answer

Azure SQL Database is the ideal relational output for Stream Analytics aggregations that will be consumed by BI tools like Power BI.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Processing and Pipelines 3