Microsoft PL-300 - Microsoft Power BI Data Analyst

Microsoft PL-300 Premium Access Download Demo

Page: 3 / 6
Total 464 questions

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?

bar chart

scatterplot

pie chart

Question # 22

You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

live connection

Dual

Import

DirectQuery

Question # 23

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.

Explanation:

Box 1: CALCULATE

CALCULATE evaluates an expression in a modified filter context.

Syntax: CALCULATE([, [, [, â€¦]]])

Expression - The expression to be evaluated.

filter1, filter2,â€¦ (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.

Box 2: FILTER

FILTER returns a table that represents a subset of another table or expression.

Syntax: FILTER(

Table- The table to be filtered. The table can also be an expression that results in a table.

Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France"

Box 3: Orders[ShippedDate]> Orders[RequiredDate]

Northwind Traders defines late orders as those shipped after the required shipping date.

[Reference:, https://docs.microsoft.com/en-us/dax/calculate-function-dax, , https://docs.microsoft.com/en-us/dax/filter-function-dax, , , ]

Question # 24

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?

Merge queries

Append queries

Combine files

Question # 25

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

Add the sales department as a member of the reports workspace

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

Distribute an app to the users in the Azure Active Directory group of the sales department.

Share each report to the Azure Active Directory group of the sales department.

Question # 26

You need to create a relationship in the data model for RLS.

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

NOTE: Each correct selection is worth one point.

Question # 27

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

What should you do?

Filter out discontinued products while importing the Products table.

Group the Categories table by the CategorylD column.

Change the OrderlD column in the Orders table to the Text data type.

Remove the QuantityPerUnit column from the Products table.

Question # 28

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 three dates at the same time.

Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.

Does this meet the goal?

Yes