- (Exam Topic 3)
You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?
Correct Answer:A
Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter
Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.
The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.
Reference:
https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi
- (Exam Topic 4)
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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
Due Date Order Date
Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table. Does this meet the goal?
Correct Answer:A
- (Exam Topic 4)
You have the following table named Location.
The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)
You need to ensure that the map displays the country locations. What should you do?
Correct Answer:B
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
- (Exam Topic 4)
You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data. Which report setting should you configure?
Correct Answer:E
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/
- (Exam Topic 4)
ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
Correct Answer:B
Disable Power Query load.
Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query-quer