DP-203 · Question #189
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…
The correct answer is A. a security policy C. a function. Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Implement RLS by using the CREATE SECURITY POLICY Transact- SQL statement, and predicates created as inline table-valued functions…
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.
Options
- Aa security policy
- Ba custom role-based access control (RBAC) role
- Ca function
- Da column encryption key
- Easymmetric keys
How the community answered
(39 responses)- A72% (28)
- B8% (3)
- D3% (1)
- E18% (7)
Explanation
Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Implement RLS by using the CREATE SECURITY POLICY Transact- SQL statement, and predicates created as inline table-valued functions. https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql- server-ver16#CodeExamples
Topics
Community Discussion
No community discussion yet for this question.