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

4 months ago

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

upvoted 0 times

...

Dorothea

4 months 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

3 months ago

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

upvoted 0 times

...

Kathrine

3 months ago

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

upvoted 0 times

...

Denny

3 months ago

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

upvoted 0 times

...

Francesco

4 months ago

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

upvoted 0 times

...

Wilda

4 months ago

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

upvoted 0 times

...

Sommer

4 months ago

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

upvoted 0 times

...

Louvenia

4 months ago

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

upvoted 0 times

...

Cammy

4 months ago

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

upvoted 0 times

...

Timothy

4 months ago

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

upvoted 0 times

...

Joye

5 months 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

5 months ago

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

upvoted 0 times

Nohemi

4 months ago

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

upvoted 0 times

...

Stephaine

4 months ago

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

upvoted 0 times

...

Cristina

5 months ago

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

upvoted 0 times

...

Orville

5 months ago

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

upvoted 0 times

...

Serita

5 months 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

4 months ago

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

upvoted 0 times

...

Emerson

5 months ago

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

upvoted 0 times

...

Martha

5 months 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

5 months ago

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

upvoted 0 times

...

Edward

5 months ago

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

upvoted 0 times

...

Jamey

5 months ago

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

upvoted 0 times

...

Stanton

5 months 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

5 months ago

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

upvoted 0 times

...

Katina

5 months ago

Option D definitely looks the best.

upvoted 0 times

...

German

6 months ago

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

upvoted 0 times

...