SAP Exam C_DS_42 Topic 11 Question 62 Discussion

Actual exam question for SAP's C_DS_42 exam

Question #: 62
Topic #: 11

You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.

What is the best way to achieve this in SAP Data services?

AUse twelve query transform to create the desired output. Then combine these transforms.

BUse the query transform with multiple IFTHENELSE() functions.

CUse the merge transform that is connected to the source

DUse the pivot transform with two pivot sets.

Show Suggested Answer

Suggested Answer: D

by Tammara at Mar 10, 2024, 04:59 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Cristina

1 years ago

That could work too, but pivot transform seems more efficient in this case.

upvoted 0 times

...

Dorothea

1 years ago

I'm just imagining the poor developer who has to maintain that twelve query transform solution. Option D is the way to go, no doubt.

upvoted 0 times

Laurena

11 months ago

Option D) Use the pivot transform with two pivot sets.

upvoted 0 times

...

Kathrine

12 months ago

Option C) Use the merge transform that is connected to the source

upvoted 0 times

...

Denny

12 months ago

Option D) Use the pivot transform with two pivot sets.

upvoted 0 times

...

Francesco

12 months ago

Option B) Use the query transform with multiple IFTHENELSE() functions.

upvoted 0 times

...

Wilda

12 months ago

Option C) Use the merge transform that is connected to the source

upvoted 0 times

...

Sommer

12 months ago

Option B) Use the query transform with multiple IFTHENELSE() functions.

upvoted 0 times

...

Louvenia

12 months ago

Option A) Use twelve query transform to create the desired output. Then combine these transforms.

upvoted 0 times

...

Cammy

1 years ago

Option A) Use twelve query transform to create the desired output. Then combine these transforms.

upvoted 0 times

...

Timothy

1 years ago

But wouldn't it be easier to use twelve query transforms and then combine them?

upvoted 0 times

...

Joye

1 years ago

I agree with Cristina. Using pivot transform will make it easier to get the table with twelve rows and two columns.

upvoted 0 times

...

Leah

1 years ago

The IFTHENELSE() functions in option B could get pretty messy and hard to maintain. Pivot transform for the win!

upvoted 0 times

Nohemi

1 years ago

Pivot transform is definitely the way to go for this task.

upvoted 0 times

...

Stephaine

1 years ago

I agree, using IFTHENELSE() functions can be confusing.

upvoted 0 times

...

Cristina

1 years ago

I think the best way is to use the pivot transform with two pivot sets.

upvoted 0 times

...

Orville

1 years ago

I prefer using the merge transform connected to the source for better data integration.

upvoted 0 times

...

Serita

1 years ago

Haha, using twelve query transforms to create the output? That's just overkill. Option D is the clear winner in my opinion.

upvoted 0 times

Felicidad

1 years ago

I think using the pivot transform with two pivot sets is definitely the most efficient option.

upvoted 0 times

...

Emerson

1 years ago

I agree, using twelve query transforms seems like a lot of unnecessary work.

upvoted 0 times

...

Martha

1 years ago

I'm not sure about the merge transform in option C. Isn't that more for combining multiple inputs? I think the pivot transform is the way to go here.

upvoted 0 times

Hoa

1 years ago

I think using twelve query transforms and then combining them might be too complicated. The pivot transform sounds simpler.

upvoted 0 times

...

Edward

1 years ago

I agree, using the pivot transform with two pivot sets seems like the best option.

upvoted 0 times

...

Jamey

1 years ago

I agree, using the pivot transform would simplify the process.

upvoted 0 times

...

Stanton

1 years ago

Option D definitely looks the best. Using the pivot transform with two pivot sets is the most efficient way to get the desired output.

upvoted 0 times

Dortha

1 years ago

Using the pivot transform with two pivot sets is the most efficient way to get the desired output.

upvoted 0 times

...

Katina

1 years ago

Option D definitely looks the best.

upvoted 0 times

...

German

1 years ago

I think the best way is to use the pivot transform with two pivot sets.

upvoted 0 times

...