Free preview mode

Enjoy the free questions and consider upgrading to gain full access!

PL-300Free trialFree trial

By microsoft
Aug, 2025

Verified

25Q per page

Question 51

DRAG DROP -
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge 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.
Select and Place:

Image 1
—

Question 52

You are building a Power BI report that uses data from an Azure SQL database named erp1.
You import the following tables.

Image 1

You need to perform the following analyses:
✑ Orders sold over time that include a measure of the total order value
Orders by attributes of products sold

Image 2

The solution must minimize update times when interacting with visuals in the report.
What should you do first?

  • A: From Power Query, merge the Order Line Items query and the Products query.
  • B: Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.
  • C: Calculate the count of orders per product by using a DAX function.
  • D: From Power Query, merge the Orders query and the Order Line Items query.
—

Question 53

You have a Microsoft SharePoint Online site that contains several document libraries.
One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.
What should you do?

  • A: Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.
  • B: Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.
  • C: Get data from a SharePoint folder, enter the site URL, and then select Combine & Load.
  • D: Get data from a SharePoint list, enter the site URL, and then select Combine & Load.
—

Question 54

DRAG DROP -
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.
Sheet1 contains the following table named Table1.

Image 1

Sheet2 contains the following table named Table2.

Image 2

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

Image 3

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.
Select and Place:

Image 4
—

Question 55

You need to update the Power BI model to ensure that the analysts can quickly build drill-downs from business unit to product in a visual.
What should you create?

  • A: a group
  • B: a calculated table
  • C: a hierarchy
  • D: a calculated column
—

Question 56

HOTSPOT -
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Image 1
—

Question 57

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?

  • A: pie chart
  • B: scatterplot
  • C: bar chart
—

Question 58

HOTSPOT -
You need to create a KPI visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Image 1
—

Question 59

HOTSPOT -
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Image 1
—

Question 60

What should you create to meet the reporting requirements of the sales department?

  • A: a measure column that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
  • B: a calculated column that uses the following formula: ABS(Sales[sales_amount])
  • C: a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
  • D: a measure that uses the following formula: SUM(Sales[sales_amount])
—

Question 61

HOTSPOT -
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Image 1
—

Question 62

HOTSPOT -
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Image 1
—

Question 63

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.
What should you do?

  • A: From each report in powerbi.com, select Refresh visuals.
  • B: From Power BI Desktop, download the PBIX file and refresh the data.
  • C: Configure a scheduled refresh without using an on-premises data gateway.
  • D: Configure a scheduled refresh by using an on-premises data gateway.
—

Question 64

What is the minimum number of Power BI datasets needed to support the reports?

  • A: a single imported dataset
  • B: two imported datasets
  • C: two DirectQuery datasets
  • D: a single DirectQuery dataset
—

Question 65

You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

  • A: In the report, add a DAX calculated column that calculates the length of col1
  • B: In the report, add a DAX function that calculates the average length of col1
  • C: From Power Query Editor, add a column that calculates the length of col1
  • D: From Power Query Editor, change the distribution for the Column profile to group by length for col1
—

Question 66

HOTSPOT -
You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales.
You need to create a measure that calculates the total sales from the equivalent month of the previous year.
How should you complete the calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Image 1
—

Question 67

You have a Power BI semantic model that contains two queries.

You discover that a report based on the model has performance issues.

You plan to use Power Query to reduce the data loaded to the model.

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

NOTE: Each correct answer is worth one point.

  • A: Apply group by and summarize techniques.
  • B: Combine the queries by using Append.
  • C: Remove unnecessary columns and rows.
  • D: Combine the queries by using Merge.
  • E: Create a new query group.
—

Question 68

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You create aggregations to summarize results.

Does this meet the goal?

  • A: Yes
  • B: No
—

Question 69

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode.

Solution: You increase Automatic page refresh intervals.

Does this meet the goal?

  • A: Yes
  • B: No
—

Question 70

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode.

Solution: You configure incremental refresh.

Does this meet the goal?

  • A: Yes
  • B: No
—

Question 71

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You decrease the dashboard cache update frequency.

Does this meet the goal?

  • A: Yes
  • B: No
—

Question 72

HOTSPOT

You have a Power BI semantic model named Model1.

You need to create a measure that will display the sales result for all blue units. The solution must maintain the existing filter context.

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

NOTE: Each correct selection is worth one point.

Image 1
—

Question 73

You have a Power BI semantic model named Model1 that runs in Import storage mode.

You need to reduce the size of Model1. The solution must NOT increase report query response times.

What should you do?

  • A: Remove unnecessary columns.
  • B: Unpivot unnecessary columns.
  • C: Rename unnecessary columns.
  • D: Change Model1 to DirectQuery storage mode.
—

Question 74

You have a Power BI semantic model named Model1 that runs in Import storage mode.

You need to reduce the size of Model1.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

  • A: Summarize the detail data.
  • B: Upgrade to Power BI premium.
  • C: Implement row-level security (RLS).
  • D: Optimize the column data types.
  • E: Change the active relationships between tables to inactive relationships.
—

That’s the end of your free questions

You’ve reached the preview limit for PL-300

Consider upgrading to gain full access!

Page 3 of 15 • Questions 51-75 of 370
←
12345
→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!