exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 19 discussion

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

You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an
Azure Synapse Analytic dedicated SQL pool. The CSV file contains three columns named username, comment, and date.
The data flow already contains the following:
✑ A source transformation.
✑ A Derived Column transformation to set the appropriate types of data.
✑ A sink transformation to land the data in the pool.
You need to ensure that the data flow meets the following requirements:
✑ All valid rows must be written to the destination table.
✑ Truncation errors in the comment column must be avoided proactively.
✑ Any rows containing comment values that will cause truncation errors upon insert must be written to a file in blob storage.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. To the data flow, add a sink transformation to write the rows to a file in blob storage.
  • B. To the data flow, add a Conditional Split transformation to separate the rows that will cause truncation errors.
  • C. To the data flow, add a filter transformation to filter out rows that will cause truncation errors.
  • D. Add a select transformation to select only the rows that will cause truncation errors.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️

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
Francesco1985
Highly Voted 2 years, 10 months ago
correct
upvoted 34 times
...
onyerleft
Highly Voted 2 years, 4 months ago
Selected Answer: AB
Conditional split with a sink transformation is the correct answer https://docs.microsoft.com/en-us/azure/data-factory/how-to-data-flow-error-rows?WT.mc_id=esi_studyguide_content_wwl#how-to-design-around-this-condition
upvoted 6 times
...
kkk5566
Most Recent 7 months, 4 weeks ago
Selected Answer: AB
CORRECT
upvoted 1 times
...
anks84
1 year, 7 months ago
Selected Answer: AB
CORRECT
upvoted 3 times
...
Deeksha1234
1 year, 9 months ago
Selected Answer: AB
A&B are correct
upvoted 2 times
...
SebK
2 years, 1 month ago
Correct
upvoted 1 times
...
EmmettBrown
2 years, 3 months ago
Selected Answer: AB
Correct A and B
upvoted 2 times
...
PallaviPatel
2 years, 3 months ago
Selected Answer: AB
Correct
upvoted 1 times
...
victor90
2 years, 4 months ago
I agree with the answer. https://www.microsoft.com/en-us/videoplayer/embed/RE4uOHj
upvoted 1 times
...
rashjan
2 years, 4 months ago
Selected Answer: AB
correct
upvoted 1 times
...
satyamkishoresingh
2 years, 8 months ago
Why not C ?
upvoted 1 times
Marcus1612
2 years, 7 months ago
You are right ! The job could be done by C only, BUT ! it has been asked for two(2) actions. No choice to add a SPLIT then another sink where to drop the bad records
upvoted 3 times
berserksap
2 years, 6 months ago
But you need to write to blob right ? How can only C help with that?
upvoted 4 times
...
...
...
AvithK
2 years, 8 months ago
Bad rows go to 'folder out' and the good rows to the junk table? How come?
upvoted 1 times
data_guy
4 months, 3 weeks ago
The third point "A sink transformation to land the data in the pool" is for the good rows. You choose the conditional split to ensure that any bad rows are put somewhere else before they break the logic of the data flow.f
upvoted 1 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago