Exam DP-600 topic 1 question 150 discussion

Actual exam question from Microsoft's DP-600

Question #: 150
Topic #: 1

HOTSPOT
-

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a warehouse named DW1. DW1 contains two tables named Employees and Sales. All users have read access to Dw1.

You need to implement access controls to meet the following requirements:

• For the Sales table, ensure that the users can see only the sales data from their respective region.
• For the Employees table, restrict access to all Personally Identifiable Information (PII).
• Maintain access to unrestricted data for all the users.

What should you use for each table? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by testtaker45 at Jan. 28, 2025, 1:14 a.m.

Comments

Submit Cancel

CHZW

2 months, 4 weeks ago

Employees: Column-level security: Column-Level-Security (CLS): https://learn.microsoft.com/en-us/fabric/data-warehouse/column-level-security "allowing you to restrict column access to protect sensitive data..." Sales: Row-Level-Security (RLS): https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security "control access to rows in a database table. For example, you can ensure that workers access only those data rows that are pertinent to their department." (or Sales Region in this case)

upvoted 2 times

...

testtaker45

3 months ago

PII is a classic Column Level Security Problem Sales by Region is a classic Row Level Security Problem.

upvoted 2 times

...

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 150 discussion

Comments

CHZW

testtaker45

SY0-701