DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ58

Implement a secure environment

You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will serve multiple companies.

You must ensure that users from each company can view only their own company's data.

Which two objects should be included in the solution? Each correct answer presents part of the solution.

> NOTE: Each correct selection is worth one point.

Choose two
Explanation

Row-level security restricts access to specific table rows according to the querying user’s profile or execution context. It is implemented by defining a predicate function and binding that function to the target table in a security policy as a filter predicate. Azure Synapse dedicated SQL pools support row-level security.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!