Free Microsoft PL-300 Exam Questions

Question 1

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?

A : PBIDS

B : PBIT

C : XLSX

D : PBIX

Answer: A

Question 2

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?

A : PBIDS

B : PBIT

C : XLSX

D : PBIX

Answer: A

Question 3

You have a semantic model that uses a live connection to a semantic model in the Power BI service. You need to create a Power BI report named RPT1 that only uses the live connection. Which three components can you add to RPT1? Each correct answer presents a complete solution.

A : a report measure

B : a new column

C : a calculated table

D : a calculated column

E : a new table

Answer: A,C,D

Question 4

You have a Power Bi report for the procurement department. The report contains data from the following tables

There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals. What should you do?

A : Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month

B : Merge Suppliers and Uneltems.

C : Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).

D : Remove the Lineitems[Description] column.

Answer: D

Question 5

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do?

A : Add a Top N filter to the visual.

B : Configure the Sales Profit measure to use the RANKX function.

C : Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column

D : Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.

Answer: A