Azure Data Processing and Pipelines Flashcards

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

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

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

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

Answer: Hopping window

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.

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

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

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.

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

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

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

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

Answer: Azure SQL Database

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

What is the purpose of the compatibility level setting in Azure Stream Analytics?

Answer: It defines which version of Stream Analytics query language features and behaviors are used

The compatibility level governs which version of the Stream Analytics query engine features are applied, ensuring consistent behavior across updates.