Free Microsoft PL-300 Exam Dumps Questions & Answers

You have a semantic model named Model1.
You have a Power BI report named RPT1 that is connected to Model1. RPT1 contains a table visual named Table1 that shows the results of multiple measures.
You discover that the DAX query for Table1 runs slowly.
You need to identify which measure is slowing query performance.
What should you use?

• A.  Performance analyzer
• B.  Power Query Editor
• C.  Model view
• D.  DAX query view

You have two CSV files named Products and Categories.
The Products file contains the following columns:
ProductID
ProductName
SupplierID
CategoryID
The Categories file contains the following columns:
CategoryID
CategoryName
CategoryDescription
From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:
ProductID
ProductName
SupplierID
CategoryID
CategoryName
CategoryDescription
How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

You have a query named All Sales that imports sales data into a Power BI model.
You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:
* Use All Sales as the source for three other queries named Sales Fact Product Dimension, and Customer Dimension.
* Minimize maintenance effort.
What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

You have a Fabric tenant that hosts the semantic models shown in the following table.

You have the following requirements:
The export of reports that contain Personally Identifiable Information (PII) must be prevented.
Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

You have a Power B1 semantic model that contains a table
You need to create a Power B1 report page that contains two visuals that meet the following requirements:
* Visual 1: Display* the distribution of hierarchical data
* Visual 2: Search arid then filler by values
Which type should you choose for each visual? To answer, drag the appropriate visual types to the correct visuals. Each visual type 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.

Correct Answer: