HOTSPOT (Drag and Drop is not supported)You have the Azure SQL databases shown in the following table.You plan to build a single PBIX file to meet the following requirements:• Data must be consumed from the database that corresponds to each stage of the development lifecycle.• Power BI deployment pipelines must NOT be used.• The solution must minimize administrative effort.What should you do? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
Answer(s): A
You are creating a query to be used as a Country dimension in a star schema.A snapshot of the source data is shown in the following table.You need to create the dimension. The dimension must contain a list of unique countries.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): D,E
DRAG DROP (Drag and Drop is not supported)You use Power Query Editor to preview the data shown in the following exhibit.You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
HOTSPOT (Drag and Drop is not supported)You attempt to use Power Query Editor to create a custom column and receive the error message shown in the following exhibit.Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point.
From Power Query Editor, you attempt to execute a query and receive the following error message.Datasource.Error: Could not find file.What are two possible causes of the error? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
Answer(s): A,D
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