PL-600 Online Practice Questions and Answers

Correct Answer: A

Need to store the image in the table.

Scenario: The company uses photos of employees to generate employee badges. Photos are uploaded into Microsoft 365 user profiles.

Correct Answer: BC

B: Setting a column to Business Required means that the default behavior of a model-driven or canvas app will enforce this requirement in the app.

C: With alternate keys you can now define a column in a Dataverse table to correspond to a unique identifier (or unique combination of columns) used by the external data store. This alternate key can be used to uniquely identify a record in Dataverse in place of the primary key. You must be able to define which columns represent a unique identity for your records. Once you identify the columns that are unique to the table, you can declare them as alternate keys through the customization user interface (UI) or in the code.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-field-portal https://docs.microsoft.com/en-us/powerapps/developer/data-platform/define-alternate-keys-entity

Correct Answer: A

Restrict Delete: Prevent the Referenced table record from being deleted when referencing tables exist. Incorrect Answers:

D: Remove Link: Remove the value of the referencing column for all referencing table records associated with the referenced table record.

Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/configure-entity-relationship-cascading-behavior

Correct Answer: DF

Explanation:

D: All Microsoft Dataverse table rows have unique identifiers defined as GUIDs. These are the primary key for each table. When you need to integrate with an external data store, you might be able to add a column to the external database tables to contain a reference to the unique identifier in Dataverse. This allows you to have a local reference to link to the Dataverse row. However, sometimes you can't modify the external database. With alternate keys you can now define a column in a Dataverse table to correspond to a unique identifier (or unique combination of columns) used by the external data store.

F: You should be aware of the following constraints when creating alternate keys:

Valid columns in key table definitions

Only columns of the following types can be included in alternate key table definitions: Decimal Number Whole Number Single line of text Date Time *-> Lookup Option Set

Reference: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/define-alternate-keys-entity

Correct Answer: A

Explanation:

The on-premises data gateway acts as a bridge. It provides quick and secure data transfer between on-premises data, which is data that isn't in the cloud, and several Microsoft cloud services. These services include Power BI, Power Apps,

Power Automate, Azure Analysis Services, and Azure Logic Apps.

Power Automate is a service that you can use to automate repetitive tasks to bring efficiencies to any organizations. You can create cloud flows, desktop flows, or business process flows.

Reference:

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem

https://learn.microsoft.com/en-us/power-automate/flow-types

Correct Answer:

Reference: https://learn.microsoft.com/en-us/power-automate/task-mining-overview

Correct Answer:

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.

Reference:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-troubleshoot-sharing

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/use-powerapps-checker

Correct Answer:

Box 1: Power Automate flow

Scenario: Inspection orders must be automatically marked for re-inspection should a machine fail inspection. The new inspection order must be created by using the originating inspection order as a template.

Box 2: Business rule

By combining conditions and actions, you can do any of the following with business rules:

1.

Set column values

2.

Clear column values

3.

Set column requirement levels

4.

Show or hide columns

5.

Enable or disable columns

6.

Validate data and show error messages

7.

Create business recommendations based on business intelligence.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule