Microsoft Updated PL-300 Exam Questions and Answers by coco

In Power Query Editor, you have a query named Sales Data that contains the following columns.

You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the site of the semantic model.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE Each correct selection is worth one point.

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 Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.

You need to reduce the load times of the query without affecting the analysis.

Which two actions achieve this goal? Each correct answer presents a complete solution.

NOTL Each correct selection is worth one pant.

You have a Power Bl semantic model that contains a table named Opportunity.

The Opportunity table contains a column named Qualification

The Qualification column contains values between 0 and V

You need to build a new measure to score the opportunities on a scale of low, medium, and high.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.