exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam

Exam PL-200 topic 1 question 44 discussion

Actual exam question from Microsoft's PL-200
Question #: 44
Topic #: 1
[All PL-200 Questions]

HOTSPOT -
A company has a sales application that is supported by an Azure SQL database. You are developing a Power Apps app for use by customer service agents.
The app must reference customer data from the sales application. Data in the sales application is constantly changing and must not be replicated in Microsoft
Dataverse.
Some customer data is considered sensitive. You must protect data for specific fields when users view data in the app.
You need to configure table creation for the app.
How should you configure the app? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Create a virtual table -
A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.

Box 2: Create a secured column -
Add a secured column to a Data Source
You create columns for a Data Source in the same way as any other table. For data that is encrypted or sensitive, enable the Data Source Secret attribute on the custom column of the Data Source.

Reference:
https://docs.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-virtual-entities

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
llc
Highly Voted 1 year, 11 months ago
Correct answers are : 1. Create a virtual table. 2. Create a secured column 1 => Because data should not be replicated according to the question. 2 => Some specific fields are more sensible than others so we need column-level security.
upvoted 17 times
...
wsjones
Highly Voted 1 year, 2 months ago
was on test - 8/1/2023
upvoted 5 times
...
jkaur
Most Recent 6 months, 2 weeks ago
1. Create a virtual table. 2. Create a secured column
upvoted 1 times
...
ttien
1 year, 1 month ago
on exam 20/9/2023
upvoted 2 times
...
IvanaDomijanic
1 year, 4 months ago
In exam 06/2023
upvoted 3 times
...
Ikhalil
1 year, 7 months ago
Correct answers
upvoted 3 times
...
abhigang51
1 year, 11 months ago
Featured in 23/11/2022 exam
upvoted 4 times
...
Clubsodas
2 years, 1 month ago
I selected "Create a Virtual Table" and "Set the value of the visible property of the fields to false" For question 1, a virtual table fulfills the requirement of "must not be replicated in Microsoft Dataverse" For question 2, you would need to do field level security but this is not an option. The requirement is from the perspective of a user, so making a field invisible in the app would fulfill this requirement.
upvoted 5 times
Clubsodas
2 years, 1 month ago
My original answer was wrong. See my reply for the correct answer.
upvoted 5 times
...
Clubsodas
2 years, 1 month ago
You can use secured columns to protect field (column) data. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-virtual-entities. Answer should be: 1. Create a virtual table. 2. Create a secured column.
upvoted 21 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago