A company uses two separate unlinked apps to manage sales leads; a Power Apps app and a third-party application.
The client has the following requirements:
✑ Manage all leads by using the Power Apps app.
✑ Create a lead in the Power Apps app when a user creates a lead in the third-party application.
✑ Update leads in the Power Apps app when a user updates a lead in the third-party application.
✑ Connect to the third-party application by using an API.
You need to recommend strategies to integrate the Power Apps app and the third-party application.
Which three options can you use to achieve the goal? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answer:
ADE
A: Customers should be able to adopt business applications from Microsoft and expect they speak the same language and seamlessly work together. Dual Write allows our customers to not think about these apps as different systems to write to independently; rather, the underlying infrastructure makes it seamless for these apps to write simultaneously.
D: Use Custom APIs to create your own APIs in Dataverse. With a Custom API you can consolidate a group of operations into an API that you and other developers can call in their code. The Dataverse connector enables calling Custom APIs actions in Power Automate.
E: Dataverse provides access to the environment database on the Microsoft Dataverse Service. It is available for Logic Apps, Power Automate, and Power Apps.
Reference:
https://docs.microsoft.com/en-us/business-applications-release-notes/april19/cdm-data-integration/dual-write-link-common-data-service-apps https://docs.microsoft.com/en-us/connectors/commondataservice/ https://docs.microsoft.com/en-us/powerapps/developer/data-platform/custom-api https://docs.microsoft.com/en-us/powerapps/developer/data-platform/custom-api
DRAG DROP -
You are designing a business continuity strategy for a client who has a Microsoft Power Platform solution.
The client works with critical data where any data loss creates a high risk.
You need to document the retry process for the stakeholders.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Answer:
A large company experiences high staff turnover rates. As a result, the company must add or remove multiple system user accounts daily.
You need to recommend a security concept which will facilitate complex security profiles to entities for large groups of users across the Power Apps and Dynamics
365 applications.
What should you recommend?
Answer:
D
User and team management is the area of Microsoft Dataverse where you can create and maintain user accounts and profiles.
A user is any person who works for a business unit who uses Dataverse. Each user has a user account.
A team is a group of users. Teams let users across an organization collaborate and share information.
Note: Why use Dataverse?
✑ Easy to secure ג€" Data is securely stored so that users can see it only if you grant them access. Role-based security allows you to control access to tables for different users within your organization.
✑ Data from your Dynamics 365 applications is also stored within Dataverse, allowing you to quickly build apps that use your Dynamics 365 data and extend your apps with Power Apps.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/user-team-entities https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-intro
HOTSPOT -
You are designing a Power Platform solution for a company that provides in-home appliance maintenance. When a customer schedules a service appointment, a dispatcher assigns one technician for a specific time and location.
The solution must capture information about the technician assigned to each appointment and the list of tools that the technician must bring to the appointment.
You need to recommend the data type for the captured information.
Which data type should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Choice -
Like Choices below, but can only select one of the option.
Incorrect Answers:
✑ Customer: A lookup column that you can use to specify a customer, which can be an account or contact.
✑ Lookup: Data in one table often relates to data in another table. For example, you might have a Teachers table and a Class table, and the Class table might have a lookup relation to the Teachers table to show which teacher teaches the class. You can use a lookup column to show data from the Teachers table.
This is commonly referred to as a lookup column.
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria. For both, the formula is evaluated for each record of the table
Box 2: Choices -
You can customize forms (main, quick create, and quick view) and email templates by adding multi-select columns that are called Choices. When you add a choices column, you can specify multiple values that will be available for users to select. When users fill out the form they can select one, multiple, or all the values displayed in a drop-down list.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/types-of-fields
HOTSPOT -
You are designing a Microsoft Power Platform solution for a company.
You have the following requirements:
✑ Users in the human resources department must be able to create tasks.
✑ Users in the human resources department must be able to assign cases to other users.
You create a table for cases and tasks. You need to recommend security settings to the company.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Assign only Create rights to activities
You 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-privileges https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds
A company has a list of contacts in a Microsoft Excel file. The company wants to load the contact information into a Microsoft Power Platform solution.
You need to recommend a data-loading solution.
What should you recommend?
Answer:
A
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 template
To 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 data -
Use 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
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.
Answer:
A
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
HOTSPOT -
A company plans to create a Power Apps portal to manage support cases for customers. The company has an account hierarchy for customers. The hierarchy supports accounts, cases, and contacts where both contacts and cases belong to their relevant account.
The company has the following requirements:
✑ Portal users must only see the notes for the cases that they manage.
✑ Portal users must only see cases that are submitted by their colleagues.
You need to design the security model for the portal.
Which entity permission scope should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Contact -
With 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: Account -
With 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
HOTSPOT -
A company offers continuing education courses for medical professionals. Each time a course is offered, the company tracks that the session has taken place in an Excel workbook.
The company maintains a list of required qualifications for an educator to teach a course. Educator qualifications range from languages spoken to advanced degrees.
The company needs the following custom table relationships defined:
✑ Associate educators with a list of their professional qualifications.
✑ Assign a primary educator to each course that is held.
✑ Collect information about every course that is held.
You need to determine the type of relationship that best fits the requirement.
Which type of table relationship should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Reference:
Box 1: One-to-many relationship -
Each educator can have 0, 1, or many qualifications
Box 2: One-to-many relationship -
Each 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
HOTSPOT -
You are designing the security model for a Power Platform solution.
The security model must meet the following requirements:
✑ Restrict sharing of data between Power Automate connectors.
✑ Ensure that environment administrators only see users who require access in the enabled user list.
You need to recommend security features for the solution.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Data loss prevention policy
Data loss prevention (DLP) policies enforce rules for which connectors can be used together by classifying connectors as either Business or Non-Business. If you put a connector in the Business group, it can only be used with other connectors from that group in any given app or flow. Sometimes you might want to block the usage of certain connectors altogether by classifying them as Blocked.
Box 2: Security group -
If your company has multiple Microsoft Dataverse environments, you can use security groups to control which licensed users can be a member of a particular environment.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/wp-data-loss-prevention https://docs.microsoft.com/en-us/power-platform/admin/control-user-access
