exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 1 question 59 discussion

Actual exam question from Microsoft's DP-200
Question #: 59
Topic #: 1
[All DP-200 Questions]

HOTSPOT -
You have the following Azure Stream Analytics query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
You can now use a new extension of Azure Stream Analytics SQL to specify the number of partitions of a stream when reshuffling the data.
The outcome is a stream that has the same partition scheme. Please see below for an example:
WITH step1 AS (SELECT * FROM [input1] PARTITION BY DeviceID INTO 10), step2 AS (SELECT * FROM [input2] PARTITION BY DeviceID INTO 10)
SELECT * INTO [output] FROM step1 PARTITION BY DeviceID UNION step2 PARTITION BY DeviceID
Note: The new extension of Azure Stream Analytics SQL includes a keyword INTO that allows you to specify the number of partitions for a stream when performing reshuffling using a PARTITION BY statement.

Box 2: Yes -
When joining two streams of data explicitly repartitioned, these streams must have the same partition key and partition count.

Box 3: Yes -
Streaming Units (SUs) represents the computing resources that are allocated to execute a Stream Analytics job. The higher the number of SUs, the more CPU and memory resources are allocated for your job.
In general, the best practice is to start with 6 SUs for queries that don't use PARTITION BY.
Here there are 10 partitions, so 6x10 = 60 SUs is good.
Note: Remember, Streaming Unit (SU) count, which is the unit of scale for Azure Stream Analytics, must be adjusted so the number of physical resources available to the job can fit the partitioned flow. In general, six SUs is a good number to assign to each partition. In case there are insufficient resources assigned to the job, the system will only apply the repartition if it benefits the job.
Reference:
https://azure.microsoft.com/en-in/blog/maximize-throughput-with-repartitioning-in-azure-stream-analytics/ https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-streaming-unit-consumption

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Amy007
Highly Voted 4 years, 1 month ago
Yes , Yes and No.
upvoted 8 times
...
Chemmangat
Most Recent 1 year, 9 months ago
From DP 203 discussions, I found out the answer is Yes for all.
upvoted 1 times
...
hosan
4 years ago
What is the correct answer?? Pl advise.
upvoted 1 times
captainbee
3 years, 11 months ago
Doesn't matter, no-one can seem to agree on the answer on here either
upvoted 1 times
...
...
Williammm
4 years ago
What is the answer?? WHy do they not give the correct answer in the first place..what is their problem? ]
upvoted 1 times
...
qiyan1982
4 years ago
NO, YES, YES.
upvoted 3 times
...
jasonoubre
4 years ago
After the survey, I have no ideas. Can I know what is the answer?
upvoted 1 times
...
akod
4 years, 2 months ago
This question is repetitive.
upvoted 2 times
AngelRio
4 years, 2 months ago
It's different. My options are Yes, No and No (Source Whizlabs)
upvoted 2 times
...
Nobody99
4 years, 1 month ago
Its not. Question 45: The query joins ... Question 59: The query combines ...
upvoted 7 times
cadio30
4 years, 1 month ago
The query from both items are different. Question # 45 doesn't have "partition" syntax that makes it incorrect. On the other hand, there are two select statements that is combined.
upvoted 2 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...