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

Question 1

Which Azure Stream Analytics compatibility level controls query language features and serialization behaviors?

Accepted Answer

Compatibility level

Answer

The Compatibility Level setting in a Stream Analytics job defines which version of the query language and runtime behavior to use, with newer levels offering additional features.

Question 2

In Azure Stream Analytics, what are Streaming Units (SUs)?

Accepted Answer

A measure of compute resources (CPU and memory) allocated to a job

Answer

Streaming Units represent the amount of CPU and memory resources allocated to a Stream Analytics job, and more SUs allow the job to handle higher event throughput.

Question 3

Which Delta Lake feature ensures ACID transactions on streaming writes in Azure Databricks?

Accepted Answer

Delta transaction log

Answer

Delta Lake maintains an ordered transaction log that records every write operation, ensuring ACID compliance even for concurrent streaming and batch writes.

Question 4

What is the purpose of 'watermarking' in Spark Structured Streaming?

Accepted Answer

To handle late-arriving data by defining how long the engine waits before finalizing window aggregates

Answer

Watermarking specifies a threshold for how late events can arrive; the engine uses this to determine when a time window's state can be finalized and old state dropped.

Question 5

In Azure Event Hubs, what is the default message retention period?

Accepted Answer

1 day

Answer

By default, Azure Event Hubs retains messages for 1 day, though this can be increased up to 7 days (or 90 days with Event Hubs Premium/Dedicated).

DP-203 Azure Data Engineer Associate Practice Test

DP-203 Azure Data Engineer Associate Practice Test

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