Question 101 of 388
Choose 2You 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 numberYou 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.
AOpen the Advanced Editor.
BSelect Column quality.
✓CEnable Column profiling based on entire dataset.
DSelect Column distribution.
✓ESelect Column profile.
✓
Correct Answer: C, E
Enable Column profiling based on entire dataset.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.