You have data in a Microsoft Excel worksheet as shown in the following table.You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:• If the discount column returns an error, a discount of 0.05 must be used.• All the rows of data must be maintained.• Administrative effort must be minimized.What should you do in Power Query Editor?
Answer(s): A
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.What should you do?
Answer(s): C
DRAG DROP (Drag and Drop is not supported)You have two Microsoft Excel workbooks in a Microsoft OneDrive folder.Each workbook contains a table named Sales. The tables have the same data structure in both workbooks.You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset.Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.You need to combine the tables into a single query that contains the unique columns of each table.What should you select in Power Query Editor?
You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network.You are notified that the Excel data source was moved to a new location.You need to update the PBIX file to use the new location.What are three ways to achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
Answer(s): B,D,E
Share your comments for Microsoft PL-300 exam with other users:
cannot evaluate yet
good so far
good questions with simple explanation
nice data dumps
great case study
help so much
very helpfull
some of the answers seem to be inaccurate. q10 for example shouldnt it be an m custom column?
its intresting, i would like to learn more abouth this