Free Microsoft PL-300 Exam Questions

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset You need to ensure that the dataset can be refreshed in powefbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

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?

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.

From Power Query Editor, you profile the data shown in the following exhibit.

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. The solution must improve dataset

performance.

Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and

then delete the IoT GUID and IoT ID columns.

Does this meet the goal?

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?   

You attempt to connect Purer 81 Desktop to a Cassandra database. From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database. Which of connector should you choose?