What should you do?

You have a table named Sales that contains sales data for the United States. A sample of the data in Sales is shown in the following table.

When you attempt to create a map that shows SalesAmount by Zone, you discover that the map shows a bubble based on cities instead of states You need to ensure that the map shows bubbles based on states.
What should you do?
A. Add a column named Country that contains United States as the value.
B. Add a column for longitude and a column for latitude.
C. Select the Zone field. From the Modeling tab, change the Data Category.
D. Select the Zone field. From the Modeling tab, change the Data Type.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.