ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-100 All Questions

View all questions & answers for the DP-100 exam
Go to Exam

Exam DP-100 topic 3 question 34 discussion

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

DRAG DROP -
You create a training pipeline using the Azure Machine Learning designer. You upload a CSV file that contains the data from which you want to train your model.
You need to use the designer to create a pipeline that includes steps to perform the following tasks:
✑ Select the training features using the pandas filter method.
✑ Train a model based on the naive_bayes.GaussianNB algorithm.
✑ Return only the Scored Labels column by using the query
✑ SELECT [Scored Labels] FROM t1;
Which modules should you use? To answer, drag the appropriate modules to the appropriate locations. Each module name may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
by hendriktytgatpwc at March 14, 2021, 5:02 p.m.

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
Submit Cancel
JB246
Highly Voted 4 years, 2 months ago
1. Execute python script 2. Create Python mode (for using naive_bayes.GausianNB) 3. Apply SQL Transform https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/create-python-model https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/apply-sql-transformation
upvoted 74 times
gunn_m
7 months, 1 week ago
Totally agree with this answer
upvoted 1 times
...
dija123
3 years, 6 months ago
Totally agree with this answer
upvoted 1 times
...
Thornehead
3 years, 3 months ago
I couldn't find anything called naive_bayes.GaussianNB algorithm in the documentation link provided. So your answer is correct
upvoted 1 times
...
YipingRuan
3 years, 12 months ago
Create Python model (typo). But you are right!
upvoted 5 times
...
...
hendriktytgatpwc
Highly Voted 4 years, 3 months ago
I rebuild this network in Designer and the answer is totally wrong: It should be from top to bottom = Execute Python script (after dataset), before train model the 2 Class NN module, after scoring it should be SQL Transformation
upvoted 13 times
kty
4 years, 3 months ago
I agree
upvoted 2 times
kty
4 years, 3 months ago
and the question asks : Train a model based on the naive_bayes.GaussianNB algorithm. But there is not an option for this
upvoted 1 times
...
...
brendal89
4 years, 3 months ago
That can't be correct since they are asking for Naive Bayes * box 1: execute Python script (the only way to use the pandas filter method) * box 2: exectue python script (see: https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/create-python-model) * box 3: apply SQL transformation (the SELECT statement indicates we should use SQL here)
upvoted 12 times
bruce
4 years, 2 months ago
Should it be Create python model for the 2nd?
upvoted 8 times
...
...
...
gtyeap87
Most Recent 8 months, 3 weeks ago
It should be 1. Select columns in dataset 2. Create Phython model 3.Execute Phython script https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/create-python-model?view=azureml-api-2
upvoted 3 times
...
LM12
12 months ago
1. select cols 2. Create model 3. execute python script. The exact example here : https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/create-python-model?view=azureml-api-2
upvoted 2 times
...
phdykd
1 year, 11 months ago
SLECT COLUMNS, CREATE PYTHON MODEL, APPLY SQL TRANSFORMATION
upvoted 1 times
...
umair_hanu
1 year, 11 months ago
a)select column in dataset b)python model c)python script
upvoted 1 times
...
MattAnya
2 years, 6 months ago
on 03 Jan 2023
upvoted 5 times
...
therealola
3 years ago
on exam 18-06-22 ------ 1. Execute python script 2. Create Python model 3. Apply SQL Transform
upvoted 6 times
...
ning
3 years, 1 month ago
1. select columns 2. NB model 3. SQL Transform My answer will be that ...
upvoted 2 times
ning
3 years, 1 month ago
Read question again ... 1. If have to use pandas filter, then script 2. If Bayes is the algorithm, then python model
upvoted 1 times
...
...
JTWang
3 years, 2 months ago
on exam 04/22/2022
upvoted 2 times
...
kkkk_jjjj
3 years, 3 months ago
on exam 18/03/2022
upvoted 3 times
...
TheYazan
3 years, 3 months ago
On march 2022
upvoted 1 times
...
Tushazz
3 years, 6 months ago
1.left side box:execute python script. 2.Select columns in dataset 3.apply SQL transformation
upvoted 1 times
...
JoshuaXu
3 years, 8 months ago
On 6 Nov 2021, agree with the highest voted answer (by JB246).
upvoted 1 times
...
farahpeebs
3 years, 8 months ago
It should be: Box 1: Select columns in dataset Box 2: Create python model Box 3: Execute python script Based on this link: https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/create-python-model
upvoted 8 times
AjoseO
3 years, 4 months ago
Correct!
upvoted 1 times
...
...
skrjha20
3 years, 8 months ago
Select columns ftom dataset create model Apply SQL Transformations
upvoted 1 times
...
skrjha20
3 years, 9 months ago
1.Select columns in dataset 2.Create Python Model 3.Execute Python Script https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/create-python-model
upvoted 4 times
...
Load full discussion...
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