Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 39 discussion

Actual exam question from Microsoft's PL-300

Question #: 39
Topic #: 2

You are creating a Power BI model that contains a table named Store. Store contains the following fields.

You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.
What should you do to ensure that the locations are mapped properly?

A. Change the data type of City, State/Province, and Country.
B. Set Summarization for City, State/Province, and Country to Don't summarize.
C. Set the data category of City, State/Province, and Country.
D. Create a calculated column that concatenates the values in City, State/Province, and Country.

Show Suggested Answer

Suggested Answer: C 🗳️

by NAWRESS96 at Sept. 9, 2022, 8:11 a.m.

Comments

Submit Cancel

Hoeishetmogelijk

Highly Voted 2 years, 8 months ago

Selected Answer: C

Answer is C. I only don't agree with the Hierarchy solution that is given in the answer. Data categorization is something else: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization

upvoted 44 times

...

PinkZebra

Highly Voted 2 years, 10 months ago

Selected Answer: C

Change the data category from "Text" to "Country", "State", "City" will work. See Source:https://www.youtube.com/watch?v=rvlv80WmTgc

upvoted 17 times

Fecov

1 year, 11 months ago

excellent anwer !!! here is the truth and right reason of the answer, not the hierarchy (also its important but its not related to the data category)

upvoted 1 times

...

jaume

Most Recent 8 months, 2 weeks ago

Selected Answer: C

I'm not sure what's exactly the difference between A and C, would not both options have the same result. I will vote for C as rest of people here assuming some of them have tested it and this is better than A

upvoted 1 times

jaume

8 months, 2 weeks ago

Just checked in PowerQuery Editor there is no "Country" data type, so I guess that means option A is not the same :-)

upvoted 1 times

...

rcaliandro

11 months, 3 weeks ago

Selected Answer: C

C - Set the data category of City, State/Province, and Country

upvoted 1 times

...

JohnChung

1 year, 6 months ago

Selected Answer: C

The answer should be C

upvoted 1 times

...

Dsbuff

1 year, 7 months ago

C is correct. Check it out here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization

upvoted 4 times

...

nick0651

1 year, 9 months ago

The answer is C

upvoted 1 times

...

WRTopics

1 year, 9 months ago

Selected Answer: A

This answer could be A or C. Both solutios works.

upvoted 1 times

...

Igetmyrole

1 year, 11 months ago

C is the correct answer. Setting the data category for these fields will allow Power BI to recognize them as location-related fields, enabling proper mapping and drilling down capabilities.

upvoted 1 times

...

NAZAOG

2 years, 2 months ago

I DONT THINK THE MAP WILL WORK IF THE DATA TYPE IS ON TEXT

upvoted 2 times

WRTopics

1 year, 9 months ago

yes it works.

upvoted 1 times

...

Shalaleh

2 years, 3 months ago

Selected Answer: C

Without setting Data Category, map does not work correctly.

upvoted 5 times

...

lizbette

2 years, 3 months ago

Selected Answer: C

the answer is correct but the explanation is wrong. has nothing to do with hierarchy. has everything to do with data categorization for geographical fields

upvoted 5 times