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

You have a Power Bl semantic model that contains the data sources shown in the following table.

You need to configure the privacy levels of the data sources.

What should you configure (01 each data source? To answer, select (he appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

You use Power 81 Desktop to load data from a Microsoft SQL Server database.

While waiting for the data to load, you receive the following error.

You need to resolve the error.

What are two ways to achieve the goal? Each correct answer presents a complete solution

NOTE: Each correct selection is worth one point.

You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.

You are creating a Power Bl dashboard that will include two visuals from each report

You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.

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

NOTE: Each correct selection is worth one point.

You have a Rawer Bl report That imports a dace 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 three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

You plan to create a report that will display sales data from the last year for multiple regions

You need to restrict access to individual rows of the data on a per region-basis by using roles.

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.

You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.

DatelD is the date data type. You need to create an annual sales growth percentage measure.

Which DAX expression should you use?

You are creating a Power Bi model and report.

You have a single table in a data mode) named Product Product contains the following fields:

• ID

• Name

• Color

• Category

• Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets. Each value 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.

You receive annual sales data that must be included in Power Bl reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

You need to create a report that meets the following requirements:

• Visualizes the Sales value over a period of years and months

• Adds a slicer for the month

• Adds a slicer for the year

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?

ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.

What should you do?