PL-300 Microsoft Power BI Data Analyst Question and Answers

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

You need to create a 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.

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

You have a Power B1 semantic model named Model 1 that runs in import storage node.

You need to reduce the size of Model.

Which two action should you perform? Each connect answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

You publish the semantic model 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.

You have a Power B1 dataset that contains quarterly sales performance data.

You need to enable managers to review the data in a format that meets the following requirements:

• Is optimized for printing.

• Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

What should you create?

You have the Power BI data model shown in the following exhibit.

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.

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You are building a Power Bl report that uses data from an Azure SQL database named erp1.

You Import the following tables.

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

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

You have an app workspace named Retail Analysis in the Power BI service.

You need manage the members that have access to the app workspace.

What should you do?

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?

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: You add a WHERE clause to the SQL statement.

Does this meet the goal?

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.

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

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

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.