exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 1 question 5 discussion

Actual exam question from Microsoft's DA-100
Question #: 5
Topic #: 1
[All DA-100 Questions]

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
✑ First name
✑ Last name
✑ Email address
✑ State/Region
✑ Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Open the Advanced Editor.
  • B. Select Column quality.
  • C. Enable Column profiling based on entire dataset.
  • D. Select Column distribution.
  • E. Select Column profile.
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
ammu
Highly Voted 4 years, 1 month ago
Answer in C and E Question has it has part of answer. Enable Column profiling based on entire dataset and then Select Column Profile
upvoted 85 times
...
dlring
Highly Voted 4 years, 1 month ago
Answer in C and E. Column Profile can show distinct and unique count of select field. The key point is the customer list contains 1,500 rows of data. Column Profile Notes: If you are reviewing a large dataset with more than 1,000 rows, and you want to analyze that whole dataset, you need to change the default option at the bottom of the window. Select Column profiling based on top 1000 rows => Column profiling based on entire data set.
upvoted 47 times
...
Oum123
Most Recent 2 years, 10 months ago
C and E for me
upvoted 2 times
...
MichalP78
2 years, 10 months ago
Selected Answer: CE
Definitely C,E (since it's over 1000 rows) - Column profiling based on entire data set can be switched on the bottom next to the number of rows.
upvoted 3 times
...
Matreshka
3 years ago
Selected Answer: CE
Answer C and E
upvoted 1 times
...
Miihir
3 years ago
Selected Answer: CD
calumn distribution and column profiling on all rows will give the required result. How can C and E be the correct answers?
upvoted 2 times
Jew0598
2 years, 1 month ago
How does column distribution help when it only gives distinct and unique counts?
upvoted 1 times
...
...
Mona00
3 years ago
Selected Answer: CE
Should be C and E
upvoted 2 times
...
sara_004
3 years, 1 month ago
Selected Answer: CE
Should be C and E
upvoted 2 times
...
HarvinderN
3 years, 2 months ago
Selected Answer: CE
The answer is C and E.
upvoted 3 times
...
tim257
3 years, 3 months ago
Answer in C and E C-Enable Column profiling based on entire dataset so the profiling can reach 1500 row (1000 without that option) E- Select Column Profile, because we need to see the distribution of the column State/Region to check if the desired State/Region are present ( the answer D is not correct because the column distribution option shows the distribution of the column without showing for which value of the column, unlike the distribution of the profile column which is more detailed)
upvoted 3 times
...
HarvinderN
3 years, 3 months ago
Selected Answer: CE
The answer is CE.
upvoted 3 times
...
Funboy
3 years, 3 months ago
So when examtopics.com says the answer is D and E, it's wrong? (as most people seem to say C and E, which I agree with!)
upvoted 1 times
...
HarvinderN
3 years, 3 months ago
Selected Answer: CE
Key is 1500 Rows
upvoted 2 times
...
AshayS
3 years, 3 months ago
In Exam Dt 5th March 2022. I answered C and E. Option Sequence was different.
upvoted 1 times
pyadav
2 years, 10 months ago
Did we receive questions from this data?
upvoted 1 times
...
...
Ashley090521
3 years, 3 months ago
on exam 3/1/2022
upvoted 1 times
...
Sudhansu21
3 years, 3 months ago
On Exam Feb, 2022
upvoted 1 times
...
Ankit_da
3 years, 4 months ago
this question present on 24/02/2022
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 ...