Confidently Practice Online with Free PL-300 Exam Cram

You need to create a visual that compares profit across 10 product categories for a selected quarter.

What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select

the BEST answer.

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis: • The count of orders and the sum of total sales by Order Date • The count of customers who placed an order • The average quantity per order You need to reduce data refresh times and report query times. Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

You have a Power BI data model 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 three dates at the same time.

Solution: From the Data pane, you rename the date table as Due Date. You use a DAX expression to

create Order Date and Deliver Date as calculated tables. You create active relationships between the

sales table and each date table.

Does this meet the goal? 

You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use? 

In Power BI Desktop, you have a dataset that contains a table. You create a table visual on a Power BI report page as shown in the following exhibit

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column. What should you do?