Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 51 discussion

Actual exam question from Microsoft's DP-203

Question #: 51
Topic #: 1

HOTSPOT -
You are building an Azure Stream Analytics job that queries reference data from a product catalog file. The file is updated daily.
The reference data input details for the file are shown in the Input exhibit. (Click the Input tab.)

The storage account container view is shown in the Refdata exhibit. (Click the Refdata tab.)

You need to configure the Stream Analytics job to pick up the new reference data.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: {date}/product.csv -
In the 2nd exhibit we see: Location: refdata / 2020-03-20
Note: Path Pattern: This is a required property that is used to locate your blobs within the specified container. Within the path, you may choose to specify one or more instances of the following 2 variables:
{date}, {time}
Example 1: products/{date}/{time}/product-list.csv
Example 2: products/{date}/product-list.csv

Example 3: product-list.csv -

Box 2: YYYY-MM-DD -
Note: Date Format [optional]: If you have used {date} within the Path Pattern that you specified, then you can select the date format in which your blobs are organized from the drop-down of supported formats.
Example: YYYY/MM/DD, MM/DD/YYYY, etc.
Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data

by Lotusss at April 24, 2022, 8:31 a.m.

Comments

Submit Cancel

Dicer

Highly Voted 2 years ago

correct. Reasons: 1. {dat}/{time}/product.csv More detailed things should be put at the last. 2. YYYY-MM-DD if you choose YYYY/MM/DD, the system will think this is a file path.

upvoted 26 times

...

Rakrah

Highly Voted 1 year, 6 months ago

second box is straight forwarded answer YYYY-MM-DD First Box = {date}/product.csv - Because the requirement is reference data loaded on daily basis, so it may be once in a day not hourly or timely.

upvoted 21 times

...

kkk5566

Most Recent 11 months, 1 week ago

correct

upvoted 1 times

...

Rakrah

1 year, 6 months ago

The recommended way to refresh reference data is to: Use {date}/{time} in the path pattern. Box 1 should be {dat}/{time}/product.csv

upvoted 2 times

...

Deeksha1234

2 years ago

given answer is correct

upvoted 3 times

...

Franz58

2 years ago

1. {date}/product.csv 2. YYYY-MM-DD

upvoted 2 times

...

temacc

2 years ago

Path pattern: This required property is used to locate your blobs within the specified container. Within the path, you might choose to specify one or more instances of the variables {date} and {time}. Example 1: products/{date}/{time}/product-list.csv Example 2: products/{date}/product-list.csv Example 3: product-list.csv If the blob doesn't exist in the specified path, the Stream Analytics job waits indefinitely for the blob to become available. ##### Date format [optional]: If you used {date} within the path pattern you specified, select the date format in which your blobs are organized from the dropdown list of supported formats. Example: YYYY/MM/DD or MM/DD/YYYY ##### Time format [optional]: If you used {time} within the path pattern you specified, select the time format in which your blobs are organized from the dropdown list of supported formats. Example: HH, HH/mm, or HH-mm https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data

upvoted 2 times

...

Revave2

2 years, 1 month ago

I think the {date}/product.csv is correct, however it's formatted as YYYY/MM/DD, so why hyphenate it? In the example provided in the link the date was formatted with - instead of /, but in the question it's all /....

upvoted 3 times

JayOR

1 year ago

The prints don't look consistent with each other, the 2nd image the location is: refdata/2020-03-20/product.csv should be "YYYY-DD-MM". But the 1st image shows a different format: YYYY/MM/DD.

upvoted 2 times

hypersam

7 months, 1 week ago

first image only shows the default, you need to change them to the actual path shown in image 2

upvoted 1 times

...

Revave2

2 years, 1 month ago

....and to answer my own question, the second exhibit shows the product.csv file in refdata/yyyy-mm-dd . So that'll be the path

upvoted 5 times

TriumphMC

1 year, 6 months ago

Yes it through me at first because the first graphic refers to the file contents date format. When they looking for directory naming format

upvoted 1 times

...

demirsamuel

2 years, 2 months ago

answers are correct

upvoted 3 times

...

inotbf83

2 years, 3 months ago

I should change box 2 to YYYY/MM/DD (as shows 1st exhibit). A bit confusing with time format in the box 1.

upvoted 9 times

...

jackttt

2 years, 3 months ago

The file is updated daily, i think `{date}/product.csv` is correct

upvoted 5 times

...

Lotusss

2 years, 3 months ago

Wrong! Path Pattern: {dat}/{time}/product.csv Dat format: yyyy-mm-dd https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data

upvoted 3 times

KashRaynardMorse

2 years, 3 months ago

See that the file is stored under the date folder, and there is no time folder. Your link does recommend the time part, but the the link also says it's optional, and ultimately you need to answer the question, which states the path without the time.

upvoted 8 times

...