ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 2 question 75 discussion

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

You have an Azure Data Factory pipeline that is triggered hourly.
The pipeline has had 100% success for the past seven days.
The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error.
ErrorCode=UserErrorFileNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'NotFound'. Account: 'contosoproduksouth'. Filesystem: wwi. Path: 'BIKES/CARBON/year=2021/month=01/day=10/hour=06'. ErrorCode: 'PathNotFound'. Message: 'The specified path does not exist.'. RequestId: '6d269b78-901f-001b-4924-e7a7bc000000'. TimeStamp: 'Sun, 10 Jan 2021 07:45:05
What is a possible cause of the error?

  • A. The parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect.
  • B. From 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON.
  • C. From 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.
  • D. The pipeline was triggered too early.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by g2000 at April 20, 2022, 9:30 p.m.

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
Submit Cancel
KashRaynardMorse
Highly Voted 3 years, 1 month ago
Selected Answer: B
The error message says a missing file, which matches with answer B: missing data from 06:00. The process had re-tried three times, 15 mins apart, which explains that the error was generated 07:45.
upvoted 32 times
Billybob0604
2 years, 6 months ago
i don't agree. the path is not created correctly and therefore the file is ' missing' . It is in the error message too.
upvoted 3 times
MS2710
2 years, 5 months ago
Answer A. The path in error message shows hour=06 whereas the hour of retry run is 07.
upvoted 3 times
...
...
hunno_basha
1 year, 1 month ago
Agree, noting that previous runs were succeeded which indicates it is not parameter issue
upvoted 3 times
...
Remedios79
2 years, 11 months ago
Thank you for the detail
upvoted 1 times
...
jongert
1 year, 5 months ago
To elaborate, the pipeline is triggered hourly, any processing that is done has to be applied to the data that was received in the last hour. In other words, at 07:00 the data received between 06:00 and 07:00 is processed. Accounting for 3*15m results in 07:45. More elegantly however, the timestamps worked fine for a week which indicates that path creation is not a problem. Answer is B as you say.
upvoted 4 times
...
...
sugiats
Highly Voted 2 years, 3 months ago
For 7 days, this job was succeeding. So path rule seems to be right.
upvoted 9 times
...
renan_ineu
Most Recent 8 months, 2 weeks ago
Selected Answer: B
The pipeline ran fine for 7 days? No miscalculation, unless summer time was applied, which usually doesn't happen at 7 AM anywhere. Also, no bad params or it would never have run. It's about data.
upvoted 1 times
...
Dusica
1 year, 1 month ago
when something runs smoothly and then all of the sudden it does not then it must be data either missing or incorrect presuming that the data is also loaded by consistent process it would not be wrong formatting but only missing data
upvoted 2 times
...
j888
1 year, 3 months ago
I think A is the closest matching answer. It's been unable to find the file, it can be a valid reason that someone has changed the folder, therefore the path is not found. If it's a payload or data-related matter, I would expect a different error rather than not found.
upvoted 1 times
...
Azure_2023
1 year, 3 months ago
Selected Answer: B
The process is scheduled to process the file on a daily basis every day at 7am. The last try at 7:45 return the error - the file is missing. Therefore, the data is missing data from 06:00. And this is the normal schedule. For 7 days, this job was succeeding.
upvoted 1 times
...
Alongi
1 year, 4 months ago
Selected Answer: B
B is the answer
upvoted 1 times
...
kkk5566
1 year, 9 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
Altgeeky
1 year, 9 months ago
A. The parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect. The error message indicates that the specified path 'BIKES/CARBON/year=2021/month=01/day=10/hour=06' does not exist. This suggests that the parameters used to generate the path might be incorrect, resulting in an invalid or non-existent path. Double-checking the parameter values used to construct the path would be the most likely reason for this error.
upvoted 1 times
...
Tightbot
1 year, 9 months ago
Selected Answer: B
This option matches with the parameter 6th hour of Jan 10th . Option A might or might not be true but we have no data about what hour of data to be retrieved. Whereas, Option B clearly points to the time mentioned in the question and Path not found could be due to no data prsent
upvoted 2 times
...
esaade
2 years, 3 months ago
Selected Answer: B
The error message states that the specified path does not exist. Therefore, a possible cause of the error could be that the data for the specified path, which is wwi/BIKES/CARBON/year=2021/month=01/day=10/hour=06, does not exist in the storage account. This could be due to missing data or incorrect path or container name. Option B is the most likely cause of the error as it suggests that there was no data in the specified path during the given time frame.
upvoted 3 times
...
raphasc
2 years, 5 months ago
Selected Answer: A
Provided answer is correct : PATH NOT FOUND . The right path must be BIKES/CARBON/2021/01/06/Filename.* Filesystem: wwi. Path: 'BIKES/CARBON/year=2021/month=01/day=10/hour=06'. ErrorCode: 'PathNotFound'. Message: 'The specified path does not exist.'.
upvoted 2 times
Venub28
2 years, 4 months ago
question says that it ran fine earlier. Parameter must have been set correctly. Answer is B
upvoted 4 times
...
...
dmitriypo
2 years, 7 months ago
Selected Answer: B
No file
upvoted 2 times
...
Rohanh
2 years, 8 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
dom271219
2 years, 9 months ago
Selected Answer: B
B of course
upvoted 3 times
...
CloudixExamTopics
2 years, 9 months ago
The question states the pipeline runs hourly and in the timestamp of the error we can see that the time is 7:45 for the third run. So the initial run was at 7:00, but the folder it was looking at is hour=06, which is wrong, it should be hour = 07. So I agree with the option A
upvoted 5 times
pangas2567
2 years, 9 months ago
With run starting at 7.00 pointing to the hour=07 folder, you wouldn't have anything to work with. One hour delay needed here.
upvoted 9 times
...
...
Deeksha1234
2 years, 10 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
Load full discussion...
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