AZ-220 Exam - Question 105

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an Azure Stream Analytics job that receives input from an Azure IoT hub and sends the outputs to Azure Blob storage. The job has compatibility level

1.1 and six streaming units.

You have the following query for the job.

You plan to increase the streaming unit count to 12.

You need to optimize the job to take advantage of the additional streaming units and increase the throughput.

Solution: You change the query to the following.

Does this meet the goal?

Examice · Accepted Answer

The change in the query involves partitioning the input using the 'PARTITION BY' clause. By partitioning the input and then aggregating the results, the workload can be distributed among the increased number of streaming units. The initial setup without partitioning supports a maximum of 6 streaming units. By adding partitioning and creating two steps in the query, the job can utilize the full capacity of 12 streaming units. Therefore, changing the query as described meets the goal of optimizing the job to take advantage of the additional streaming units and increasing the throughput.

kohmaksimka · Answer

Yes - https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization#calculate-the-max-streaming-units-for-a-job

Initial query is not partitioned and one step, so max 6 SU as mentioned in question.

After altering query, the query now contains two steps. First one partitioned from non-partition input (6 SU) plus the secondary non-partitioned step (+ 6 SU as all non-partitioned steps together can scale up to six streaming units). Total is 12 SU

tita_tovenaar · Answer

answer is Yes. it is. one-step query and is partitioned, so max sku is 96.

see table here: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization

trickerk · Answer

Answer should be YES.
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization

Stephan99 · Answer

The input data stream is partitioned by 3.                              
The query contains two steps. 
The input step is partitioned and the second step is not.
The SELECT statement reads from the partitioned input.

Result: 24 streaming units: (18 for partitioned steps + 6 for non-partitioned steps)
see https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization

reynu · Answer

what is the answer

AZ-220 Exam - Question 105

Discussion