Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 1 Question 77 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 77
Topic #: 1
[All PL-300 Questions]

You have a prospective customer list that contains 1,500 rows of dat

a. 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.

Show Suggested Answer Hide Answer
Suggested Answer: E, C

In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set.

https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/


by Truman at Jan 27, 2026, 01:33 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Vivan
3 days ago
You know, if I had a dollar for every time I had to clean up a prospect list, I'd be a rich man!
upvoted 0 times
...
Kip
9 days ago
Haha, I bet the person who wrote this question has a secret love for Power Query. It's like their favorite toy!
upvoted 0 times
...
Lashon
14 days ago
Sounds good, but don't forget to check for any typos or inconsistencies in the State/Region field too.
upvoted 0 times
...
Curtis
19 days ago
Definitely, and then you can use the "Add Conditional Column" feature to flag any missing regions.
upvoted 0 times
...
Arminda
24 days ago
Hmm, I'd say filter the data by State/Region and then group by that field to see which ones are missing.
upvoted 0 times
...
Tanesha
29 days ago
I recall something about merging queries to ensure we have all states represented, but I can't remember the exact steps.
upvoted 0 times
...
Hildred
2 months ago
I feel like we also talked about removing duplicates, but I'm not sure if that's relevant for this question.
upvoted 0 times
...
Bea
2 months ago
I think we might need to group the data by State/Region to see if we have records for each one. That sounds familiar.
upvoted 0 times
...
Yolando
2 months ago
I remember we practiced filtering data by specific criteria in Power Query, but I'm not sure if that applies here.
upvoted 0 times
...
Elly
2 months ago
I think the key here is to make sure I have complete coverage of the states/regions I want to target. So I'd probably start by creating a list of the target states/regions, then check the data to see which ones are missing and try to fill in those gaps.
upvoted 0 times
...
Kimberely
2 months ago
Okay, so I'd definitely want to use some kind of grouping or aggregation function to get a count of the unique State/Region values. Then I could compare that to the list of states/regions I want to target and see where I'm missing data.
upvoted 0 times
...
Lenna
3 months ago
Hmm, I'm not sure what the best approach would be here. I guess I'd try to group the data by State/Region and see how many unique values there are. That might give me a sense of where I need to target my marketing.
upvoted 0 times
...
Katy
3 months ago
I think I'd start by checking the State/Region column to see if there are any missing values or duplicates. That would help me identify any gaps in the coverage.
upvoted 0 times
...

Save Cancel