PL-200 practice questions 241–250

1. Question 241 · 289 in bank

   HOTSPOT - You plan to create a Power BI dataflow. The Power BI dataflow has the following requirements: • Be able to create a copy of the dataflow to separate Power BI workspaces. • Schedule the dataflow to update every day at 11:00 AM. You need to configure the dataflow. What should you do? 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

   Had the same question, when reading again, this is a Power BI dataflow, not a dataflow in PowerApps, then, yes refresh in Power BI Service

   Source: Adapted from community discussion — [Removed]

   

   Next question

2. Question 242 · 289 in bank

   HOTSPOT - A company plans to implement AI Builder to add intelligence to several business processes. Each business process uses different sources and produces different outputs. You need to determine which AI Builder model types to use. Which model types should you use? 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

   Reference: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-overview https://docs.microsoft.com/en-us/ai-builder/entity-extraction-overview

   Source: Adapted from community discussion — Edi41

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

3. Question 243 · 289 in bank

   HOTSPOT - You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query. The dataflow has the following requirements: • A table of aggregated data must be created in dataflow storage. • A unique identifier must be created for the table. You need to configure the dataflow. Which solutions should you use? 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

   in two minds about 'merge queries' and 'computed entities' merge query: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data computed entity: https://learn.microsoft.com/en-us/power-query/dataflows/computed-tables observe the part of the link: /power-bi/connect-data/ /power-query/dataflows/ merge is to bring columns into one table (example of ms retirement data that has the state name and another table associating state code to state name, finally have state code in the retirement table) and compute is to aggregate the numbers (have two table with service calls associated with accounts and list of accounts) first "in-storage computation" to aggregate the number of sevice calls per year per account and then merge this number to the account list. to finally see a list of accounts with (total) service calls per year. answers are correct.

   Source: Adapted from community discussion — MrEz

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

4. Question 244 · 289 in bank

   You plan to create a dataflow by using Power Query to transform the data. You observe that some cells display an error instead of the expected data. You need to obtain more details about the errors. What should you do?

   • AUse the App Checker.
   • BSelect the cell with the error.
   • CUse the Flow Checker.
   • DSelect the row that includes the cell with the error.
   • EUse the Advanced Editor.

   Show answer

   Answer: B

   References

   • Microsoft Learn

   Next question

5. Question 245 · 289 in bank

   A company creates a model-driven app. Users require access to a Power BI report that is embedded in the app. You need to configure the app. Where should you add the report?

   • AXML report
   • BDashboard
   • CBusiness rule
   • DPower Automate cloud flow

   Show answer

   Answer: B

   Explanation

   I think the given answer is correct. You can create a dashboard in the model-driven app and add the Power BI report as a component or tile within that dashboard.

   Source: Adapted from community discussion — Net_IT

   Next question

6. Question 246 · 289 in bank

   HOTSPOT - You use a dataflow to import data into Microsoft Dataverse. The data uses the following schema:

   

   The data must load in the least amount of time. You need to configure the incremental refresh settings for the dataflow. Which columns should you use? 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

   The answers are correct Filter column and the column for detect data change must be Date column In this case, it is reasonable to use 'createdon' to filter data and 'modifiedon' to detect data changes https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

   Source: Adapted from community discussion — JohnChung

   References

   • Microsoft Learn

   

   Next question

7. Question 247 · 289 in bank

   HOTSPOT - A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data. The company requires that the contacts be added to Dataverse automatically every day. You need to identify which tools are required to create and perform the import. What should you use? 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

   See this link. It says that you can get data from Excel files to Dataverse automatically on a schedule by using dataflow Power Query is used to perform the import https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

   Source: Adapted from community discussion — JohnChung

   References

   • Microsoft Learn

   

   Next question

8. Question 248 · 289 in bank

   You create and publish a Power BI report that contains an embedded canvas app. The report will be used by multiple people. The canvas app has an issue that must be corrected. You update the canvas app. You need to ensure that the updated canvas app is available in the published Power BI report. What should you do?

   • AManually refresh the data source on the published Power BI report
   • BPublish the canvas app
   • CPublish the Power BI report from Power BI Desktop and reshare to any users
   • DPublish the Power BI report from Power BI Desktop

   Show answer

   Answer: B

   Explanation

   It's B - Publish the App https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual "After you have completed building or making changes to your app, save and publish the app in Power Apps to see your app in the Power BI report."

   Source: Adapted from community discussion — platformsofpower

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

9. Question 249 · 289 in bank

   DRAG DROP - You create a report by using Power BI Desktop and publish the report to the Power BI service. You enable Power BI visualization embedding in a model-driven app. You need to configure the model-driven app to display a Power BI tile. 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

   Step 1: Create a personal dashboard in the model-driven app Add a Power BI dashboard to your model-driven app. Step 2: Add a Power BI tile to the dashboard and select the Power BI dashboard in the app. Add one Power BI tiles to your personal dashboard. Step 3: Share the dashboard with the appropriate user in the app Share the personal dashboard that contains Power BI visualizations: you must configure sharing in both Dataverse and Power BI, and the user or group must have the same credentials and appropriate level of access in both services. To share your personal dashboard in your app go to, Dashboards. In the list of dashboards, select the personal dashboard you want, and then select SHARE DASHBOARD. Reference: https://docs.microsoft.com/en-us/powerapps/user/add-powerbi-dashboards

   Source: Adapted from community discussion — DennisWypior

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 250 · 289 in bank

    Select 3

    You use Power BI Desktop to configure Power BI reports. You need to create a canvas app that displays user account information and include the app in a Power BI report. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    • AFrom the Power Apps Insert menu, add a Power BI tile
    • BFrom the Power BI Desktop menu, insert a Power Apps visual and include the required fields in the Power Apps data
    • CPublish the report to the Power BI service
    • DConnect to Common Data Service from Power BI Desktop

    Show answer

    Answer: BCD

    Explanation

    Step 1 (B): Here's how we embed PowerApps into a Power BI report: 1. Download and login to the Power BI desktop application 2. Click on (ג€¦) and select ג€Import from the marketplace.ג€ Step 2: Open Power BI desktop and use ג€Get dataג€ to connect with the Common Data Service data source. Step 3: Publish the report to Power BI service. Reference: https://purple.telstra.com/blog/powerbi-integration-with-powerapps

    References

    • Microsoft Learn

    Next question

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

PL-200 practice, question 241. 289 questions available.