Pass the Microsoft Certified: Power BI Data Analyst Associate PL-300 Questions and answers with ExamsMirror

You create a Power Bl report1 named Summary1 You discover that Summary1 is slow.

You run Performance analyzer to identify performance metrics for Summary1

Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.

You use Power Query Editor to preview the data shown in the following exhibit.

You confirm that the data will always start on tow 3, and row 3 will always contain the column names.

How should you shape the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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?

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the query.

Does this meet the goal?

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:

• Customer ID

• CustomerName

• Address

• City

• ProvState

• Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

You have a Power Bi data model that imports data from a Microsoft Excel spreadsheet. You use Power Query to load a query that contains both renamed and custom columns. Later you attempt to reload the query and receive the following error message

Expression.Error; The column 'Category’ of the table wasn’t found.

What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Your company has affiliates who help the company acquire customers.

You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.

The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.

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.

You need to create a measure that will return the percentage of late orders.

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.

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

You need to create a relationship in the dataset for RLS.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.