PL-300 Exam Dumps - Microsoft Certified: Power BI Data Analyst Associate Questions and Answers

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?

You need to create the dataset. Which dataset mode should you use?

You have a Power Bl 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.

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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload

Does this meet the goal?

You have a dataset that contains revenue data from the past year.

You need to use anomaly detection in Power Bl to show anomalies in the dataset.

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

NOTE: Each correct selection is worth one point.

You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

From Power BI Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

You are preparing a financial report in Power BI.

You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:

Visualizations that include all measures in the data over time

Year-over-year calculations for all the measures

Which four 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.