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.
in power query duplicate operation if case sensitive like "Apple" and apple are two different texts for powerquery.
The main aim is to remove duplicates. The 'remove duplicate values' in in power query is case sensitive, so you need to perform E first in order to remove duplicates.
The correct answers are: **B. Remove duplicate values.** **E. Apply a Capitalize Each Word transform.** Together, these steps: * **E** standardizes the country names so that different cases (e.g., "afganistan" vs "Afganistan") match. * **B** then removes duplicates after the names are standardized, ensuring each country appears only once. Perfect choice!