PL-300 Visualize and analyze the data Practice Question
Your Power BI report includes a map visual showing store locations. However, some locations are not appearing correctly because of ambiguous place names. What should you do to ensure accurate geocoding?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use latitude and longitude fields instead of location names
Using latitude and longitude fields bypasses Bing's geocoding, ensuring accuracy. Changing the map style does not fix geocoding, using a filled map is for regions, and a bubble chart is not geographic.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Aggregate the data by country
Why it's wrong here
Aggregating store data by country would not fix incorrect mapping; it only reduces the visual's granularity. Power BI's map visuals geocode based on the location field you provide — if that field contains ambiguous or misspelled names, aggregating to a coarser level like country may still misplace a store if the country name itself is ambiguous or unrecognized. More importantly, you lose all store-level detail, making the report useless for analyzing individual store performance or exact locations. The root cause of mis-geocoding is the location string's quality, not the aggregation level.
- ✗
Switch to a bubble chart
Why it's wrong here
A bubble chart is not a geographic visualization; it uses numeric X and Y axes (e.g., sales vs. profit) and has no concept of latitude/longitude or map projection. Replacing a map with a bubble chart would completely abandon spatial context, so you could not see where stores are located relative to each other or to geographic boundaries. It also does not involve geocoding at all, so it cannot solve a problem caused by Power BI misinterpreting a location name. Bubble charts are for relational or outlier analysis, not for showing store locations on a map.
- ✓
Use latitude and longitude fields instead of location names
Why this is correct
Using latitude and longitude fields instead of location names is the correct fix because it bypasses Bing Maps geocoding entirely. When Power BI reads numeric latitude and longitude, it plots points directly at those exact coordinates, eliminating any ambiguity from store names, cities, or countries that might be misspelled, duplicated, or non-standard. This approach ensures each store appears at its precise physical location, and it is the recommended practice whenever your data source contains coordinate data. It also avoids the overhead and potential failure of geocoding requests, making the report more reliable and faster to render.
- ✗
Change the map visual to a filled map
Why it's wrong here
A filled map (choropleth) does not solve geocoding errors; it still relies on Bing Maps to match a region name (country, state, or county) to a geographic boundary. Filled maps are designed to shade entire regions based on aggregated values, not to plot individual store points at exact addresses or coordinates. If a store's location name is incorrectly matched, the filled map will shade the wrong region or fail to include the data altogether. Furthermore, replacing a point map with a filled map changes the visual type and loses store-level point placement, so it cannot fix the underlying geocoding issue.
About these practice questions
Courseiva writes every PL-300 question from scratch — 524 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on PL-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You have a Power BI report that shows sales by region. The map visual displays regions with incorrect boundaries. What is the most likely cause?
easy- A.The map visual is not the best choice for the data.
- B.The data source is not refreshed.
- C.The map labels are overlapping.
- ✓ D.Bing Maps geocoding inaccuracies.
Why D: The correct answer is D: Bing Maps geocoding inaccuracies. Power BI's map and filled map visuals rely on Bing Maps to geocode location data (such as region names) into geographic shapes, and ambiguous or non-standard region names can be matched to the wrong boundaries, producing incorrect shapes. This is the most likely cause of misdrawn region boundaries, since the visual itself is functioning but the geocoding lookup resolves to the wrong place. Option A is incorrect because visual choice affects suitability, not boundary accuracy. Option B is incorrect because a stale data source would show outdated values, not wrong geographic boundaries. Option C is incorrect because overlapping labels are a formatting/rendering issue, not a cause of incorrect region shapes.
Variation 2. You have a Power BI report that uses a map visual to show store locations. Some stores have the same latitude and longitude. You want to distinguish overlapping points. Which visual feature should you use?
easy- A.ArcGIS map
- ✓ B.Bubble map with bubble size set to a measure
- C.Filled map
- D.Shape map
Why B: The bubble map with size set to a measure allows distinguishing overlapping points. Option A is incorrect because ArcGIS maps also show points and can have overlapping issues. Option C is incorrect because filled maps display regions, not individual points. Option D is incorrect because shape maps display regions, not points.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.