Exam PL-300 topic 1 question 37 discussion

Actual exam question from Microsoft's PL-300

Question #: 37
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a data source that contains a column. The column contains case sensitive data.

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You change the semantic model mode.

Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by kenyJen at Sept. 5, 2024, 9:28 a.m.

Comments

Submit Cancel

Fatima300

4 months, 1 week ago

Selected Answer: 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.

upvoted 2 times

...

FraGuara

9 months ago

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.

upvoted 1 times

BhavnishM

2 months, 1 week ago

it is no where written in the question that error is due to case sensitivity. You need to transform the data here and not change the semantic model mode. So, the answer is NO.

upvoted 1 times

...