Pearson PL-300 New Attempt

You have a report in Power BI Desktop.

You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)

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.

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.

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 a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

Due Date

Order Date

Delivery Date

You need to support the analysis of sales over time based on all the date foreign keys.

Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and

Delivery Date.

Does this meet the goal?

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.

From Power Query Editor, you profile the data shown in the following exhibit.

The IoT GUID and IoT ID columns are unique to each row in query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You remove the loT GUID column and retain the loT ID column.

Does this meet the goal?