DP-300 Certification Practice Question #77

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

To restrict users from each company so they can only view data associated with their respective company, you must implement Row-Level Security (RLS). RLS is configured by creating an inline table-valued function (the security predicate) that defines the access logic (C), and then creating a security policy (E) that associates this function as a filter predicate on the target table.

More DP-300 practice questions