PL-300 practice questions 321–330

1. Question 321 · 358 in bank

   DRAG DROP - You use Power Query Editor to load two queries named Query1 and Query2. Query1 results in the following error.

   

   Query2 results in the following error.

   

   Which type of error occurred for each query? To answer, drag the appropriate error types to the correct queries. Each error 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

   Explanation

   Query 2 --> Step-level Error: a step-level error prevents the query from loading and displays the error components in a yellow pane Query 2 --> Cell-level Error: a cell-level error won't prevent the query from loading but displays error values as Error in the cell.

   Source: Adapted from community discussion — jaume

   References

   • Microsoft Learn

   

   Next question

2. Question 322 · 358 in bank

   You publish a dataset to the Power BI service. The dataset contains a connection to an on-premises Microsoft SQL Server database. You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway. You confirm the following with the administrator of the gateway: • You have the appropriate permissions to use the gateway. • The data source was created on the gateway. • The gateway has a status of Running. What is the most likely reason the gateway is unavailable?

   • AThe type of data source is not supported by the on-premises data gateway.
   • BThe server name in the PBIX file does not match the data source name in the gateway.
   • CThe credentials for the data source are invalid.
   • DThe data source is configured to use single sign-on (SSO).

   Show answer

   Answer: B

   Explanation

   In Power BI, when you configure a data source to use an on-premises data gateway, the server name and other connection details in your PBIX file must match the data source configuration in the gateway. If there's a mismatch in the server name or other connection details, the scheduled refresh won't work, and you won't be able to select the appropriate gateway.

   Source: Adapted from community discussion — CyrilleC

   References

   • Microsoft Learn

   Next question

3. Question 323 · 358 in bank

   You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) tabular model located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the tabular model?

   • Aa scheduled refresh of the semantic model
   • Ban OData feed
   • Can On-premises data gateway
   • Da subscription

   Show answer

   Answer: C

   Next question

4. Question 324 · 358 in bank

   HOTSPOT - You have a semantic model that has the permissions 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

   Given answer is wrong....and there is a repeat of this question earlier with the right answer. The answers should be: Use Analyze in Excel with grant the Read permission for

   Source: Adapted from community discussion — 539d541

   References

   • Microsoft Learn

   

   Next question

5. Question 325 · 358 in bank

   You have a Power BI semantic model named Model1 that contains sales data. You need to ensure that Model1 is refreshed on the first day of each month to include last month’s sales data. What should you configure?

   • Aa scheduled refresh
   • Ban incremental refresh
   • Ca Microsoft Power Automate flow
   • Dan on-premises data gateway

   Show answer

   Answer: A

   Explanation

   - a scheduled refresh While incremental refresh can help optimize the refresh process by refreshing only the data that has changed, it does not set the schedule for when the refresh happens. It helps with large datasets by minimizing data reloads, but it doesn’t solve the requirement of scheduling the refresh for the first day of each month.

   Source: Adapted from community discussion — Bildey

   Next question

6. Question 326 · 358 in bank

   Select 2

   You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity. Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AEnable query caching for the dataset.
   • BImport the dataset to Microsoft Excel.
   • CFrom the Power BI service, open a dashboard that uses the dataset.
   • DFrom the Power BI service, open a report that uses the dataset.
   • EFrom PowerShell, run the get-powerbireport cmdlet.

   Show answer

   Answer: CD

   Explanation

   The answer is correct! Note After two months of inactivity, scheduled refresh on your dataset is paused. A dataset is considered inactive when no user has visited any dashboard or report built on the dataset. At that time, the dataset owner is sent an email indicating the scheduled refresh is paused. The refresh schedule for the dataset is then displayed as disabled. To resume scheduled refresh, simply revisit any dashboard or report built on the dataset. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh#scheduled-refresh

   Source: Adapted from community discussion — iccent2

   References

   • Microsoft Learn

   Next question

7. Question 327 · 358 in bank

   You have a Power BI workspace that contains a dataset, a report, and a dashboard. The following groups have access: ✑ External users can access the dashboard. ✑ Managers can access the dashboard and a manager-specific report. ✑ Employees can access the dashboard and a row-level security (RLS) constrained report. You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you use?

   • Acomments
   • Bchat in Microsoft Teams
   • Calerts
   • Dsubscriptions

   Show answer

   Answer: A

   Explanation

   B. Chat in Microsoft Teams: the chat is not directly tied to the Power BI service. External users may not have access to the chat. Incorrect. C. Alerts: not for communication purposes and do not allow for tagging. Incorrect. D. Subscriptions: used to send snapshots of your dashboards or reports at a scheduled time, not interactive and would not be suitable for tagging administrators.Incorrect. => A is correct.

   Source: Adapted from community discussion — Dsbuff

   References

   • Microsoft Learn

   Next question

8. Question 328 · 358 in bank

   You have a PBIX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?

   • AFrom Power Query Editor, create new queries.
   • BFrom Power Query Editor, modify the source of each query.
   • CCreate a PBIT file, open the file, and change the data sources when prompted.
   • DModify the Data source settings.

   Show answer

   Answer: D

   Explanation

   B could work, but D takes the least effort. So the answer is D. (Assuming that the table names and definitions remain the same)

   Source: Adapted from community discussion — Hoeishetmogelijk

   Next question

9. Question 329 · 358 in bank

   You have a Power BI workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

   • ACreate a row-level security (RLS) role and add the user to the role.
   • BShare the reports with the user.
   • CGrant the Read permission for the datasets to the user.
   • DAdd the user as a member of the workspace.
   • EAdd the user as a Viewer of the workspace.

   Show answer

   Answer: D

   Explanation

   Contributor is the lowest possible role to create dashboards, but the answers only provide Member as a role, so this is it.

   Source: Adapted from community discussion — fred92

   Next question

10. Question 330 · 358 in bank

    DRAG DROP - You have a Power BI workspace that contains a single-page report named Sales. You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. 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. 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

    An entire report page can be pinned to a dashboard, which is called pinning a live tile. It's called a live tile because you can interact with the tile on the dashboard. Unlike with individual visualization tiles, changes made in the report are automatically synced with the dashboard. Step 2: Open the Sales report - Step 3: Pin the page. 1. Open a report in Editing view. 2. With no visualizations selected, from the menu bar, select Pin to a dashboard. 3. Pin the tile to an existing dashboard or to a new dashboard. Notice the highlighted text: Pin live page enables changes to reports to appear in the dashboard tile when the page is refreshed. 4. Select Pin live. A Success message (near the top right corner) lets you know the page was added, as a tile, to your dashboard. Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

    Source: Adapted from community discussion — Mizaan

    

    Next question

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

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