DP-203 Azure Data Engineer Associate DP-203 Azure Data Engineer Associate Real-Time Analytics and Streaming 2

Question 1

Which windowing function in Azure Stream Analytics produces overlapping windows that slide forward by a defined step interval?

Accepted Answer

Hopping Window

Answer

Tumbling Window

Answer

Session Window

Answer

Snapshot Window

Question 2

In Azure Event Hubs, what determines the maximum number of parallel consumers reading from an Event Hub?

Accepted Answer

The number of partitions

Answer

The number of Consumer Groups

Answer

The throughput units provisioned

Answer

The message retention period

Question 3

Which Azure Databricks feature enables structured streaming of data from Azure Event Hubs?

Accepted Answer

Spark Structured Streaming with Event Hubs connector

Answer

Delta Live Tables batch ingestion

Answer

Databricks Auto Loader

Answer

Databricks SQL Warehouse

Question 4

What is Azure IoT Hub's primary advantage over Azure Event Hubs for IoT scenarios?

Accepted Answer

Bidirectional communication with devices and per-device identity management

Answer

Higher throughput capacity

Answer

Lower cost per message

Answer

Native SQL query support for streams

Question 5

In Azure Stream Analytics, which output type allows writing results to a Power BI dataset for real-time dashboards?

Accepted Answer

Power BI

Answer

Azure Blob Storage

Answer

Azure SQL Database

Answer

Azure Data Lake Storage Gen2

Question 6

What does 'checkpointing' accomplish in Spark Structured Streaming?

Accepted Answer

It saves the streaming query progress to fault-tolerant storage to enable recovery after failure

Answer

It compresses the streaming data before writing to output

Answer

It batches micro-intervals for higher throughput

Answer

It validates the schema of each incoming event