ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 39 discussion

Actual exam question from Microsoft's PL-300
Question #: 39
Topic #: 2
[All PL-300 Questions]

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 Hide Answer
Suggested Answer: C 🗳️
by NAWRESS96 at Sept. 9, 2022, 8:11 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Hoeishetmogelijk
Highly Voted 2 years, 5 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, 6 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 16 times
Fecov
1 year, 8 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 5 months, 1 week 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
5 months, 1 week 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
8 months, 2 weeks ago
Selected Answer: C
C - Set the data category of City, State/Province, and Country
upvoted 1 times
...
JohnChung
1 year, 2 months ago
Selected Answer: C
The answer should be C
upvoted 1 times
...
Dsbuff
1 year, 4 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, 6 months ago
The answer is C
upvoted 1 times
...
WRTopics
1 year, 6 months ago
Selected Answer: A
This answer could be A or C. Both solutios works.
upvoted 1 times
...
Igetmyrole
1 year, 7 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
1 year, 10 months ago
I DONT THINK THE MAP WILL WORK IF THE DATA TYPE IS ON TEXT
upvoted 2 times
WRTopics
1 year, 6 months ago
yes it works.
upvoted 1 times
...
...
Shalaleh
1 year, 12 months ago
Selected Answer: C
Without setting Data Category, map does not work correctly.
upvoted 5 times
...
lizbette
1 year, 12 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
lizbette
1 year, 12 months ago
an alternative to data categorization is if we had latitude/longitude fields. however, that is not an option here
upvoted 1 times
...
...
RazaTheLegend
2 years ago
Selected Answer: C
Answer is C. Data categorization is something else: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization
upvoted 5 times
...
Taras_Navakhatska
2 years, 2 months ago
Don't we need to change data type from "Text" if we want to creat a map? It's really strange.
upvoted 1 times
Shalaleh
2 years, 1 month ago
for me also. I think first we should change data type and then create a hierarchy because of Drill down part
upvoted 1 times
...
joaowendling
1 year, 12 months ago
No, the data type will continue to be text. You might be confusing it for the data category
upvoted 1 times
...
...
jboiret
2 years, 4 months ago
Selected Answer: C
Answer C
upvoted 1 times
...
csillag
2 years, 4 months ago
Selected Answer: C
C is correct
upvoted 2 times
...
Patrick666
2 years, 4 months ago
Answer is correct
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago