SAP Exam C_DS_42 Topic 9 Question 63 Discussion

Actual exam question for SAP's C_DS_42 exam

Question #: 63
Topic #: 9

The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question There are 2 correct answers

AThe merge transform combines the dataset into 5000 or less output rows.

BThe merge transform combines the dataset into 5000 output rows

CThe merge transform joins the datasets using a full outer join

DThe merge transform require both dataset to have the same structure.

Show Suggested Answer

Suggested Answer: C, D

by Fausto at Mar 19, 2024, 05:04 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Page

5 months ago

I think B) is correct because it mentions 5000 output rows, which covers all the rows in both datasets

upvoted 0 times

...

Tayna

5 months ago

I'm not sure about B), but I'm confident about A) and D)

upvoted 0 times

...

Maryann

5 months ago

I believe B) and D) are the correct answers

upvoted 0 times

...

Stefania

5 months ago

Okay, brain engaged now. I'm pretty sure the merge transform combines the datasets, but the exact number of output rows depends on the join type. I'd go with A and C as the right answers.

upvoted 0 times

...

Argelia

5 months ago

Wait, are we talking about merging datasets or creating a recipe for the world's largest lasagna? 5000 rows, huh? Sounds like a challenge I'm willing to accept!

upvoted 0 times

Jose

4 months ago

B) The merge transform combines the dataset into 5000 output rows

upvoted 0 times

...

Oretha

4 months ago

A) The merge transform combines the dataset into 5000 or less output rows.

upvoted 0 times

...

Page

5 months ago

I agree with A), but I think C) is also correct

upvoted 0 times

...

Tayna

5 months ago

I think the correct answers are A) and D)

upvoted 0 times

...

Rashida

5 months ago

I think B) is correct because it mentions 5000 output rows, which covers all the rows in both datasets

upvoted 0 times

...

Melina

5 months ago

I'm not sure about B), but I'm confident about A) and D)

upvoted 0 times

...

Maia

5 months ago

As long as the merge transform doesn't create a black hole and swallow up all the data, I'm good with it! But seriously, I think A and C are the correct answers here.

upvoted 0 times

...

Steffanie

5 months ago

Option C seems right - a full outer join makes sense for merging datasets. And option D is clearly wrong, the datasets don't need the same structure.

upvoted 0 times

Jose

5 months ago

C) The merge transform joins the datasets using a full outer join.

upvoted 0 times

...

Teri

5 months ago

A) The merge transform combines the dataset into 5000 or less output rows.

upvoted 0 times

...

Kris

6 months ago

The merge transform definitely combines the datasets, but I'm not sure about the exact number of output rows. I think it's A or B, but I'd need to double-check the documentation to be sure.

upvoted 0 times