Pass PL-600 Exam Guide

Box 1: Create a lookup to Dynamics 365 Field Service

Scenario: Machines are assigned serial numbers and placed in stock until they are shipped to customers.

Entity lookup: Allows technicians to choose a Dynamics 365 record. In the inspection designer interface, admins must select an entity and a field to display. For a chosen entity, the Name field and mandatory fields are the entity attributes that can be displayed in the lookup.

Box 2: Create a one-to-many relationship and set the behavior to Parental

Scenario: Inspection orders must:

• Allow entry of quality ratings of passed or failed for each quality metric identified for the machine being rated.
• Be automatically marked as failed if one inspection step rating is marked as failed.

Each inspection order can have one or many inspection steps, and each inspection step has a rating.

Note: Each pair of tables that are eligible to have a 1:N relationship can have multiple 1:N relationships between them. Yet usually only one of those relationships can be considered a parental table relationship.

Graphical user interface, text, application, chat or text message Description automatically generated

Box 1: Virtual Table

A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.

Scenario:

• First Up uses an on-premises system to manage current and historical patient data including medications and medical visits.
• The company plans to reference historical data in the existing system. The records held in these systems will not be migrated to the new solution except for medication information.
• The solution must provide a worker appointment booking system that can access worker historical job placement data.
• First Up staff members must be able to view and update worker records. They must be able to see current and historical job placement data on the same form in the new solution.

Box 2: Lookup (N:1)

Each worker can have many security clearances, so need a 1:N relationship.

Scenario: The solution must support tracking of security clearance information for a worker including the date, status, and certifying agency.

Scenario:

Audit teams must have the ability to view worker information on their mobile devices.

Audit teams must be able to record data during visits to locations where workers are placed.

When you create an app, or someone shares an app with you, you can run that app on the Power Apps mobile app or in a web browser.