PL-300 practice questions 121–130

1. Question 121 · 358 in bank

   Select 2

   You have a Power BI query named Sales that imports the columns shown in the following table.

   

   Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • ARemove the rows in which Sales[Status] has a value of Canceled.
   • BRemove Sales[Sales_Date].
   • CChange the data type of Sale[Delivery_Time] to Integer.
   • DSplit Sales[Sale_Date] into separate date and time columns.
   • ERemove Sales[Canceled Date].

   Show answer

   Answer: AE

   Explanation

   A, only records with state finished are used D, personally I would transform the column to a date format and not split it since only the date part is used Not E, All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value

   Source: Adapted from community discussion — bjornopjemic

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 122 · 358 in bank

   You have a Power BI report that contains a stacked bar chart. You need to add a new field to the legend. The field must combine information from separate columns. What should you create?

   • Aa calculated column
   • Ba dynamic format string
   • Ca measure
   • Da calculation group

   Show answer

   Answer: A

   Next question

3. Question 123 · 358 in bank

   You are building a data model for a Power BI report. You have data formatted as shown in the following table.

   

   You need to create a clustered bar chart as shown in the following exhibit.

   

   What should you do?

   • AFrom Power Query Editor, split the Machine-User column by using a delimiter.
   • BFrom Power Query Editor, create a column that contains the last three digits of the Machine-User column.
   • CIn a DAX function, create two calculated columns named Machine and User by using the SUBSTITUTE function.
   • DIn a DAX function, create two measures named Machine and User by using the SUBSTITUTE function.

   Show answer

   Answer: A

   Explanation

   The desired visual is provided. However, the dataset shown contains a column where machine and user data from the visual are combined into 1 column. Therefore, to solve this you need to use a delimiter. This will split one column into two, where you will use Machine column (BAC & ABC) as your Y-axis and User column (123 & 657) as your legend.

   Source: Adapted from community discussion — naomilena

   Next question

4. Question 124 · 358 in bank

   You have a Power BI dataset that contains a table named Goal. Goal contains the following columns.

   

   You need to use the Q&A feature to create a visual that answers the following question: "How many goals were scored last month?" Which type of visual will be generated by the Q&A feature?

   • Atable
   • Bsmart narrative
   • Ccard
   • Dgauge chart

   Show answer

   Answer: C

   Next question

5. Question 125 · 358 in bank

   DRAG DROP - You need create a date table in Power BI that must contain 10 full calendar years, including the current year. 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. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: YEAR - Get the current year. Box 2: TODAY - TODAY returns the current date. Box 3: CALENDAR - CALENDAR returns a table with a single column named ג€Dateג€ containing a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates. The following formula returns a table with dates between January 1st, 2005 and December 31st, 2015. CALENDAR ( DATE ( 2005, 1, 1 ), DATE ( 2015, 12, 31 ) Reference: https://dax.guide/calendar/

   Source: Adapted from community discussion — Igetmyrole

   

   Next question

6. Question 126 · 358 in bank

   You have a Power BI report. You plan to use the Analyze feature to explain unusual distributions in visuals. You need to identify insights in the data. What should you do?

   • ARight-click a data point on a visual, and then select Analyze.
   • BSelect the visual, and then select Get insights in the action bar.
   • CCreate a scatter chart, and then add a trend line to the chart.
   • DCreate a forecast by using the Analytics pane.

   Show answer

   Answer: A

   Next question

7. Question 127 · 358 in bank

   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 the date foreign keys. Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   Actually the DAX USERELATIONSHIP() function could offer a solution, but not how it is stated as an option: "You create measures that use the USERELATIONSHIP DAX function to filter sales on the ACTIVE relationship between the sales table and the date table." Because the report must be filtered on all 3 dates, the ACTIVE (1) AND INACTIVE (2) relationships should be used with function USERELATIONSHIP, not only the ACTIVE relationship.

   Source: Adapted from community discussion — Hoeishetmogelijk

   References

   • Microsoft Learn

   Next question

8. Question 128 · 358 in bank

   HOTSPOT - You have a Power BI report that contains a measure named Total Sales. You need to create a new measure that will return the sum of Total Sales for a year up to a selected date. 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. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: TOTALYTD - TOTALYTD evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters. Syntax: TOTALYTD ( <Expression>, <Dates> [, <Filter>] [, <YearEndDate>] Expression - The expression to be evaluated. Dates - The name of a column containing dates or a one column table containing dates. Example: TOTALYTD ( -- 2007-01-01 : 2007-05-12 [Sales Amount], 'Date'[Date] Box 2: 'Date'[Date] Reference: https://dax.guide/totalytd/

   Source: Adapted from community discussion — Igetmyrole

   

   Next question

9. Question 129 · 358 in bank

   You have a Power BI report named Report1. You add a bookmark to Report1 and use the default bookmark options. Which element is saved in the bookmark?

   • Adefault summarization
   • Bdata sources
   • CReport settings
   • Dfilters

   Show answer

   Answer: D

   Next question

10. Question 130 · 358 in bank

    DRAG DROP - You are modifying a Power BI model by using Power BI 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. Select and Place:

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer: See figure below

    Explanation

    Box 1: CALCULATE - CALCULATE evaluates an expression in a modified filter context. Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ג€¦]]]) The expression used as the first parameter is essentially the same as a measure. Filters can be: Boolean filter expressions - Table filter expressions - Filter modification functions - Table filter expression - A table expression filter applies a table object as a filter. It could be a reference to a model table, but more likely it's a function that returns a table object. You can use the FILTER function to apply complex filter conditions, including those that cannot be defined by a Boolean filter expression. Box 2: AND - Box 3: FILTER - FILTER returns a table that represents a subset of another table or expression. Syntax: FILTER(<table>,<filter>) Note: DISTINCT returns a one-column table that contains the distinct values from the specified column. In other words, duplicate values are removed and only unique values are returned. Reference: https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/filter-function-dax

    Source: Adapted from community discussion — SilviaS

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 121. 358 questions available.