Exam DP-300 topic 2 question 25 discussion

Actual exam question from Microsoft's DP-300

Question #: 25
Topic #: 2

HOTSPOT
-

You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order.

You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders.

What should you include in the solution? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by BrenFa101 at Feb. 3, 2023, 1:59 p.m.

Comments

Submit Cancel

BrenFa101

Highly Voted 11 months ago

Answer is correct. Row-level security is implemented via CREATE SECURITY POLICY and using in-table function

upvoted 6 times

voodoo_sh

6 months, 2 weeks ago

Security Policy Table-valued function T-SQL: CREATE FUNCTION fn_securitypredicate(@UserName AS sysname) RETURNS TABLE WITH SCHEMABINDING AS RETURN SELECT 1 AS fn_securitypredicate_result FROM dbo.Orders WHERE @UserName = suser_sname() ; CREATE SECURITY POLICY OrdersSecurityPolicy ADD FILTER PREDICATE dbo.fn_securitypredicate(UserName) ON dbo.Orders WITH (STATE = ON);

upvoted 1 times

...

Pranava_GCP

Most Recent 8 months ago

Answer is correct. Implement RLS by using the CREATE SECURITY POLICY Transact-SQL statement, and predicates created as inline table-valued functions. https://learn.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver16

upvoted 3 times

...