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

API version

Answer

Streaming unit tier

Answer

Query mode

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

The number of input partitions consumed

Answer

The number of output sinks configured

Answer

The retention period of ingested events

Question 3

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

Accepted Answer

Delta transaction log

Answer

Hive metastore locking

Answer

Parquet row-group statistics

Answer

Spark shuffle partitioning

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

To encrypt data before writing to the sink

Answer

To compress micro-batch data for efficiency

Answer

To add metadata timestamps to each row

Question 5

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

Accepted Answer

1 day

Answer

7 days

Answer

30 days

Answer

Indefinite

Question 6

Which Azure Synapse Analytics feature allows real-time analytical queries directly on operational data in Azure Cosmos DB without ETL?

Accepted Answer

Synapse Link for Azure Cosmos DB

Answer

Synapse Spark Pool

Answer

Synapse Dedicated SQL Pool

Answer

Synapse Data Flow