Free Microsoft PL-300 Exam Questions

You have a table named DiMCountries that contains a column named Country as shown in the following table.You plan to use DiMCountnes as a dimension m a report. You new to ensure that the Country column in DiMCountnes lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point. 

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months. Which type of visualization should you use?

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.

Vou have a Microsoft Power Bl Desktop report named Report! that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1. You need to simplify the connection to the data source for User1. Which type of file should you create?