Exam DP-203 topic 4 question 59 discussion

Actual exam question from Microsoft's DP-203

Question #: 59
Topic #: 4

HOTSPOT
-

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Sales.Orders. Sales.Orders contains a column named SalesRep.

You plan to implement row-level security (RLS) for Sales.Orders.

You need to create the security policy that will be used to implement RLS. The solution must ensure that sales representatives only see rows for which the value of the SalesRep column matches their username.

How should you complete the code? To answer, select the appropriate options in the answer area.

Show Suggested Answer

Suggested Answer:

by jongert at Jan. 5, 2024, 5:28 p.m.

Comments

Submit Cancel

Alongi

8 months ago

Correct

upvoted 3 times

...

ArdiShah

10 months ago

Correct

upvoted 3 times

...

Happynewyear1001

11 months, 2 weeks ago

-- Create schema CREATE SCHEMA Security; GO -- Create function CREATE FUNCTION Security.tv_securitypredicate (@SalesRep AS nvarchar(50)) RETURNS TABLE WITH SCHEMABINDING AS RETURN SELECT 1 AS tv_securitypredicate_result WHERE @SalesRep = USER_NAME(); GO -- Create security policy CREATE SECURITY POLICY SalesFilter ADD FILTER PREDICATE Security.tv_securitypredicate(SalesRep) ON Sales.Orders WITH (STATE = ON);

upvoted 4 times

...

jongert

11 months, 4 weeks ago

Correct.

upvoted 4 times

...