ExamGecko
Home Home / Microsoft / PL-600

Microsoft PL-600 Practice Test - Questions Answers

Question list
Search
Search

List of questions

Search

Related questions











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?

A.

Use the Excel Template feature.

A.

Use the Excel Template feature.

Answers
B.

Add the contacts to a static worksheet.

B.

Add the contacts to a static worksheet.

Answers
C.

Use the Import from Excel feature.

C.

Use the Import from Excel feature.

Answers
Suggested answer: A

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

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.

Option A

A.

Option A

Answers
B.

Option B

B.

Option B

Answers
C.

Option C

C.

Option C

Answers
D.

Option D

D.

Option D

Answers
Suggested answer: A

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

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.

A.

Mark the hex value column as business required.

A.

Mark the hex value column as business required.

Answers
B.

Configure and schedule a recurring bulk record deletion job.

B.

Configure and schedule a recurring bulk record deletion job.

Answers
C.

Create alternate keys for the table.

C.

Create alternate keys for the table.

Answers
D.

Mark the RGB value column as business required.

D.

Mark the RGB value column as business required.

Answers
Suggested answer: C, D

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

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.

A.

Consolidate asynchronous workflow into a single real-time workflow.

Answers
B.

Consolidate multiple asynchronous workflows into a single asynchronous workflow.

B.

Consolidate multiple asynchronous workflows into a single asynchronous workflow.

Answers
C.

Implement a business process flow to replace the existing workflows.

C.

Implement a business process flow to replace the existing workflows.

Answers
D.

Convert the asynchronous workflows to a synchronous plug-in.

D.

Convert the asynchronous workflows to a synchronous plug-in.

Answers
Suggested answer: A, B

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.

A.

Account hierarchy

A.

Account hierarchy

Answers
B.

Field security profile

B.

Field security profile

Answers
C.

Position hierarchy

C.

Position hierarchy

Answers
D.

Security roles

D.

Security roles

Answers
Suggested answer: C, D

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

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

A.

Power Platform dataflows

Answers
B.

Data Import Wizard

B.

Data Import Wizard

Answers
C.

import from CSV

C.

import from CSV

Answers
D.

Microsoft Excel Online

D.

Microsoft Excel Online

Answers
Suggested answer: B

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

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.

A.

Dataflow

A.

Dataflow

Answers
B.

Business rule

B.

Business rule

Answers
C.

Classic workflow

C.

Classic workflow

Answers
D.

Power Automate cloud flow

D.

Power Automate cloud flow

Answers
E.

Duplicate detection rule

E.

Duplicate detection rule

Answers
Suggested answer: A, B, C

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

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?

A.

Microsoft Customer Voice

A.

Microsoft Customer Voice

Answers
B.

Business Process Modeler task guide

B.

Business Process Modeler task guide

Answers
C.

Dashboards

C.

Dashboards

Answers
D.

Business Process Flow

D.

Business Process Flow

Answers
Suggested answer: D

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.

A.

Multiline Text

A.

Multiline Text

Answers
B.

Choice

B.

Choice

Answers
C.

Text

C.

Text

Answers
D.

Yes/NoE. Lookup

D.

Yes/NoE. Lookup

Answers
Suggested answer: B, D

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

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.

A.

Add column security profiles to applicable teams.

A.

Add column security profiles to applicable teams.

Answers
B.

Define and configure security roles.

B.

Define and configure security roles.

Answers
C.

Create teams and assign security roles and users to the teams.

C.

Create teams and assign security roles and users to the teams.

Answers
D.

Create business units and assign security roles to the business units.

D.

Create business units and assign security roles to the business units.

Answers
Suggested answer: B, D

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

Total 186 questions
Go to page: of 19