Microsoft Exam DP-203 Topic 2 Question 105 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 105
Topic #: 2

You are building a data flow in Azure Data Factory that upserts data into a table in an Azure Synapse Analytics dedicated SQL pool.

You need to add a transformation to the data flow. The transformation must specify logic indicating when a row from the input data must be upserted into the sink.

Which type of transformation should you add to the data flow?

Ajoin

Bselect

Csurrogate key

Dalter row

Show Suggested Answer

Suggested Answer: D

The alter row transformation allows you to specify insert, update, delete, and upsert policies on rows based on expressions. You can use the alter row transformation to perform upserts on a sink table by matching on a key column and setting the appropriate row policy

by Lavonda at Nov 19, 2024, 09:40 AM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Luther

2 months ago

Ah, the classic 'which transformation do I use to upsert data?' question. I'm going to go with the 'eenie, meenie, minie, moe' approach on this one.

upvoted 0 times

...

Cammy

2 months ago

Humorous Comment 2

upvoted 0 times

...

Toi

2 months ago

This is a tricky one. I'm stuck between C) surrogate key and D) alter row. I guess I'll have to do some more research to be sure.

upvoted 0 times

Carman

27 days ago

I checked the documentation, and it looks like C) surrogate key is the recommended transformation for upserts.

upvoted 0 times

...

Dalene

1 months ago

I'm not sure, I think D) alter row might also work. Let's double check the documentation.

upvoted 0 times

...

Gayla

1 months ago

I agree, surrogate key is the way to go for upserts.

upvoted 0 times

...

Kiley

1 months ago

I think you should go with C) surrogate key. It's commonly used for upsert operations.

upvoted 0 times

...

Veronica

2 months ago

D) alter row, of course! Alter row is designed for handling upserts and merges. It's the obvious choice here.

upvoted 0 times

...

Ezekiel

2 months ago

Hmm, I'm not sure. All of these options sound like they could work. I'll have to think this one through a bit more.

upvoted 0 times

Simona

29 days ago

User2: Yeah, that could work. It helps uniquely identify rows in the table.

upvoted 0 times

...

Kendra

1 months ago

User1: I think a surrogate key transformation might be the way to go.

upvoted 0 times

...

Denae

2 months ago

I think B) select is the way to go. You need to select the relevant columns for the upsert, right?

upvoted 0 times

Sunny

22 days ago

User4: Selecting the right columns will definitely help in the upsert process.

upvoted 0 times

...

Aja

26 days ago

User3: I agree, using the select transformation will help specify the logic for upserting the data.

upvoted 0 times

...

Hermila

1 months ago

Select transformation is essential for ensuring only the relevant data is included in the upsert operation.

upvoted 0 times

...

Cherry

1 months ago

Select is definitely the way to go for specifying the logic needed for upserting data into the sink.

upvoted 0 times

...

Gabriele

1 months ago

User2: Yes, that makes sense. Selecting the columns for the upsert is important.

upvoted 0 times

...

Tracey

2 months ago

User1: I think B) select is the way to go. You need to select the relevant columns for the upsert, right?

upvoted 0 times

...

Lindsey

2 months ago

I agree, using the select transformation will help filter out the necessary data for the upsert process.

upvoted 0 times

...

Roosevelt

2 months ago

Yes, B) select is the correct choice. It allows you to choose the specific columns needed for the upsert.

upvoted 0 times

...

Providencia

2 months ago

I'm not sure about that. I think the answer might be A) join, as it helps combine data from multiple sources before upserting.

upvoted 0 times

...

Genevive

3 months ago

I agree with Elinore. Surrogate key is used to uniquely identify rows in a table, which is essential for upsert operations.

upvoted 0 times

...

Elinore

3 months ago

I think the answer is C) surrogate key.

upvoted 0 times

...

Grover

3 months ago

D) alter row is the correct choice here. The question specifically asks for a transformation that specifies the logic for upserts, and alter row is the perfect fit for that requirement.

upvoted 0 times

Tasia

2 months ago

D) alter row

upvoted 0 times

...

Noah

2 months ago

C) surrogate key

upvoted 0 times

...

Luke

2 months ago

B) select

upvoted 0 times

...

Ruby

2 months ago

A) join

upvoted 0 times

...