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

1 day, 19 hours 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 3 times

...