Which two objects should you include in the solution?

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 it worth one point.
A . a custom role-based access control (RBAC) role.
B . asymmetric keys
C . a predicate function
D . a column encryption key
E . a security policy

View Answer

Answer: C,E

Explanation:

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security

https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-access-control-overview