Exam PL-300 topic 1 question 22 discussion

DE is correct we only need the countries

Agree The table has tocontain unique values for "Country" column, so - delete the city column --> in fact this column is not requested - Remove dupicates from the Country column

DE is the right answer

DE are the correct answers

I'm not sure why you need E answer. They tell every answer is a part of solution. In the moment y firstly delete city column, you don't need specifically remove Country column, because is the only column you have, so B answer would be correct. Furthermore, as SOF_SH said: "Remove duplicate from a specific column does Not exist in Power BI, the action that does exist is Remove Duplicates." Tricky question, I'm not sure honestly.

DE is correct. We need just the country's column. Remove duplicates from the country's column and delete the city column to enhance performance.

why need to delete the city column ?

We all need the dimension to contain the list of unique countries. so we delete the city column because we don't need it and remove the duplicates from the country column. The correct answer is DE

correct

DE is correct we first remove the city column than we remove duplicates from the Country column

Correct answers are D and E, as they mentionned in the question, the need to create a "list of unique countries" so it will not make sense in removing only duplicates from country and leaving a column of uncompleted cities, so it's necessary to delete this column.

Remove duplicate from a specific column does Not exist in Power BI, the action that does exist is Remove Duplicates.

De is correct

DB should also be accepted since the table has only one row after deleting City column.

DE is correct, but feel like BD could also work, since it technically does the same thing

It was so easy that I was suspicious...

CONFUSING OPTIONS....BEST OPTION IS NEWCOUNTRY=ALLNOBLANKROW(COUNTRY[COUNTRY])