DRAG DROP - A company is creating a new system based on Microsoft Dataverse. You need to select the features that meet the company's requirements. Which options should you use? To answer, drag the appropriate options to the correct requirements. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Box 1: one-to-many relationship - Only one (1:N) self-referential relationship per table can be set as hierarchical. In a self-referential relationship the primary table and the related table must be of the same type. Box 2: one-to-many relationship - 1:N (One-to-Many) - A table relationship where one table row for the Primary table can be associated to many other Related table rows because of a lookup column on the related table. Note: The N:1 (many-to-one) relationship type exists in the user interface because the designer shows you a view grouped by tables. 1:N relationships actually exist between tables and refer to each table as either a Primary/Current table or Related table. The related table, sometimes called the child table, has a lookup column that allows storing a reference to a row from the primary table, sometimes called the parent table. A N:1 relationship is just a 1:N relationship viewed from the related table. Box 3: many-to-many relationship 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/common-data-service/create-edit-entity-relationships https://docs.microsoft.com/en-us/power-apps/maker/data-platform/visualize-hierarchical-data
Source: Adapted from community discussion — Vivinator1
Case study - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Background - City Power & Light is an energy and utilities company that has offices in Europe. The company subsidizes home improvements for domestic customers, to improve energy efficiency and to meet environmental commitments. The company also distributes and generates electricity for domestic and commercial customers. The company has 2,000 employees in multiple offices and in work-from-home locations. City Power & Light uses a team of schedulers, assessors, field engineers, and customer support agents for home improvements in a program named Get Energy Fit. Current Environment - Get Energy Fit Program - City Power & Light uses the following to manage the Get Energy Fit program: • The company uses a Microsoft Excel spreadsheet named Planning Hub on Microsoft SharePoint Online to store information about customer appointments, customer details, and customer eligibility in the program. • The company records sensitive customer information that includes the document identification numbers and the customer's financial information. • The company uses an assessor to verify customer eligibility in the program and to perform a suitability assessment. The assessor completes the suitability assessment by using a paper and clipboard at the customer property and enters the data to the Planning Hub after the assessment is completed. The assessor also uploads photographs to an on-premises document library. The assessor completes the eligibility assessment by using an application written in React. • Schedulers use Microsoft Outlook to schedule engineers and assessors for home improvement appointments. About 200 appointments are scheduled daily. • Employees for the company submit funding claims on behalf of the customer by uploading evidence and compliance checks information to an application named the Claim Submission Portal. Technical Environment - • Schedulers use Windows 11 desktop and laptop computers with the latest version of Microsoft Edge. • Assessors use iOS and Android tablet devices. • The Claim Submission Portal uses REST-based APIs for all operations and a dedicated testing environment. Authentication to the API is provided by using the following example header key and value pair: o Authentication: 2C8D41431415E429C7FC7A74D8315 • The company uses Microsoft Azure for hosting multiple applications. Requirements - Overview - City Power & Light plans to implement Microsoft Power Platform to improve the customer experience and increase delivery for the Get Energy Fit program. Business Requirements - • Only team leaders and senior managers should have access to read personally identifiable information (PII). • All development changes must be tested in a separate environment. • The company requires out-of-the-box solutions, when possible. • Sensitive credentials, such as user passwords and API secrets, must be stored securely. • The Claim Submission Portal must allow citizen developers to create automated solutions. • Customer and appointment information must be accessible to all applications. Planning Hub Application - The company is planning to replace the Planning Hub spreadsheet with a new application. The new application has the following requirements: • The application must support a component design that provides rapid changes requested by the schedulers. • The data model for the application must capture the following information: o Information about customers such as name, address, and other PII. o The data and time for an assessor's or engineer's appointment. Schedulers must be able to view all appointments without filters. o Records the details of the home improvements installed for the customer. o Contains all the information and evidence for submission to the Claim Submission Portal. • After an assessor uploads the funding application and all evidence after a home improvement has been complete, the company requires that the status of the application is set to Submit and should run the following: o Retrieve the details about the customer and the improvement installed. o Send an approval to a senior manager to review and approve in Microsoft Teams. o Upload the information to the API endpoint. o If the upload fails to complete, it should retry after a delay of 30 seconds up to three times. If an error occurs after three times, the application should send an email notification to the application support team. o Must record the status on the funding application. Suitability Assessment Tool - The company plans to implement a new application named the Suitability Assessment Tool for the assessors. The new application has the following requirements: • Must integrate with Microsoft Power Platform. • Assessors must be able to complete the eligibility assessment by using the Suitability Assessment Tool. The assessors must be able to upload photographs to the on-premises file share. • Must be developed by using modular components that can be used by other applications. • Must be optimized for use on tablet devices. • All changes to the application must be completed in the Suitability Assessment Tool solution. Reporting - The company has the following requirements for a reporting solution: • The data source for the reporting solution must support incremental refreshes. • The solution must report accurate data if an error occurs. Issues - • A recent audit identified that all users can access the PII in the Planning Hub spreadsheet. • After a developer deploys a change to the production environment, a user reports information is loaded incorrectly to the test system when processing a funding application. • After deploying a change to the new eligibility assessment tool in the development environment, you observe that the changes do not appear in the development environment. • After removing a column from the Planning Hub application and deploying the changes to the production environment, you observe that the column is still present. • You deploy the customizations for the data model. Users report that the email address of the user who created the appointment is missing and that searches on the description information do not return any results. You need to resolve the funding application issue. Which component should you use?
Show answer
Answer: C
Question 73 · 388 in bank
HOTSPOT - A school district wants to standardize student information and student performance records. Students in the district are assigned to a specific school. Students are evaluated using class records. When students move between schools in the middle of a school year, the student's current class history must be available to the administrators at the new school. You need to configure Microsoft Dataverse tables to connect the class history records to their respective class records. How should you configure the table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Box 1: Team - 'the student's current class history must be available to the administrators at the new school.' Box 2: Many-to-one - Box 3: Parental - The N:1 (many-to-one) relationship type exists in the user interface because the designer shows you a view grouped by tables. 1:N relationships actually exist between tables and refer to each table as either a Primary/Current table or Related table. The related table, sometimes called the child table, has a lookup column that allows storing a reference to a row from the primary table, sometimes called the parent table. A N:1 relationship is just a 1:N relationship viewed from the related table. Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/user-team-entities https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships#types-of-table-relationships
Source: Adapted from community discussion — piboke
Question 74 · 388 in bank
HOTSPOT - You are developing an app for a sales team to record contact details in Microsoft Dataverse. The app must handle loss of network and save the data to Dataverse when reconnected. The main screen of the app has a form to collect contact data and a button. The OnSelect property for the button has the following expression:
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Box 1: Yes - LoadData and SaveData combine to form a simple mechanism to store small amounts of data on a local device. By using these functions, you can add simple offline capabilities to your app. References: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/offline-apps
DRAG DROP - You are creating a canvas app for a company. A security role has been created for sales representatives and a second security role has been created for sales managers. The canvas app has the following requirements: ✑ Sales managers must be able to view the records of the salespeople in their business unit. ✑ Sales managers must be the only people who can view sales probability data in opportunity records. ✑ Sales representatives and new hires assigned to the same territory share access to sales records. You need to assign permissions for the app. Which security options should you use? To answer, drag the appropriate security options to the correct scenarios. Each security option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Box 1: Role-based security - Dataverse uses role-based security to group together a collection of privileges. These security roles can be associated directly to users, or they can be associated with Dataverse teams and business units. Box 2: Field-level security - Sometimes record-level control of access is not adequate for some business scenarios. Dataverse has a field-level security feature to allow more granular control of security at the field level. Field-level security can be enabled on all custom fields and most system fields. Box 3: Record-level security - Reference: https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds
Source: Adapted from community discussion — FRONTIS01
HOTSPOT - You are synchronizing company data from a SQL Server-based .NET application into a Common Data Service (CDS) environment. The data is entered in both the SQL Server and CDS systems. You have a program that includes the following code:
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Box 1: No. An alternate key is needed, not a new field for the record identifier. Box 2: Yes - The specified key attributes are not a defined key for the account entity. Name: EntityKeyNotDefined - Message: The specified key attributes are not a defined key for the {0} entity Box 3: Yes - One way to create an entity is by using the UpsertRequest class. An upsert will create a new entity when there is no existing record that has the unique identifiers included in the entity passed with the request. Box 4: No - Reference: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/org-service/web-service-error-codes https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/org-service/entity-operations-update-delete#use-upsert
Source: Adapted from community discussion — saadnadir
Question 78 · 388 in bank
DRAG DROP - A company is creating a new system based on the Microsoft Dataverse. You need to select the Dataverse features that meet the company's requirements. Which features should you select? To answer, drag the appropriate features to the correct requirements. Each feature may be used once, more than once, or not at all. You may needs to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Box 1: Referential - Active/ Cascade Active one-to-many entity relationship: Perform the action on all active referencing entity records associated with the referenced entity record. Box 2: Cascade User Owner - Cascade User Owned: Perform the action on all referencing entity records owned by the same user as the referenced entity record. Box 3: Referential, Restrict Delete Restrict: Prevent the Referenced entity record from being deleted when referencing entities exist. Reference: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/configure-entity-relationship-cascading-behavior
Source: Adapted from community discussion — zukito3
DRAG DROP - A company implements Dynamics 365 Sales. Only sales managers must be able to perform the approval to move high value sales on in the opportunity qualification process. A new field must be created to capture the approval. You need to create and secure the new field. Which three 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:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Step 1: Enable field security in the Approval field. 1. Enable field security on one or more fields for a given entity. 2. Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams (step 2 and step 3 below). Step 2: Create a new field security profile. Create a new field security profile for the sales manager. Step 3: Set the field permissionsג€¦security profile Step 2 and step 3, example: Configure the security profiles. 1. Create the field security profile for sales managers. 2. Go to Settings > Security. 3. Click Field Security Profiles. 4. Click New, enter a name, such as Sales Manager access contact mobile phone, and click Save. 5. Click Users, click Add, select the users that you want to grant read access to the mobile phone number on the contact form, and then click Add. 6. Click Field Permissions, click mobilephone, click Edit, select Yes next to Allow Read, and then click OK. Reference: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/admin/field-level-security
Source: Adapted from community discussion — TheExamMaster2020
A company employs four Microsoft Power Platform developers. Each developer has an individual development environment. Each development environment is refreshed regularly from source control as a managed layer. The developers must implement their changes in isolation within these environments. Development work must be merged into a base solution within a shared sandbox environment. You need to ensure work carried out by each developer is deployed into the main solution in the sandbox environment. What should you do?
Show answer
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
