Microsoft Updated PL-600 Exam Questions and Answers by alastair

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.

Box 1: Assign: Cascade None

Scenario: Worker still records must be archived after ten years and are then removed from the main system.

Assign: The referenced table record owner is changed.

Cascade None: Do nothing.

Box 1: Add users to Microsoft 365.

Scenario: Users cannot view Power BI reports within the Power Platform apps.

Issue: The people you share with may see a locked tile in a dashboard, or a "Permission required" message when they try to view a report.

Solution: You need to grant them permission to the underlying dataset.

Go to the All or the Datasets + dataflows tab in your content list.

Select More options (...) next to a dataset, then select Manage permissions.

Select Add user.

Enter the full email addresses for individuals, distribution groups, or security groups.

Select Grant access.

Box 2: Configure an on-premises data gateway.

Scenario: The company plans to reference historical data in the [on-premises] existing system. The records held in these systems will not be migrated to the new solution except for medication information.

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.

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.