100% Free Microsoft PL-300 Practice Test Questions

Question 1

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting

requirements of the regional managers. What should you do?

A : In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmddand use the calculated column to create a relationship to the Date table.

B : Add the Weekly_Returns data to the Sales table by using related DAX functions

C : Create a new table based on the Date table where date-id is unique, and then create a many-to-manyrelationship to Weekly_Return.

Answer: B

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

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 4

You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column. You need to create a report that will contain the visual shown in the following exhibit.The solution must NOT require additional DAX measures. Which type of visual should you use?

A : ribbon chart

B : line chart

C : 100% stacked area chart

D : area chart

Answer: D

Question 5

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 a historic employee counts and predicts

trends during the next six months.

Which type of visualization should you use?

A : scatter chart

B : ribbon chart

C : line chart

D : key influences

Answer: C

100% Free PL-300 Practice Exam Questions and Answers