exam questions

Exam DP-100 All Questions

View all questions & answers for the DP-100 exam

Exam DP-100 topic 2 question 109 discussion

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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You use Azure Machine Learning designer to load the following datasets into an experiment:


Dataset1 -



Dataset2 -


You need to create a dataset that has the same columns and header row as the input datasets and contains all rows from both input datasets.

Solution: Use the Join Data module.

Does the solution meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
f82411e
2 months, 3 weeks ago
Selected Answer: B
Debes usar el módulo Add Rows
upvoted 1 times
...
avinyc
7 months, 2 weeks ago
Selected Answer: B
"Join Data" is for SQL type joins, "Add Rows" will be suitable in this case. Hence the solution does not meet the guideline.
upvoted 1 times
...
jojashi
8 months, 3 weeks ago
Selected Answer: B
Correct. B I checked on the Designer module description.. Module: Join Data Description: Joins two datasets on selected key columns. we don't need to select key columns and there is no matching rows. We only need to append data. So, Add Row module is right
upvoted 1 times
...
kay1101
9 months ago
not sure about this one, thought it would be append more than join.
upvoted 1 times
...
sl_mslconsulting
9 months ago
Selected Answer: B
It won't work using the Join Data even you use Full Outer Join For each of the rows in either table that have no matching rows in the other, the result includes a row containing missing values.
upvoted 1 times
...
Plb2
11 months, 4 weeks ago
Yes this should work, FULL OUTER JOIN is supported https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/join-data?view=azureml-api-2#how-to-configure-join-data
upvoted 1 times
Plb2
11 months, 4 weeks ago
whereas on Apply SQL transformation (one of the other questions) FULL OUTER JOIN is not supported; https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/apply-sql-transformation?view=azureml-api-2
upvoted 1 times
...
...
zishankamal
1 year ago
Selected Answer: A
We use the Join Data component to merge two datasets using a database-style join operation. Full Outer Join: A full outer join returns all rows from the left table (table1) and from the right table (table2). https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/join-data?view=azureml-api-2 "Add Rows" or "Execute Python Script" are also possible ways to do this.
upvoted 1 times
...
edogawa
1 year, 4 months ago
It is the 'Add Rows' component which does it.
upvoted 2 times
...
umair_hanu
1 year, 7 months ago
b is correct
upvoted 2 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 ...