Exam PL-300 topic 1 question 53 discussion

Actual exam question from Microsoft's PL-300

Question #: 53
Topic #: 1

You have a table named DIMCountries that contains a column named Country as shown in the following table.

You plan to use DIMCountries as a dimension in a report.

You need to ensure that the Country column in DIMCountries lists each country only once.

Which two actions should you perform on the Country column? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

A. Change Data category to Country.
B. Remove duplicate values.
C. Apply a clean transform.
D. Replace the empty fields.
E. Apply a Capitalize Each Word transform.

Show Suggested Answer

Suggested Answer: BE 🗳️

by 13a8051 at June 13, 2025, 8:57 p.m.

Comments

Submit Cancel

13a8051

Highly Voted 1 month, 2 weeks ago

Selected Answer: BD

The two correct actions are: B. Remove duplicate values This will ensure each country appears only once by removing duplicate rows in the Country column. D. Replace the empty fields This ensures that there are no blank or null values in the Country column, which might otherwise appear as missing or extra entries.

upvoted 6 times

...

225401f

Highly Voted 1 month, 2 weeks ago

Selected Answer: BE

Correct answer is B E

upvoted 5 times

...

Lulu_2022

Most Recent 3 weeks, 1 day ago

Selected Answer: BE

- B. Remove duplicate values → This directly guarantees that each country is represented only once in your dimension table—essential for proper slicer and relationship behavior. - E. Apply a Capitalize Each Word transform → Power Query is case-sensitive, so "canada" ≠ "Canada" when removing duplicates. Capitalizing ensures consistent casing before deduplication.

upvoted 1 times

...

dca556d

1 month, 1 week ago

Selected Answer: BE

Power Query is case-sensitive, so Remove Duplicates alone will not remove duplicate values that differ only in letter casing. Why not D? - Replacing empty fields won't solve the problem because no matter what we replace the empty values with, they will still remain.

upvoted 3 times

...