Exam DP-100 topic 1 question 26 discussion

No is Correct answer. Add Columns need to be used. Join data is needed only for database style joins https://docs.microsoft.com/bs-cyrl-ba/azure/machine-learning/component-reference/add-columns https://docs.microsoft.com/bs-cyrl-ba/azure/machine-learning/component-reference/join-data

The "Join Data" module in Azure Machine Learning Studio allows you to merge two datasets based on a common key or keys. This is particularly useful when you want to augment your existing dataset with additional information from another source. For example, if you have a dataset of sales transactions and another dataset with product information, you could use the "Join Data" module to add product details (a new feature) to the sales transactions dataset by joining on a product ID column present in both datasets.

The 'Join Data' module in Microsoft Azure Machine Learning Studio (classic) is used to merge two datasets using a database-style join operation. If you want to add a feature to the dataset and FILL COLUMN VALUE --> No. Join dataset https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/join-data?view=azureml-api-2

This is the answer.

Answer is correct. I tested it multiple times and got error regarding the size. You need to use "add columns" if you want to add two dataset together.

Join Data Azure Machine Learning Studio is a data transformation tool

If you want to add a colom with a new feature you will need data. This data could be in a secondery dataset which needs to be joined to the original dataset via a join. A could be correct. Concidering that it would be B, how would I fill the column? Manualy? That sounds like a unlogical option concidering that the datasets are usualy pretty big and not made up.

JOIN implies a query, not inserting a column to a database.

B. No The Join Data module in Azure Machine Learning Studio is used to combine two datasets by matching values in key columns. It is not a general-purpose tool for adding features or filling column values in a single dataset.

Option B

To perform a join on two datasets, they should be related by a key column. Composite keys using multiple columns are also supported. Add the datasets you want to combine, and then drag the Join Data component into your pipeline.

join is used for datasets not for columns b is correct

This is possible

Don't use Join Data Use Add Columns

I think Yes is correct. The second dataset might be a key which is joined with a second column being the extra column to add to the dataset.