Ask Question
Microsoft PL-600 Practice Test - Questions Answers
Question list
List of questions
Related questions
Question 1
A company has a list of contacts in a Microsoft Excel file. The company wants to load the contact information into a Power Platform solution. You need to recommend a data-loading solution.
What should you recommend?
Use the Excel Template feature.
Add the contacts to a static worksheet.
Use the Import from Excel feature.
Explanation:
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
Question 2
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?
Option A
Option B
Option C
Option D
Explanation:
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 3
You are designing a database table for a client.
You have the following requirements:
Maintain a comprehensive list of colors and their corresponding RGB values and hexadecimal values. 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.
Mark the hex value column as business required.
Configure and schedule a recurring bulk record deletion job.
Create alternate keys for the table.
Mark the RGB value column as business required.
Explanation:
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
Question 4
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.
Consolidate asynchronous workflow into a single real-time workflow.
Consolidate multiple asynchronous workflows into a single asynchronous workflow.
Implement a business process flow to replace the existing workflows.
Convert the asynchronous workflows to a synchronous plug-in.
Question 5
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:
The vice president of sales must be able to see opportunities for sales managers and sales representatives. Sales managers must be able to see opportunities for all sales representatives. 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.
Account hierarchy
Field security profile
Position hierarchy
Security roles
Explanation:
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 6
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?
Power Platform dataflows
Data Import Wizard
import from CSV
Microsoft Excel Online
Explanation:
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:
Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file. Create a data map or use an existing data map. Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file. Create a data map or use an existing data map. Associate an import file with a data map.
Upload the content from a source file to the associated import file.
Parse the import file.
Transform the parsed data.
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 7
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.
Dataflow
Business rule
Classic workflow
Power Automate cloud flow
Duplicate detection rule
Explanation:
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 8
A company wants to add an interactive checklist to a Power Platform solution to ensure that salespeople are following the same steps when qualifying leads. You need to recommend a solution that will incorporate this checklist.
What should you recommend?
Microsoft Customer Voice
Business Process Modeler task guide
Dashboards
Business Process Flow
Question 9
You are designing tables and columns for a Power Platform solution.
The solution will contain an interactive experience dashboard.
You need to ensure that the columns you create can be used as global filters for the dashboard.
Which two data types can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Multiline Text
Choice
Text
Yes/NoE. Lookup
Explanation:
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 the following column types:
Choice
Yes/No Status Reason
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/configure-interactive-experience-dashboards
Question 10
You are designing a Power Platform solution for a company.
Users must be granted access only to data that is relevant to them.
You need to recommend actions to meet the requirements.
Which two recommendations should you make? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Add column security profiles to applicable teams.
Define and configure security roles.
Create teams and assign security roles and users to the teams.
Create business units and assign security roles to the business units.
Explanation:
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
Question