PL-300 – Microsoft Power BI Data Analyst

You are modifying a Power Bi model by using Power Bl Desktop.

You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.How should you complete the code? To answer, drag the appropriate values to the correct 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.NOTE: Each correct selection is worth one point.

You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.

You need to keep only the last modified row for each customer ID.

Which three 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 are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.