Free PL-300 Exam braindumps download (PL-300 exam dumps Free)

QUESTION: 111

You use Power Query Editor to preview a query that contains sales order data in the following columns:
• Tax Amount
• Sales Order ID
• Freight Amount
• Subtotal Amount
• Total Item Quantity
The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount.
You need to query the data to identify the following metrics by month:
• The average item quantity per order
• The average freight amount per order
• The maximum item quantity per order
How should you modify the query?

In the Total Item Quantity column, replace the null values with 0.
In the Tax Amount column, remove rows that contain null values.
In the Freight Amount column, remove rows that contain null values.
In the Freight Amount column, replace the null values with 0.

Answer(s): D

Show Answer Next Question

QUESTION: 112

HOTSPOT (Drag and Drop is not supported)
You have the Power BI data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period.
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.

See Explanation section for answer.

Answer(s): A

Explanation:

Show Answer Next Question

QUESTION: 113

You have a Power BI model that contains a table named Employees. The table contains the following columns:
• Employee ID
• First Name
• Last Name
• Department
• Salary
Each employee is uniquely identified by using Employee ID.
You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.
Which DAX expression should you use?

DISTINCTCOUNT(‘Employees’[Salary])
CALCULATE(DISTINCTCOUNT(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)
CALCULATE(AVERAGE(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)
AVERAGE(‘Employees’[Salary])

Answer(s): C

Show Answer Next Question

QUESTION: 114

HOTSPOT (Drag and Drop is not supported)
You have the Power BI data model shown in the following exhibit.
The Sales table has the following columns.
The data model must support the following analysis:
• Total sales by product by month in which the order was placed
• Quantities sold by product by day on which the order was placed
• Number of sales transactions by quarter in which the order was placed
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Show Answer Next Question

QUESTION: 115

HOTSPOT (Drag and Drop is not supported)
You have Power BI report that contains the fields 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.