You are designing an integration between an Azure SQL database and a model-driven app. You have the following requirements: - Audit updates to the data. - Assign security role access to tables at the user level. - Assign security role access to tables at the organization level. - Enable change tracking. - Add and update data. You need to implement virtual tables. Which two requirements can you meet by using virtual tables? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Question

Accepted Answer

C. Add and update data. Virtual tables support CUD (Create, Update, Delete) operations, enabling users to add and update data in the external Azure SQL database through the model-driven app. D. Assign security role access to tables at the organization level. Security role access can be assigned to virtual tables at the organization level, allowing all users with the appropriate role to access the external data.

Answer

A. Enable change tracking. Virtual tables do not support Dataverse's built-in change tracking capabilities as the data resides externally in the Azure SQL database.

Answer

B. Assign security role access to tables at the user level. Virtual tables do not support row-level or user-level security directly from Dataverse; security is typically managed at the organization level or within the external data source.

Answer

E. Audit updates to the data. Virtual tables do not support Dataverse's built-in auditing features, as the actual data updates and audit trails occur within the external system.

You are designing an integration between an Azure SQL database and a model-driven app. You have the following requirements: - Audit updates to the data. - Assign security role access to tables at…

Question

Options

How the community answered

Why each option

Topics

Community Discussion