New Year Sale 2026! 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
Hildred
5 days 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
10 days 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
15 days 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
20 days 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
25 days 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
1 month 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
1 month 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