Download Microsoft Power Platform Solution Architect.PL-600.VCEplus.2024-12-25.65q.vcex

With interactive dashboards, a chart uses the color assigned to the categories that make up the different values, even if the chart is configured to use random colors, when the chart is configured to be grouped by any of thefollowing column types:Choice Yes/No Status ReasonReference:https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/configure-interactive-experience-dashboards

Box 1: Microsoft Power Automate, Microsoft Dataverse connector, and Microsoft 365 Outlook connector Use Microsoft Dataverse as the data source.While Power Automate is a robust tool with ever-expanding capabilities, it also handles simple tasks with grace. A universal business need for many organizations is the ability to automate email notifications based on certain criteria: an opportunity is won, send an email to the sales manager; a case is closed, send an email to the customer; a work order is completed, send an email to the customer. Power Automate can easily accommodate this using the Microsoft 365 Outlook connector.Box 2: Microsoft Power Automate, Power Bi data alerts, and Microsoft 365 connectorData alerts in the Power BI service: Set alerts to notify you when data in your dashboards changes beyond limits you set.Box 3: Microsoft Power Automate, Power BI, Power Apps, and Microsoft Dataverse connectorReference:https://www.velosio.com/blog/2021/01/27/tracking-emails-the-right-way-with-power-automate/https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Box 1: Increase multithreading and/or batch size settingsBox 2: Ensure you are loading data in a specific order.Load the base tables in the hierarchies first.

Box 1: Use Virtual tablesA virtual entity is a custom entity in Dynamics 365 Customer Engagement (on-premises) that has fields containing data from an external data source. Virtual entities appear in your app to users as regular entity records, but contain data that is sourced from an external database, such as an Azure SQL Database. Records based on virtual entities are available in all clients including custom clients developed using the Dynamics 365 Customer Engagement Web Services.Box 2: Use Dynamics 365 Web API.Dynamics 365 Web Services API: Many times, straight database-to-database integrations aren't a possibility. In these cases, the development of a solution may depend on utilization of the Dynamics 365 Customer Engagement web services API (Application Programming Interface).Reference:https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-virtual-entities

Box 1: Define the data type and format for each columnIncrease the data type size of the column.Box 2: Define and implement duplicate detection rulesReference:https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean

To control data access, you must set up an organizational structure that both protects sensitive data and enables collaboration. You do this by setting up business units, security roles, and field security profiles.Reference:https://docs.microsoft.com/en-us/power-platform/admin/security-roles-privileges

Box 1: Assign only Create rights to activitiesYou require the same set of Dataverse privileges and access rights to work with custom activities as those required to work with custom entities.Task-based privileges, at the bottom of the form, give a user privileges to perform specific tasks, such as publish articles.Box 2: Assign User-level assign rights to human resources case table.Record-level privileges define which tasks a user with access to the record can do, such as Read, Create, Delete, Write, Assign, Share, Append, and Append To.For user and team owned records, the access level choices for most privileges are tiered Organization, Business Unit, Business Unit and Child Business Unit or only the user's own records. That means for read privilege on contact, I could set user owned, and the user would only see their own records.Incorrect Answers:For security purposes, records that are organization owned, the only access level choices is either the user can do the operation or can't.Reference:https://docs.microsoft.com/en-us/power-platform/admin/security-roles-privilegeshttps://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds

Box 1: ContactWith Contact scope, a signed-in user in the role for which the permission record is defined will have the rights granted by that permission only for records that are related to that user's contact record via a defined relationship.Box 2: AccountWith Account Scope, a signed-in user in the role for which the permission record is defined will have the rights granted by that permission only for records that are related to that user's parent account record via a defined relationship.This scope means that the entity list will only show the records of the selected entity that are associated to the user's parent account. For example, if an entity permission allows Read access to Lead entity with the Account scope, the user having this permission can view all the leads of only the parent account of the user.Incorrect Answers:Self Scope allows you to define the rights a user has to their own Contact (Identity) record. Users can use entity forms or web forms to make changes to their own Contact record linked with their profile.Parental scope: In this most complex case, permissions are granted for an entity that is a relationship away from an entity for which an Entity Permission record has already been defined. This permission is actually a child record of the parent entity permission.Reference:https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/assign-entity-permissions

Reference:Box 1: One-to-many relationshipEach educator can have 0, 1, or many qualificationsBox 2: One-to-many relationshipEach educator can be the primary educator for 0, 1 or many cources.Box 3: Many-to-many relationship that uses a custom table.Note: 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.Reference:https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships

Import data that's stored somewhere else into your model-drvien app using the import feature in Power Apps. Every table has required columns that must exist in your input file. It's recommended that you download an Excel template, add your data, and then import the file to your app. The template saves time and effort. Don't add or modify columns in the template to avoid issues during the import.Note:Step 1: Download an Excel templateTo avoid mapping issue, it's recommended that you use an Excel template that you can download from your app. Once the template is downloaded add your data and then import the file back to your app. Remember don't add or modify columns in the template to avoid issues during the import process.Step 2: Import your dataUse the template that you downloaded in the previous step (modified with your data) and import the file to your app.Reference: https://docs.microsoft.com/en-us/powerapps/user/import-data