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.
Changing the semantic model mode will allow us to transform the data. But it does not mention transforming the data. So the change of mode is not enough to resolve the issue alone. It is B.
B. No Changing the semantic model mode (e.g., from DirectQuery to Import) won't fix case sensitivity issues or errors in the data. You need to transform or clean the data to resolve these issues.
My answer would be A. Yes: Switching from DirectQuery to Import mode would resolve the issue with case sensitivity. Power Query can handle case sensitivity effectively, but its functions are limited when operating in DirectQuery mode. By switching to Import mode, you gain full access to Power Query's data transformation capabilities, allowing you to standardize the case of your data before it is loaded into the model.