Microsoft Microsoft Certifications PL-600 Questions & Answers

• Question 51:

  You are designing a Power Platform solution.

  You need to identify the non-functional requirements for the organization.

  Which three non-functional requirements should you identify? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. business rules to identify top customers

  B. customer maintenance procedures

  C. usability of business process flows

  D. time-to-load forms

  E. solution regulatory compliance

  Correct Answer: BDE

  Non-functional requirements capture the elements that users might not directly care about but are important to support the proposed architecture and operational viability of the solution. Non-functional requirements often influence user adoption and perceived satisfaction with the solution.

  Examples of common non-functional requirement types include:

  Availability Compliance/regulatory Data retention/residency Performance (response time, and so on) Privacy Recovery time Security Scalability

  Reference: https://docs.microsoft.com/en-us/learn/modules/work-with-requirements/4-non-functional-requirements

• Question 52:

  A company is struggling to gather insights from won and lost opportunities.

  Users must be able to access the company's solution from mobile and desktop devices. The solution must meet the following requirements:

  Track opportunities and reasons for the win or loss of opportunities in the context of other related data.

  Display data to users as charts and tables and provide drill-through capabilities.

  You need to recommend a Power Platform tool to help the client visualize the data.

  Which two technologies should you recommend? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Power BI

  B. Power Automate

  C. Power Virtual Agents

  D. Power Apps

  Correct Answer: AD

  A: Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. It is part of the Microsoft Power Platform.

  D: Power BI Apps are an easy way for designers to share different types of content at one time. App designers create the dashboards and reports and bundle them together into an app. The designers then share or publish the app to a location where you, the business user, can access it. Because related dashboards and reports are bundled together, it's easier for you to find and install in both the Power BI service (https://powerbi.com) and on your mobile device. After you install an app, you don't have to remember the names of a lot of different dashboards or reports because they're all together in one app, in your browser or on your mobile device.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/consumer/end-user-apps

• Question 53:

  You are designing a Power Platform solution for a company. The company issues each employee a tablet device.

  The company wants to simply the opportunity management processes and automate when possible. The company identifies the following requirements:

  1.

  Users must have a visual guide to know which data to enter in each step of the opportunity management process.

  2.

  The system must automatically assign the opportunity to a manager for approval once all data is entered.

  3.

  The system must notify an assignee each time an opportunity is assigned to them by using push notifications.

  4.

  When a user selects a push notification, the associated opportunity must display.

  You need to recommend the Power Platform components that will meet their requirements.

  Which three Power Platform components should you recommend? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Business process flows

  B. Power Apps mobile apps

  C. Power Virtual Agents chatbots

  D. Power Automate desktop flows

  E. Power Automate cloud flows

  Correct Answer: ABE

  A: Use business process flows to define a set of steps for people to follow to take them to a desired outcome. These steps provide a visual indicator that tells people where they are in the business process.

  B: Push notifications are used in Power Apps mobile to engage app users and help them prioritize key tasks. In Power Apps, you can create notifications for Power Apps mobile by using the Power Apps Notification connector. You can send notifications to any app that you create in Power Apps.

  E: Create a cloud flow when you want your automation to be triggered either automatically, instantly, or via a schedule.

  Automated flows: Create an automation that is triggered by an event such as arrival of an email from a specific person, or a mention of your company in social media.

  Reference: https://docs.microsoft.com/en-us/power-automate/business-process-flows-overview https://docs.microsoft.com/en-us/powerapps/mobile/power-apps-mobile-notification

• Question 54:

  You are designing a Power Platform solution.

  The company wants its development team to create an interactive slider visualization to indicate and filter timeframe data that can be used across all of its apps that can be styled and manipulated by using code.

  You need to recommend a technology that meets these requirements.

  Which technology would you recommend the developers adopt to assist the implementation team?

  A. Web resource

  B. Power Apps Component Framework control

  C. JavaScript

  D. Canvas app

  Correct Answer: B

  Power Apps component framework empowers professional developers and app makers to create code components for model-driven and canvas apps. These code components can be used to enhance the user experience for users working with data on forms, views, dashboards, and canvas app screens. For example, you can:

  Replace a column on a form that displays a numeric text value with a dial or slider code component.

  Reference: https://docs.microsoft.com/en-us/powerapps/developer/component-framework/overview

• Question 55:

  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:

  1.

  The owner data in the lead table and the third-party application do not match.

  2.

  The Topic column has more information than the related record from the marketing application.

  3.

  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.

  A. Dataflow

  B. Business rule

  C. Classic workflow

  D. Power Automate cloud flow

  E. Duplicate detection rule

  Correct Answer: ABC

  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:

  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.

  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 56:

  You are designing a model-driven app that allows a company to manage sales opportunities.

  The company has a complex security model that includes the following requirements:

  1.

  The vice president of sales must be able to see opportunities for sales managers and sales representatives.

  2.

  Sales managers must be able to see opportunities for all sales representatives.

  3.

  Sales representatives must only see opportunities that they own.

  You need to recommend security tools for controlling user access.

  Which two tools should you recommend? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Account hierarchy

  B. Field security profile

  C. Position hierarchy

  D. Security roles

  Correct Answer: CD

  With the position hierarchy security, a user at a higher position has access to the records owned by a lower position user or by the team that a user is a member of, and to the records that are directly shared to the user or the team that a user

  is a member of.

  The hierarchy security model is an extension to the earlier security models that use business units, security roles, sharing, and teams. It can be used in conjunction with all other existing security models.

  Reference:

  https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/security-dev/ hierarchical-security-control-access-entities

• Question 57:

  A company sells antique books. The company stores data about book locations in an existing system by using the following database fields: Room, Shelf.

  The company must import the data from the existing system into a Power Platform solution. Existing data into must be modified to match the design of the new solution.

  You need to recommend a solution to combine the room and shelf fields into a single column during the import process.

  Which tool should you recommend?

  A. Power Platform dataflows

  B. Data Import Wizard

  C. import from CSV

  D. Microsoft Excel Online

  Correct Answer: B

  Dataverse includes a web application tool called Import Data Wizard. You use this tool to import data records from one or more comma-separated values (.csv), XML Spreadsheet 2003 (.xml), or text files. Use transformation mapping to

  modify data before importing it. For example, split a full name that is contained in the source file into a first name and a last name to match the target columns for a table.

  Note:

  To implement data import, you typically do the following:

  1.

  Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file.

  2.

  Create a data map or use an existing data map.

  3.

  Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file.

  4.

  Create a data map or use an existing data map.

  5.

  Associate an import file with a data map.

  6.

  Upload the content from a source file to the associated import file.

  7.

  Parse the import file.

  8.

  Transform the parsed data.

  9.

  Upload the transformed data into the target Dataverse server.

  Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/import-data

  https://docs.microsoft.com/en-us/powerapps/developer/data-platform/add-transformation-mappings-import

• Question 58:

  A company is implementing Dynamics 365 Sales.

  The company has turned off out-of-the-box quote calculations in order to implement its own custom calculations.

  When users update a line item on a quote, they expect to see an updated total for the quote in real time. Users are reporting inconsistent behavior, with some aggregations taking up to two hours.

  You review the system design and notice many asynchronous workflows.

  You need to recommend a solution to enable the calculation in real time.

  Which two options should you recommend? Each answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Consolidate asynchronous workflow into a single real-time workflow.

  B. Consolidate multiple asynchronous workflows into a single asynchronous workflow.

  C. Implement a business process flow to replace the existing workflows.

  D. Convert the asynchronous workflows to a synchronous plug-in.

  Correct Answer: AB

• Question 59:

  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:

  1.

  Track the courses in which each student is enrolled.

  2.

  Track the students that are enrolled in each course.

  3.

  Track dates when each student enrolled in each course and the person who approved the enrollment.

  4.

  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. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct 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

• Question 60:

  You are designing a database table for a client. You have the following requirements:

  1.

  Maintain a comprehensive list of colors and their corresponding RGB values and hexadecimal values.

  2.

  Prevent the addition of duplicate colors based on the hexadecimal value for the color.

  You need to recommend a design for the table.

  Which two actions should the client perform after the table is created? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Mark the hex value column as business required.

  B. Configure and schedule a recurring bulk record deletion job.

  C. Create alternate keys for the table.

  D. Mark the RGB value column as business required.

  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