nerdexam
Microsoft

DP-300 · Question #109

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 C. a function E. a security policy. 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…

Submitted by haru.x· Mar 6, 2026Implement a secure environment

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 column encryption key
  • Basymmetric keys
  • Ca function
  • Da custom role-based access control (RBAC) role
  • Ea security policy

How the community answered

(41 responses)
  • A
    2% (1)
  • B
    12% (5)
  • C
    78% (32)
  • D
    7% (3)

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/azure/synapse-analytics/security/synapse-workspace-synapse- https://docs.microsoft.com/en-us/security/benchmark/azure/baselines/synapse-analytics-security- https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice