exam questions

Exam DP-100 All Questions

View all questions & answers for the DP-100 exam

Exam DP-100 topic 2 question 69 discussion

Actual exam question from Microsoft's DP-100
Question #: 69
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 Execute Python Script module.

Does the solution meet the goal?

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

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
Alex310andra
Highly Voted 2 years, 1 month ago
Why not?
upvoted 6 times
...
ajay0011
Highly Voted 2 years ago
Selected Answer: A
Yes, it is possible. with the script we can perform any operation
upvoted 5 times
chaymat
2 years ago
same here, with Python script, we can perform any operation
upvoted 3 times
...
...
25f71e3
Most Recent 8 months, 1 week ago
It is possible using the Execute Python Script module in Azure Machine Learning designer, but this approach is unnecessarily complex for this task. Use Add Rows instead. Poorly written question.
upvoted 1 times
...
bbe8966
10 months, 3 weeks ago
Selected Answer: B
No, The statement specifies that a dataset should be created with the same columns and contain all rows from both datasets. When performing a join, regardless of the type, we will not obtain a single dataframe with all the rows; this can only be achieved through concatenation.
upvoted 1 times
...
Karthikat
1 year, 1 month ago
on exam 3/25/2024
upvoted 1 times
...
NullVoider_0
1 year, 2 months ago
On exam 12-02-2024.
upvoted 1 times
...
Mikku123
1 year, 8 months ago
B seems the correct answer as the question explicitly states that you are using Azure Machine Learning designer to load the datasets into an experiment, and the Execute Python Script module is not used for loading datasets directly.
upvoted 4 times
...
Ahmed_Gehad
1 year, 9 months ago
Selected Answer: B
The Execute Python Script module can be used to execute Python code in Azure Machine Learning Studio. However, it cannot be used to create a dataset that has the same columns and header row as the input datasets and contains all rows from both input datasets.
upvoted 1 times
...
phydev
1 year, 9 months ago
On exam 20 July 2023.
upvoted 3 times
...
SovanMistry
1 year, 10 months ago
Selected Answer: A
With Script it's possible
upvoted 2 times
...
Dp_100_11
1 year, 11 months ago
Selected Answer: A
Within the Python script, you can read the input datasets, concatenate or merge the rows using pandas functions (e.g., pd.concat() or pd.merge()), and generate a new dataset that contains all rows from both inputs. By specifying the appropriate logic in the Python script, you can ensure that the resulting dataset has the same columns and header row as the input datasets.
upvoted 4 times
snegnik
1 year, 10 months ago
No, You use Azure Machine Learning designer
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago