QUESTION: 89

A company has a list of contacts in a Microsoft Excel file. The company wants to load the contact information into a Microsoft 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.

Answer(s): 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

Reveal Solution Next Question

QUESTION: 90

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?

Answer(s): 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

Reveal Solution Next Question

QUESTION: 91

HOTSPOT (Drag and Drop is not supported)
A company plans to create a Power Apps portal to manage support cases for customers. The company has an account hierarchy for customers. The hierarchy supports accounts, cases, and contacts where both contacts and cases belong to their relevant account.
The company has the following requirements:
-Portal users must only see the notes for the cases that they manage.
-Portal users must only see cases that are submitted by their colleagues.
You need to design the security model for the portal.
Which entity permission scope should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Contact
With Contact scope, a signed-in user in the role for which the permission record is defined will have the rights granted by that permission only for records that are related to that user's contact record via a defined relationship.
Box 2: Account
With Account Scope, a signed-in user in the role for which the permission record is defined will have the rights granted by that permission only for records that are related to that user's parent account record via a defined relationship.
This scope means that the entity list will only show the records of the selected entity that are associated to the user's parent account. For example, if an entity permission allows Read access to Lead entity with the Account scope, the user having this permission can view all the leads of only the parent account of the user.
Incorrect Answers:
Self Scope allows you to define the rights a user has to their own Contact (Identity) record. Users can use entity forms or web forms to make changes to their own
Contact record linked with their profile.
Parental scope: In this most complex case, permissions are granted for an entity that is a relationship away from an entity for which an Entity Permission record has already been defined. This permission is actually a child record of the parent entity permission.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/assign-entity-permissions

Reveal Solution Next Question

QUESTION: 92

HOTSPOT (Drag and Drop is not supported)
A company offers continuing education courses for medical professionals. Each time a course is offered, the company tracks that the session has taken place in an Excel workbook.
The company maintains a list of required qualifications for an educator to teach a course. Educator qualifications range from languages spoken to advanced degrees.
The company needs the following custom table relationships defined:
-Associate educators with a list of their professional qualifications.
-Assign a primary educator to each course that is held.
-Collect information about every course that is held.
You need to determine the type of relationship that best fits the requirement.
Which type of table relationship should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: One-to-many relationship
Each educator can have 0, 1, or many qualifications
Box 2: One-to-many relationship
Each educator can be the primary educator for 0, 1 or many cources.
Box 3: Many-to-many relationship that uses a custom table.
Note: 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.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships

Reveal Solution Next Question

Free PL-600 Exam Braindumps (page: 24)

QUESTION: 89

Explanation:

Reference:

QUESTION: 90

Explanation:

Reference:

QUESTION: 91

Explanation:

Reference:

QUESTION: 92

Explanation:

Reference:

PL-600 Discussions & Posts