Exam DP-203 topic 4 question 34 discussion

Actual exam question from Microsoft's DP-203

Question #: 34
Topic #: 4

You have an Azure Stream Analytics query. The query returns a result set that contains 10,000 distinct values for a column named clusterID.
You monitor the Stream Analytics job and discover high latency.
You need to reduce the latency.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Add a pass-through query.
B. Increase the number of streaming units.
C. Add a temporal analytic function.
D. Scale out the query by using PARTITION BY.
E. Convert the query to a reference query.

Show Suggested Answer

Suggested Answer: BD 🗳️

by rzeng at Oct. 28, 2022, 4:06 p.m.

Comments

Submit Cancel

vctrhugo

Highly Voted 11 months, 3 weeks ago

Selected Answer: BD

To reduce latency in an Azure Stream Analytics job with a query returning a result set containing 10,000 distinct values for a column named clusterID, you should perform the following actions: B. Increase the number of streaming units: Increasing the number of streaming units allocates more resources to your Stream Analytics job, allowing it to handle higher data volumes and processing loads. By increasing the streaming units, you can improve the job's throughput and reduce latency. D. Scale out the query by using PARTITION BY: Using the PARTITION BY clause in your query allows you to distribute the workload across multiple partitions or parallel processes. By partitioning the data based on relevant criteria, such as clusterID in this case, you can distribute the processing load and reduce latency by enabling parallel processing.

upvoted 8 times

...