Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 3

© examsnet.com

Question : 3 of 33

Marks: +1, -0

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.
Hot Area:

Create: ______
A materialized view in DB1
A security policy in the Orders table
Database scoped credentials in DB1
Control access to the rows by using: ______
A masking rule
A table-valued function
The CONTAINS predicate

Go to Question:

Prev Question

Next Question