exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 2 question 24 discussion

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

HOTSPOT -
A company plans to analyze a continuous flow of data from a social media platform by using Microsoft Azure Stream Analytics. The incoming data is formatted as one record per row.
You need to create the input stream.
How should you complete the REST API segment? To answer, select the appropriate configuration in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: CSV -
A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. A CSV file stores tabular data (numbers and text) in plain text.
Each line of the file is a data record.
JSON and AVRO are not formatted as one record per row.
Box 2: "type":"Microsoft.ServiceBus/EventHub",
Properties include "EventHubName"
References:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-inputs https://en.wikipedia.org/wiki/Comma-separated_values

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
epgd
Highly Voted 5 years, 7 months ago
Check this: { "properties":{ "type":"stream", "serialization":{ "type":"CSV", "properties":{ "fieldDelimiter":",", "encoding":"UTF8" } }, "datasource":{ "type":"Microsoft.ServiceBus/EventHub", "properties":{ "serviceBusNamespace":"sampleServiceBus", "sharedAccessPolicyName":"SampleReceiver", "sharedAccessPolicyKey":"***/**********/*****************************", "eventHubName":"sampleEventHub" } }, "compression":{ "type":"GZip" } } } https://docs.microsoft.com/es-es/rest/api/streamanalytics/stream-analytics-input
upvoted 17 times
...
AAJ
Highly Voted 5 years, 3 months ago
CSV does not have to be"only comma separated". Given answer is correct.
upvoted 15 times
...
Prada
Most Recent 4 years, 5 months ago
AVRO is a serialized JSON. Therefore, it must be CSV
upvoted 2 times
...
Luke97
5 years, 1 month ago
fieldDelimiter is ONLY for CSV type data in ASA Input Serialization JSON file. So, CSV is the right answer.
upvoted 2 times
...
STH
5 years, 7 months ago
CSV is comma separated, not dot. Avro is made for serialization, so it's probably the right format.
upvoted 3 times
Gluckos
4 years, 8 months ago
wrong response for me.. csv may have comma, dot, star so may have any characters
upvoted 1 times
...
Pairon
4 years, 3 months ago
"One record per row" -> CSV. Avro is in columnar format for reads optimization.
upvoted 3 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 ...