exam questions

Exam DP-100 All Questions

View all questions & answers for the DP-100 exam

Exam DP-100 topic 2 question 32 discussion

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

You are analyzing a dataset by using Azure Machine Learning Studio.
You need to generate a statistical summary that contains the p-value and the unique count for each feature column.
Which two modules can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Computer Linear Correlation
  • B. Export Count Table
  • C. Execute Python Script
  • D. Convert to Indicator Values
  • E. Summarize Data
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️

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
lucazav
Highly Voted 3 years, 1 month ago
Summarize Data module output also has the following columns: P0.5, P1, P5, P95, P99, P99.5 Probably the person in charge of these tests was not very prepared and did not even check Microsoft's docs, so he confused "percentile" values with "p-" values. By the way, "p-values" of what!?
upvoted 32 times
azurelearner666
1 year, 8 months ago
Fully agree, sometimes the questions are a bit "off" (and that's polite...)
upvoted 2 times
...
kty
2 years, 8 months ago
:))))))
upvoted 1 times
...
Arend78
1 year ago
Indeed, very confusing. Thanks for mentioning this!
upvoted 2 times
...
...
phdykd
Highly Voted 10 months, 1 week ago
C. Execute Python Script E. Summarize Data In Azure Machine Learning Studio, you can use the "Summarize Data" module to generate a statistical summary that includes unique count and basic statistics such as mean, standard deviation, minimum, maximum, and quartiles for each feature column. To calculate p-value, you would need to use a "Execute Python Script" module and write a custom code to perform the hypothesis test and compute the p-value. The "Export Count Table" module in Azure Machine Learning Studio only provides a count of the number of instances of each unique value in a single feature column, it doesn't provide statistical summary information like the mean, standard deviation, minimum, maximum, quartiles, or p-value. To get the p-value and a more comprehensive statistical summary, you would need to use the "Execute Python Script" module and write custom code as described in my previous answer.
upvoted 11 times
...
MarinaMijailovic
Most Recent 6 months, 4 weeks ago
Selected Answer: CE
C. Execute Python Script E. Summarize Data The "Execute Python Script" module allows you to run your own Python script, which can be used to calculate any statistic, including unique counts and p-values. The "Summarize Data" module in Azure Machine Learning Studio provides a statistical summary of the input dataset, including count, mean, mode, standard deviation, minimum, and maximum. And like somebody mentioned, it should be percentile and not p-value.
upvoted 3 times
...
Edriv
12 months ago
Options AD
upvoted 1 times
...
kty
2 years, 8 months ago
Answer is just 'C'
upvoted 4 times
...
saurabhk1
2 years, 9 months ago
Actually, the question is not clear about which type of p-value, it wants to calculate. Only module that can do it is "Execute a python script"
upvoted 4 times
...
Askme101
2 years, 11 months ago
it should say percentile values
upvoted 3 times
...
modschegiebsch
3 years, 5 months ago
Isn't "Execute a python script" actually the only option to calculate the p-value?
upvoted 7 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 ...