PRACTICE EXAMS:
  1. Home
  2. Microsoft Certification
  3. PL-300 Exam
  4. Microsoft.PL-300.v2026-08-10.q541 Dumps
Download Now

Question 301

You import two Microsoft Excel tables named Customer and Address into Power Query.
Customer contains the following columns:
* Customer ID
* Customer Name
* Phone
* Email Address
* Address ID
Address contains the following columns:
* Address ID
* Address Line 1
* Address Line 2
* City
* State/Region
* Country
* Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

Question 302

You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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.

Question 303

You have a Power B1 model that contains a table named Date. The table has the following columns.

Question 304

You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

Question 305

Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a measure to rank total sales by product. The results must appear as shown in the following table.

Which DAX formula should you use?