PL-300 practice questions 291–300

1. Question 291 · 358 in bank

   You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns: • WebsiteName • URL You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements: • Display the website name. • Enable users to navigate to the website's URL by selecting the website name. What should you use?

   • Adata categories
   • BConditional Formatting
   • Cinline hierarchy labels
   • DURL icons

   Show answer

   Answer: B

   Explanation

   Exactly You have two columns "Name" and "URL" You create a table visual with only Name then you do the conditionnal formatting Name > Conditionnal formatting > web URL > based on the column URL

   Source: Adapted from community discussion — ferben

   Next question

2. Question 292 · 358 in bank

   HOTSPOT - You use Power Query Editor to review a query that contains a column named Country. You need to view the following information in the Data preview view for the Country column: • The percentage of values that contain errors. • The count of empty values. What should you enable? 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

   Both Answers are Column Quality Column Quality: The Column quality feature in Power Query provides a visual summary of the column data, including: The percentage of valid values. The percentage of error values. The percentage of empty (null) values. This is exactly what you need to see both the percentage of errors and the count of empty values. Column Profile: The Column profile provides a statistical overview of the data, such as distinct values, unique values, and value distribution. While useful, it does not specifically display the percentage of errors or count of empty values. Column Distribution: The Column distribution feature shows the frequency distribution of values in the column as a bar chart. It is not used for viewing errors or empty values.

   Source: Adapted from community discussion — f133b89

   

   Next question

3. Question 293 · 358 in bank

   You have a Power BI semantic model named Model1 that contains two fields named Sales and Quarter. Model1 contains a DAX measure that sums the Sales column. You need to create a report that will contain the visual shown in the following exhibit.

   

   The solution must NOT require additional DAX measures. Which type of visual should you use?

   • Aribbon chart
   • Bline chart
   • C100% stacked area chart
   • Darea chart

   Show answer

   Answer: C

   Next question

4. Question 294 · 358 in bank

   DRAG DROP - You have a Power BI semantic model that contains a table. You need to create a Power BI report page that contains two visuals that meet the following requirements: • Visual 1: Displays the distribution of hierarchical data • Visual 2: Search and then filter by values Which type should you choose for each visual? To answer, drag the appropriate visual types to the correct visuals. Each visual type 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.

   

   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

   

   Next question

5. Question 295 · 358 in bank

   HOTSPOT - You use Power Query Editor to review the query shown in the following exhibit.

   

   Each Region value appears only on the row where it first occurred. Each subsequent occurrence of the Region value is blank. You need to ensure that every row contains the correct non-blank value. The solution must minimize development effort. Which column should you select, and which action should you perform on the column? 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

   Region/Fill down The Fill Down action in Power Query propagates the last non-blank value downward into subsequent blank cells within the same column. This ensures that all blank rows in the “Region” column are filled with the correct value from the previous row where the region was specified.

   Source: Adapted from community discussion — b2775a4

   

   Next question

6. Question 296 · 358 in bank

   You have a Power BI report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader. What should you configure on the bar chart?

   • Aconditional formatting
   • Balt text
   • Cthe tab order
   • Dthe layer order

   Show answer

   Answer: B

   Explanation

   "Alt text" refers to a textual description added to an image that explains its content for users with visual impairments who rely on screen readers, while "tab order" defines the sequence in which interactive elements on a webpage are navigated using the keyboard's tab key, ensuring a logical flow for users to access information.

   Source: Adapted from community discussion — SylUK

   Next question

7. Question 297 · 358 in bank

   HOTSPOT - You have a Power BI tenant that hosts the datasets shown in the following table.

   

   You have the following requirements: The export of reports that contain Personally Identifiable Information (PII) must be prevented. Data used for financial decisions must be reviewed and approved before use. For each of the following statements, select Yes if the statement is true. Otherwise, select No. 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

   Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-security-sensitivity-label-overview

   Source: Adapted from community discussion — temor

   

   Next question

8. Question 298 · 358 in bank

   In Power BI Desktop, you are creating visualizations in a report based on an imported dataset. You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data. What should you do?

   • AFrom the Power BI service, configure the dataset permissions.
   • BFrom Power BI Desktop, configure the Data Load settings for the current file.
   • CFrom Power BI Desktop, modify the data source permissions.
   • DFrom Power BI Desktop, configure the Report settings for the current file.

   Show answer

   Answer: D

   Explanation

   in Power BI Desktop -> File -> Options and Settings -> Options Current File -> Report Settings -> Export Data -> Allow end users to export data with current layout and summarized data from the Power BI service or Power BI Report Server.

   Source: Adapted from community discussion — Orkhannnn

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

9. Question 299 · 358 in bank

   You have a Power BI report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets, or dashboards. What should you do?

   • AGrant the Read and Build permissions for the Power BI datasets to the Azure network security team.
   • BConfigure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
   • CInstruct the Azure network security team to create security groups. Configure RLS to use the groups.
   • DAdd the Azure network security team as members of the RLS role.

   Show answer

   Answer: C

   Explanation

   It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.

   Source: Adapted from community discussion — fred92

   Next question

10. Question 300 · 358 in bank

    You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant mail-enabled security group to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region. You need to ensure that the sales manager can see the correct sales data. What should you do?

    • AChange the Microsoft Power BI license type of the sales manager.
    • BFrom Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.
    • CManage the permissions of the underlying dataset.
    • DRequest that the sales manager be added to the correct Azure Active Directory group.

    Show answer

    Answer: D

    Explanation

    Because in the question they mentioned "You assign the relevant mail-enabled security group to each role." it means they already have Azure security groups. and RLS are assigned to these groups. So we just need to assign the user to the correct group.

    Source: Adapted from community discussion — Shalaleh

    Next question

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

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