Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 38 discussion

Actual exam question from Microsoft's PL-300

Question #: 38
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 normalize casing in the source query or Power Query Editor.

Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️

by hy00 at Sept. 11, 2024, 11:24 a.m.

Comments

Submit Cancel

lechuc508

2 months, 1 week ago

Selected Answer: A

A is the correct answer

upvoted 1 times

...

BhavnishM

3 months, 2 weeks ago

Selected Answer: B

You need to check the column quality, column profile to solve the issue. Changing the CASE will not resolve undefined errors.

upvoted 1 times

...

Garrison

6 months ago

Selected Answer: A

Why is every question so convoluted lol, theres like 3 total questions in this thing that everyone agrees on

upvoted 2 times

...

aa83599

6 months ago

Selected Answer: B

'Undefined Values' cannot be fixed by adjusting casing

upvoted 2 times

...

SylUK

6 months, 2 weeks ago

Selected Answer: A

A is the answer because the main objective of normalization, is to eliminate redundancy, minimize data modification errors and simplify the query process.

upvoted 1 times

...

Srilatha_B

6 months, 3 weeks ago

Selected Answer: A

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types See Note as you scroll down

upvoted 4 times

...

jaume

8 months ago

In Q36 I voted "No" answer as converting values to required types maybe could fix some unidentified values but I don't think that would fix the errors. Now, although information in the link shared by f3ecb98 and fgo states details bout case sensitivity difference in the PBI engine and PBI tool, I should keep opinion normalize casing could fix some undefined values but don't think this could fix the errors so my vote is for the second option B.No

upvoted 4 times

...

fgo

8 months, 2 weeks ago

For me Answer is NO I didn't see how "normalize casing in the source query or Power Query Editor" can address the issue of undefined values and errors in the model ?

upvoted 1 times

fgo

8 months, 2 weeks ago

I review my post Answer is A see the not below from note https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types Note Because the engine that stores and queries data in Power BI is case insensitive, take special care when you work in DirectQuery mode with a case-sensitive source. Power BI assumes that the source has eliminated duplicate rows. Because Power BI is case insensitive, it treats two values that differ only by case as duplicate, whereas the source might not treat them as such. In such cases, the final result is undefined. To avoid this situation, if you use DirectQuery mode with a case-sensitive data source, normalize casing in the source query or in Power Query Editor.

upvoted 11 times

...

f3ecb98

9 months, 1 week ago

Selected Answer: A

This exact scenario is explained in the docs (at the "Case sensitivity" part): https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types. According to Microsoft, normalize casing in the source query should be the solution.

upvoted 4 times

...

VladStan

10 months, 1 week ago

The questions says "OR": So, either "Power Query Editor" (which is IMO wrong due to Direct Query mode) OR "You normalize casing in the source query" (which is true, again IMO) I would say that the answer is "A - Yes"

upvoted 2 times

...