Free PL-200 Exam Braindumps
Microsoft Power Platform Functional Consultant Questions 73–80 (page: 11)

Updated On: 10-Jun-2026

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

A company uses Dataverse.

The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.

You need to recommend a solution.

Solution: Configure SharePoint Online integration.

Does the solution meet the goal?

  1. Yes
  2. No

Answer(s): A

Explanation:

Integrating SharePoint Online with Dataverse is an effective way to store and manage documents while minimizing Dataverse storage consumption. Dataverse storage is expensive, and storing documents in SharePoint instead of directly in Dataverse significantly reduces storage usage and costs. SharePoint provides document management features, including version control and metadata, making it the preferred solution for handling files in Power Platform solutions.



Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

A company uses Dataverse.

The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.

You need to recommend a solution.

Solution: Add a File column to a table.

Does the solution meet the goal?

  1. Yes
  2. No

Answer(s): B

Explanation:

Adding a File column to a Dataverse table stores the documents directly in Dataverse storage, which consumes Dataverse storage capacity. Since Dataverse storage is limited and costly, this approach does not minimize storage consumption.
A better solution would be configuring SharePoint Online integration to store documents externally while keeping references in Dataverse, which reduces Dataverse storage usage.



Your organization does not permit the use of custom code for solutions.

You need to create a view that can be viewed by all users in an organization.

Where should you create the view?

  1. System Settings
  2. Microsoft Excel template
  3. Microsoft Visual Studio
  4. Table component of a solution

Answer(s): D

Explanation:

In Dataverse, views are created at the table level within a solution. By configuring a public view in the table component of a solution, you ensure that all users in the organization can access it. This method does not require custom code and aligns with the organization's restrictions.



Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

A company uses Dataverse.

The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.

You need to recommend a solution.

Solution: Configure SharePoint on-premises integration.

Does the solution meet the goal?

  1. Yes
  2. No

Answer(s): B

Explanation:

While SharePoint on-premises can be integrated with Dataverse, it does not provide the same seamless storage optimization as SharePoint Online integration. Microsoft Power Platform natively supports SharePoint Online for storing documents externally, which significantly reduces Dataverse storage consumption. However, SharePoint on-premises requires additional setup and does not integrate as efficiently with Power Platform.
For minimizing Dataverse storage, SharePoint Online integration would be the preferred solution.



DRAG DROP (Drag and Drop is not supported)

You are configuring Dataverse for a company.

The company has the following requirements for document management, which must be met by using native functionality:

A single file must be stored and accessed directly from an Account row. No additional metadata should be captured.
Multiple files must be stored and accessed from a Contact with support for version control.

Documents must be stored within an on-premises environment.

Additional rich-text notes must be stored alongside one or multiple file uploads.

You need to recommend a solution for each requirement.

Which solution should you recommend? To answer, move the appropriate solutions to the correct requirements. You may use each solution once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Document Column
Save a file an Account row.
A single file must be stored and accessed directly from an Account row. No additional metadata should be captured.

Document Columns
Primarily designed for storing binary data like images or files.
Can have a defined maximum file size.
Do not inherently support rich text formatting or metadata storage beyond the file itself.

Box 2: Microsoft Azure Blob Storage
Store multiple files by using version control.
Multiple files must be stored and accessed from a Contact with support for version control.

Blob versioning
You can enable Blob storage versioning to automatically maintain previous versions of an object. When blob versioning is enabled, you can access earlier versions of a blob to recover your data if it's modified or deleted.

Box 3: Microsoft Sharepoint
Host documents on premises.
Documents must be stored within an on-premises environment.

Microsoft SharePoint can be used to host documents within an on-premises environment. SharePoint Server, a separate product from SharePoint Online (the cloud-based version), is specifically designed for on-premises deployments. Organizations can choose to install and manage SharePoint Server on their own servers, giving them full control over their data and infrastructure. This allows for hosting documents and other files within the company's own data center.

Box 4: Attachments
Upload documents that have rich-text metadata.
Additional rich-text notes must be stored alongside one or multiple file uploads.

Dataverse attachments, specifically those stored as notes or using the attachment control, do not directly support rich-text metadata within the file itself. While you can upload files with rich-text formatting (like .docx or .html) using the attachment control, the metadata associated with the attachment is limited to basic information like the file name and the record it's related to. To manage richer metadata, you'd need to implement a separate system or use a custom solution.


Reference:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/file-column-data https://support.microsoft.com/en-us/office/what-is-sharepoint-97b915e6-651b-43b2-827d-fb25777f446f https://learn.microsoft.com/en-us/azure/storage/blobs/versioning-overview



A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables.

You need to identify the capabilities of virtual tables.

What is a capability of virtual tables?

  1. Virtual tables store data in the Dataverse environment.
  2. Virtual tables contain time dimension attributes by default.
  3. Virtual tables support change tracking.
  4. Virtual tables retrieve data from an external data source.

Answer(s): D

Explanation:

Correct:

* Virtual tables require configuration of a data provider.
* Virtual tables retrieve data from an external data source.
Incorrect:

* Virtual tables can be configured for user and team ownership.
* Virtual tables contain columns for Status, Created On, and Modified On by default.
* Virtual tables contain time dimension attributes by default.
* Virtual tables store data in the Dataverse environment.
* Virtual tables support change tracking.
* Virtual tables support Dataverse auditing.
Note:

* Virtual tables require configuration of a data provider.
A virtual table is a definition of a table in the Dataverse platform without the associated physical tables for records created in the Dataverse database. Instead during runtime, when a record is required, its state is dynamically retrieved from the associated external system. Each virtual table type is associated with a virtual table data provider and (optionally) some configuration information from an associated virtual table data source.
* Virtual tables retrieve data from an external data source.
Virtual tables are a powerful feature of Microsoft Dataverse that allow you to connect external data sources and use them as if they were native tables in your apps, automations, and agents. Virtual tables enable you to leverage data from various sources without having to copy or sync it into Dataverse.


Reference:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/get-started-ve https://byrondittberner.com/blog/2023/03/19/simplifying-virtual-tables-power-platform-2023-wave-1



View Related Case Study

HOTSPOT (Drag and Drop is not supported)

You need to address the executive's concerns regarding unnecessary data access.

Which security changes should you make? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Assign records to a service account and add the team member doing the verification by using an access team.
When to use access teams
* The teams are dynamically formed and dissolved. This typically happens if the clear criteria for defining the teams, such as established territory, product, or volume aren't provided.
* The team members require different access rights on the records. You can share a record with several access teams, each team providing different access rights on the record. For example, one team is granted the Read access right on the account and another team, the Read, Write and Share access rights on the same account.
* A unique set of users requires access to a single record without having an ownership of the record.

Box 2: Assign records to the QV team when the service request is completed. Issues: More employees than are required can access individual client information and continue to have access after a service request is completed.

Management has decided to create a new qualification verification (QV) role to help ensure that clients get the most accurate results. This role examines completed work to ensure that nothing is missed.

· When users go on vacation, all their outstanding Service Request records are assigned to a substitute employee. The substitute employees are unable to see all the qualifications related to their service requests.


Reference:

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/use-access-teams-owner- teams-collaborate-share-information



View Related Case Study

HOTSPOT (Drag and Drop is not supported)

You need to resolve the issue reported by substitute employees after they are assigned service requests.

How should you configure the system? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Service Request 1:N Qualification
When users go on vacation, all their outstanding Service Request records are assigned to a substitute employee. The substitute employees are unable to see all the qualifications related to their service requests.

Box 2: Cascade All
Cascade All - Perform the action on all referencing table records associated with the referenced table record.


Reference:

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/configure-entity-relationship- cascading-behavior



Viewing page 11 of 42
Viewing questions 81 - 88 out of 328 questions


Post your Comments and Discuss Microsoft PL-200 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!