PL-600 practice questions 131–140

1. Question 131 · 246 in bank

   HOTSPOT - You are designing a solution to continually import data from several data sources into Microsoft Dataverse. The solution must meet the following requirements: • Include integrated error handling for records that fail to import successfully into Dataverse. • Augment data with Al and machine learning models. You need to select a component for each requirement. Which components 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

   Requirement 1: Augment data with AI and machine learning models. Component: Analytical dataflow Analytical dataflow allows for data enrichment using AI and machine learning models. It includes built-in connectors to several data sources and allows for the creation of custom data enrichments using Power Query transformations. Requirement 2: Include integrated error handling in place for records that fail to import Component: Logic Apps Logic Apps provides robust error handling capabilities, including the ability to configure retries, notifications, and custom workflows for handling failed records. It also includes connectors to several data sources, making it easy to integrate with other components of the solution.

   Source: Adapted from community discussion — Parth91

   

   Next question

2. Question 132 · 246 in bank

   You are designing the data model for a school. The school wants to track students' enrollments in courses. The system must meet the following requirements: ✑ Track the courses in which each student is enrolled. ✑ Track the students that are enrolled in each course. Track dates when each student enrolled in each course and the person who approved the enrollment.

   

   ✑ Allow users to create a report that details which students are enrolled in which courses. You need to recommend a data model that will fit the school's requirements. Which logical model should you recommend? A.

   

   B.

   

   C.

   

   D.

   

   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:

   Explanation

   Need a relationship table. N:N (Many-to-Many): A table relationship that depends on a special Relationship table, sometimes called an Intersect table, so that many rows of one table can be related to many rows of another table. When viewing rows of either table in a N:N relationship you can see a list of any rows of the other table that are related to it. Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships

   Source: Adapted from community discussion — N8n0z

   Next question

3. Question 133 · 246 in bank

   Select 2

   You design integration with an external data source that uses sequential integer values as primary keys for the records contained in it. Data synchronization will occur in Microsoft Dataverse so users can access data. Data within Microsoft Dataverse must be accurate against the data in the external data source. You need to ensure that the data from the external data source does not create duplicated rows in Microsoft Dataverse. Which two features should you use? Each correct answer presents part of the solution.

   • AWebhook
   • BChange tracking
   • CDuplicate detection rules
   • DUpsert method
   • EAlternate key

   Show answer

   Answer: DE

   Explanation

   Use the Upsert method - The Upsert method can be used to insert new records or update existing records based on the primary key of the record. This ensures that records are not duplicated in Dataverse. Use Alternate key - An alternate key is a unique identifier for a record that is defined by the user and can be used instead of the primary key to avoid duplicates. By defining an alternate key on the entity in Dataverse that will be used to store the data from the external data source, the integration can use the alternate key to check for existing records and avoid creating duplicates.

   Source: Adapted from community discussion — CESBCN

   References

   • Microsoft Learn

   Next question

4. Question 134 · 246 in bank

   Select 2

   You are designing a new Microsoft Power Platform solution for a wedding organizer company. The company uses a third-party application and plans to migrate the data into Microsoft Dataverse for the new solution. The third-party application has an API that can be connected to programmatically for data migration purposes. You need to migrate the unique IDs belonging to the records from the third-party application. Which two Microsoft Dataverse column types should you use to store this information? Each correct answer presents a complete solution.

   • APlain Text
   • BText Area
   • CFloat
   • DUnique Identifier
   • ERich Text
   • FLookup

   Show answer

   Answer: AD

   Explanation

   To store unique IDs belonging to records from the third-party application in Microsoft Dataverse, you can use two column types: Single Line of Text: You can use this column to store alphanumeric IDs, such as order numbers or customer IDs, from the third-party application. GUID: You can use this column to store unique identifiers generated by the third-party application, such as unique IDs for customers, orders, or invoices. By using these two column types, you can ensure that the unique IDs belonging to records from the third-party application are accurately and reliably stored in Microsoft Dataverse.

   Source: Adapted from community discussion — Skada

   References

   • Microsoft Learn

   Next question

5. Question 135 · 246 in bank

   DRAG DROP - You are designing a Microsoft Power Platform solution for a financial services company. Data from existing financial systems will be imported into Microsoft Dataverse and displayed to users as part of the app deployment. The company has the following issues with data: • Phone numbers in records can contain letters in the record. • Security has not been applied to financial total values held in each record. • Users and managers can see all records. You need to apply data quality standards to the solution. What should you recommend? To answer, drag the appropriate solutions to the correct data quality items. Each solution 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

   Masking rules replaces characters in a text with masked character. how would this stop users from users adding letters to the phone number?

   Source: Adapted from community discussion — Ysondh

   

   Next question

6. Question 136 · 246 in bank

   Select 3

   You are implementing a model-driven app for a national chain of retail stores. You have the following requirements: • Store employees must be able to view data for their store only. • Regional managers must be able to view data for all stores in a region. • The reporting team must be able to view all data across all stores. You need to configure system security. Which three security methods should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AAccount hierarchy
   • BAzure AD security group
   • CManager hierarchy
   • DSecurity roles
   • EOwner teams

   Show answer

   Answer: CDE

   Explanation

   Why tho? I just use process of elimination... Account and Manager Hierarchy have nothing to do with the requirements there for its the other 3. Think about the solution and what you would do... its PL-600 not 200. Just my thoughts... maybe im wrong... or maybe im not.... what if I am? .... hmmm .... prob not tho.... maybe

   Source: Adapted from community discussion — Newb007

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

7. Question 137 · 246 in bank

   DRAG DROP - A company is designing a data migration strategy with data from multiple sources. The company performs a test migration and discovers issues with some of the data. You need to identify the solution to each issue. Which components should you use to solve each issue? To answer, drag the appropriate solutions to the correct issues. Each solution 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

8. Question 138 · 246 in bank

   Select 2

   You are designing an integration between an Azure SQL database and a model-driven app. You have the following requirements: • Audit updates to the data. • Assign security role access to tables at the user level. • Assign security role access to tables at the organization level. • Enable change tracking. • Add and update data. You need to implement virtual tables. Which two requirements can you meet by using virtual tables? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AEnable change tracking.
   • BAssign security role access to tables at the user level.
   • CAdd and update data.
   • DAssign security role access to tables at the organization level.
   • EAudit updates to the data.

   Show answer

   Answer: CD

   Explanation

   I would choose C+D. It seems that B and E are excluded according to https://learn.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/get-started-ve#limitations-of-virtual-tables And A according to https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-virtual-entities

   Source: Adapted from community discussion — camptest

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

9. Question 139 · 246 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. A company plans to automate the expense approval process. Users currently enter data into an on-premises SQL Server database. You need to allow users to submit expenses from mobile devices. Solution: Create a canvas app for expense data entry. Install an on-premises gateway. Create a cloud flow for approval and to add data to the SQL Server database. Does the solution meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Next question

10. Question 140 · 246 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. A company plans to automate the expense approval process. Users currently enter data into an on-premises SQL Server database. You need to allow users to submit expenses from mobile devices. Solution: Create a canvas app for expense data entry. Install the Power Automate app in Microsoft Teams. Create a cloud flow for approval to add data to the SQL Server database. Does the solution meet the goal?

    • AYes
    • BNo

    Show answer

    Answer: B

    Next question

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

PL-600 practice, question 131. 246 questions available.