Free Microsoft PL-300 Exam Questions

You have the CSV file shown in the following table. You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: • The first column must contain the month. • The second column must contain the year. • The third column must contain the order amount for the month and year. Which transformation should you use first? 

You attempt to connect Power BI 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 type of connector should you choose? 

You attempt to connect Power BI 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 type of connector should you choose? 

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 build a Power Bi report that displays loT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the temperature rises above four degrees Celsius. What should you do?