A company plans to deploy multiple Microsoft Dataverse environments. You are supporting the go-live process. The company reports the following access issues: * Users can access account records but cannot read a column m the table. * A licensed user receives an insufficient permission error when opening leads. * A licensed user does not appear in the list of users available for security assignment. You need to resolve the issues. What should you do? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
A company has a Power Platform environment that connects to a third-party marketing application. The company reports that the data in the Power Platform lead table does not match data from the marketing application. Issues include: The owner data in the lead table and the third-party application do not match. The Topic column has more information than the related record from the marketing application. There are differences in how telephone numbers are formatted. You need to determine which processes are causing the issues. Which three processes may be causing the differences observed? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Correct Answer: A,B,C
A: With advanced data preparation available in Power Apps, you can create a collection of data called a dataflow, which you can then use to connect with business data from various sources, clean the data, transform it, and then load it to Microsoft Dataverse or your organization's Azure Data Lake Gen2 storage account. B: By combining conditions and actions, you can do any of the following with business rules: Set column values Clear column values Set column requirement levels Show or hide columns Enable or disable columns Validate data and show error messages Create business recommendations based on business intelligence. C: Duplicate detection works by comparing generated match codes of existing records with each new record being created. These match codes are created as each new record is created. Therefore, there is potential for one or more duplicate records to be created if they are processed at the exact same moment. In addition to detecting duplicates as they are created, you should schedule duplicate detection jobs to check for other potential duplicate records. Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows https://docs.microsoft.com/en-us/powerapps/developer/data-platform/duplicaterule-entities
Question 58
You need to recommend technology for accessing historical job placement data. What should you recommend?
Correct Answer: B
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. Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-virtual-entities Topic 3, Fabrikam, inc. Overview 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 Fabrikam, Inc. manufactures industrial metal cutting machines. The company installs and services the machines for customers. Fabrikam has manufacturing plants in Canada, France, and Chin a. The company also has regional service organizations that are responsible for installation and maintenance of the machines. Current environment Overview Operations for the company are managed very informally. Only a small number of long-term employees are aware of all manufacturing processes. The company has been experiencing quality issues associated with its manufacturing operations and installations. The company wants to implement a way to capture quality inspection results for each machine produced. Current inspection checklists are stored in the Files section of a Teams channel for inspectors. Inspectors commonly print the incorrect inspection checklist. The company has specific inspection stations for certain inspection steps. Each station has the gauges and equipment required for related inspection steps. There is often a backlog at specific inspection stations. This results in delays in shipping machines to customers. Accounting system The current system does not handle shop floor or manufacturing planning functionality. Machines are assigned serial numbers and placed in stock until they are shipped to customers. Employee information is maintained only within the accounting system. Access to the information is strictly controlled due to privacy regulations and company policies. Other systems The company has an enterprise Microsoft 365 subscription. The company uses Microsoft 365 only for sending and receiving email. The company uses photos of employees to generate employee badges. Photos are uploaded into Microsoft 365 user profiles. The company recently started using Dynamics 365 Field Service to manage and maintain the machines that it installs for its customers. The app has not been customized. The company has added roles, skills, and certification proficiencies to Dynamics 365 Field Service resources to support both customer onsite inspections and final manufacturing inspections. Requirements Quality inspection app Fabrikam is evaluating Microsoft Power Platform to determine whether it can meet the company's requirements for a manufacturing defect and quality inspection solution. Each machine produced must be subjected to a quality inspection at various points during production. Each machine must undergo a more extensive quality inspection before the machine can be shipped to the customer. Inspection orders Inspection orders must: Allow entry of quality ratings of passed or failed for each quality metric identified for the machine being rated. Include information about the person who performed each inspection step and any comments made by the inspector. Be automatically marked as failed if one inspection step rating is marked as failed. 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. Inspectors must fill in findings comments and upload at least one photo for any inspection step that is marked as failed. Inspection standardization Standardized checklists must be stored in the solution for use by inspectors. A copy must be created when a new inspection is initiated. The solution must: Prevent an inspector from proceeding to the next step of the checklist until required information for a step is entered. Support the addition of steps to inspections to support custom features added to a machine for a customer. Support the direct input of measurements from testing gauges to avoid incorrect readings being entered by inspectors. Provide a visual representation of the testing measurement limits for each step. Include an indication of how the measured value compares to measurement limits and whether the measurement is within tolerance. Users must be able to configure the visualizations to display the minimum value and maximum value, and whether the reading is within the tolerance of a single targeted value. It must also be able to be used for maintenance inspections once the machine has been installed. Support the ability to store photo references within each inspection step to document defects found during inspections. Security Users must be active employees of Fabrikam. When a user signs into the inspection solution, the solution must display a picture of the employee who has signed in. Supervisors must be able to modify standard checklists. Other employees must be prevented from modifying checklists. You must prevent users from changing inspection order data once an inspection is marked as final. Analytics and reporting The solution must: Provide metrics including existing and upcoming demand by inspection station, average time spent per user at a station, and average time a machine spends at each inspection point. Provide metrics per inspector including number of inspections performed by month, and number of inspections per rating type (pass, fail). Provide a printed quality certificate to be included with each machine. Issues During initial testing of the solution, testers report that they cannot see the photos taken during a previously failed inspection.
Question 59
You are designing a Microsoft Power Platform solution for an automobile parts manufacturer. You create the following tables: You need to recommend a relationship behavior. Which relationship behavior should you recommend?
Correct Answer: B
Explanation Restrict Delete: Prevent the Referenced table record from being deleted when referencing tables exist. Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/configure-entity-relationship-cascading-beh
Question 60
A company plans to transition from an existing proprietary solution to a Power Platform solution. The company is consolidating data from several sources. The company reports the following data quality issues with the existing solution: Users often encounter a character limit when entering data. The database includes multiple instances of duplicate records. You need to recommend solutions to ensure that the data quality issues are not present in the Power Platform solution. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
