PL-300 practice questions 191–200

1. Question 191 · 358 in bank

   HOTSPOT - You have a Power BI semantic model that contains a table named Item. The Item table contains a column named Quantity. You need to create a DAX query that meets the following requirements: • The rank of items must be calculated according to the values in Quantity. • Ranking must NOT be skipped if two or more items have the same value in Quantity. • If an item is unfiltered, the total of Quantity must display a blank value. How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   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

   HASONEVALUE ('Item'[Item]) check if 'item' is filtered to a single value. if not, it returns blank by default. Rank method : DENSE ensure that ranks are not skipped when there are ties.

   Source: Adapted from community discussion — [Removed]

   

   Next question

2. Question 192 · 358 in bank

   HOTSPOT - You use Power Query Editor to pull data from a Microsoft SharePoint Online list. You plan to use Advanced Editor to build a Power Query M formula language query. You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset. How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct answer is worth one point.

   

   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

   Its correct.please guys read the question it says the location column in your SharePoint Online list is a list so the answer is correct

   Source: Adapted from community discussion — 23042b9

   

   Next question

3. Question 193 · 358 in bank

   HOTSPOT - You have a Power BI semantic model that contains two tables as 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.

   

   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

   1. Single 2. Delete the many to one relationship, because the question asks what do you have to do first, if you set the relationship active as first step, you will receive an error message, because there would be 2 active relationship with the same 2 tables

   Source: Adapted from community discussion — b92fc92

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

4. Question 194 · 358 in bank

   Select 2

   You create a Power BI report named Summary1. You discover that Summary1 is slow. You run Performance analyzer to identify performance metrics for Summary1. Which two metrics display the execution duration in Performance analyzer? Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.

   • ATop Operations
   • BDAX query
   • CServer requests
   • DDependencies
   • EVisual display

   Show answer

   Answer: BE

   References

   • Microsoft Learn

   Next question

5. Question 195 · 358 in bank

   You have a Microsoft 365 subscription that contains the resources shown in the following table.

   

   You create a new dashboard that uses row-level security (RLS) filters. You define a new role named Consultants. To which resource can you assign the Consultants role?

   • AGroup2
   • BTeam1
   • CSales reports
   • DGroup1

   Show answer

   Answer: A

   Explanation

   A. Group 2. Per Microsoft Learn, here's why: "You can use the following groups to set up row-level security: Distribution Group Mail-enabled Group Microsoft Entra Security Group Note that Microsoft 365 groups aren't supported and can't be added to any roles." https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security Because of this, it should be Group 2.

   Source: Adapted from community discussion — 627628c

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

6. Question 196 · 358 in bank

   You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns: • Date • Product • SalesAmount You need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days. Which DAX expression should you use?

   • ACALCULATE(SUM(Sales[SalesAmount]), DATEADD(Date[Date], -30, DAY))
   • BCALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-30, Max('Date'[Date])))
   • CCALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Date[Date]))
   • DCALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)

   Show answer

   Answer: B

   Explanation

   DATESBETWEEN creates a continuous range of dates from the selected date back 30 days. So option B is more suitable for calculating a rolling 31-day total because it correctly defines the date range needed for the calculation.

   Source: Adapted from community discussion — MonikaStop

   Next question

7. Question 197 · 358 in bank

   You publish a semantic model to the Power BI service. The semantic model contains data from the following data sources: • Source1: A Microsoft Excel file stored in Microsoft OneDrive for Business • Source2: An Azure SQL database on a virtual network • Source3: A public website Which data sources require an on-premises data gateway?

   • ASource1 only
   • BSource2 only
   • CSource3 only
   • DSource1 and Source2 only
   • ESource2 and Source3 only
   • FSource1, Source2, and Source3

   Show answer

   Answer: B

   Explanation

   You need a gateway to connect to data sources that are located in a private network, such as an Azure Virtual Network (Azure VNet). A virtual network, or VNet, is a logically isolated segment of a network that insulates traffic from the public internet. A VNet provides enhanced network security. https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-data-gateways Excel file you can access via SharePoint connector and a public site is well... a public site...

   Source: Adapted from community discussion — VladStan

   References

   • Microsoft Learn

   Next question

8. Question 198 · 358 in bank

   HOTSPOT - You have a Power BI semantic model named ModelA that contains the following columns:

   

   All of the columns use the Text data type. Based on the model, you create a report named ReportA that contains the following columns: • OrderID • OrderDate • CustomerID • ShippingAddress ReportA is the only report connected to ModelA. You discover that ReportA has performance issues caused by the size of ModelA. What should you do to optimize and reduce the size of ModelA? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   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

   1) Changing data type from text to whole number. Explanation: Queries using numerical data types can execute faster than those using text data. 2) Delete the OrderTitle and OrderDescription columns. Explanation: Directly reduces the model size without affecting analysis.

   Source: Adapted from community discussion — FraGuara

   References

   • Microsoft Learn

   

   Next question

9. Question 199 · 358 in bank

   DRAG DROP - You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

   

   You plan to build a data model for a Power BI report. You need to prepare the data so that it is available to the model in the format shown in the following table.

   

   Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 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

   Step 1: Select the [Department] and [Stage] columns and unpivot the other columns. We unpivot the School1, School2, School3, and the School4 columns. You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. Example: When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns: * Values (in blue on the left) are unpivoted into a new column (in blue on the right). * Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column. Step 2: Rename the [Attribute] column as [School] and the [Value] column as [Score[, Step 3: Group by [Department] and [School] and.. Reference: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

   Source: Adapted from community discussion — Churato

   

   Next question

10. Question 200 · 358 in bank

    You have a report that includes a card visualization. You need to apply the following conditional formatting to the card while minimizing design effort: ✑ For values that are greater than or equal to 100, the font of the data label must be dark red. ✑ For values that are less than 100, the font of the data label must be dark gray. Which type of format should you use?

    • AColor scale
    • BRules
    • CField value

    Show answer

    Answer: B

    Explanation

    B is the answer. Rules allow you to define specific conditions and formatting based on those conditions, such as changing the font color to dark red for values greater than or equal to 100 and dark gray for values less than 100.

    Source: Adapted from community discussion — Igetmyrole

    Next question

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

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