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

Overlaps with adjacent windows

Answer

Slides forward by a defined step size

Answer

Aggregates all data since the stream started

Question 2

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

Accepted Answer

Hopping window

Answer

Tumbling window

Answer

Session window

Answer

Snapshot window

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

To receive high-velocity streaming events

Answer

To output processed results to a sink

Answer

To define watermark thresholds for late arrivals

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

It drops all events that arrive after the watermark

Answer

It speeds up event processing by batching late events

Answer

It converts late events to reference data

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 Event Hubs

Answer

Azure Blob Storage

Answer

Azure Service Bus

Question 6

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

Accepted Answer

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

Answer

It controls the encryption strength of output data

Answer

It sets the maximum parallelism for the job

Answer

It specifies the SLA tier for the job