Question
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:
Explanation
Dataverse table type to create for the referenced customer data.: Create a virtual table. — A virtual table surfaces data that physically remains in the external source (here, the Azure SQL database) by reading it live through a virtual connector or provider at runtime, so nothing is copied or replicated into Dataverse and the constantly changing sales data is always current in the app. The other choices — an activity table, a user-owned table, or an organization-owned table — are all standard Dataverse tables whose rows are stored in Dataverse itself, which would require importing or syncing the customer records and therefore violates the no-replication requirement.
Protect sensitive customer data for specific fields.: Create a secured column. — Column-level security (field security) lets you mark specific columns as secured and then grant Read, Update, and Create access only to the users or teams added to a column security profile, so agents without the profile cannot see the sensitive values even though they have access to the row. An alternate key only provides an alternative unique identifier for records, IME mode merely controls East Asian input behavior in a text control, and setting a field's Visible property to false only hides it in one form or app — the data is still returned and reachable through other views, exports, or the API, so it is not a security control.
