Implementing an Azure Data Solution (legacy) — Question 61

A development team is making use of Azure Stream Analytics. They have defined the following SQL query:
WITH step1 AS (SELECT * FROM input1 PARTITION BY XYZID INTO 10), step2 AS (SELECT * FROM input2 PARTITION BY XYZID INTO 10)
SELECT * INTO output FROM step1 PARTITION BY XYZID UNION step2 PARTITION BY XYZID
Does the query represent the joining of two streams of repartitioned data?

Answer options

• A. Yes
• B. No

Correct answer: A

Explanation

The query demonstrates the union of two streams, step1 and step2, both of which are repartitioned by XYZID. Since the union operation combines the results from both streams into a single output, the correct answer is A. Option B is incorrect because it suggests that the query does not represent a joining of the repartitioned data, which it clearly does.