Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
First take off tthe table City column then Remove duplicate from Country cell
* Answers: - D. Delete the City column. For a Country dimension, you only need the Country attribute. Remove other attributes (like City) so they don’t affect distinctness. - E. Remove duplicates from the Country column. After keeping only Country, use Remove Duplicates on that column to get a unique list of countries. * Why not the others? - A. Delete the Country column → You’d lose the very attribute you need. - B. Remove duplicates from the table → This only removes fully identical rows. If the same country appears with different cities, duplicates won’t be removed. - C. Remove duplicates from the City column → Irrelevant; you need uniqueness by Country, not by City.
not B, unless the order D --> B is considered. As two seperate actions are requested: DE