DP-203 Certification Practice Question #216

Question

You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.
You need to ensure that users from each company can view only the data of their respective company.
Which two objects should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Accepted Answer

The requirement is classic row-level security: all companies share the same dedicated SQL pool, but each user must see only their own company?s rows. In Synapse dedicated SQL pools, that is implemented by creating a predicate function that evaluates the user/company context and binding it to the table through a security policy. Azure RBAC does not solve per-row filtering inside SQL tables, so A + C is the supported pair.

More DP-203 practice questions