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.

Correct Answer:

Explanation:

Requirement Analysis
Sales table # Users should only see sales data for their own region .
This requires filtering rows based on a condition (e.g., Region = User's Region).
The correct feature: Row-level security (RLS) .
Employees table # Restrict access to Personally Identifiable Information (PII) while allowing access to non- sensitive columns.
This requires restricting access to specific columns (such as SSN, phone, address, etc.), but leaving others visible.
The correct feature: Column-level security .
Maintain access to unrestricted data for all users # Both RLS and column-level security allow users to continue accessing non-restricted data.
Why Other Options Are Not Correct
Item permissions : Control access at the object level (e.g., table or report), not at the row or column level. Too coarse for this requirement.
Workspace permissions : Apply at the workspace level, not suitable for table-level data filtering.
Completed Answer
Employees # Column-level security
Sales # Row-level security (RLS)
References
Row-level security in Microsoft Fabric
Column-level security in Microsoft Fabric

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1.
You need to ensure that Model1 supports XMLA connections.
Which setting should modify?

• A.Users can edit data models in the Power BI service
• B.Enforce strict access control for all data connection types
• C.Enable Cache for Shortcuts
• D.License mode

Comment: *

Name: *

Email: *

Verification: *

Which workspace rote assignments should you recommend for ResearchReviewersGroupl and ResearchReviewersGroupZ? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that uses a Microsoft Power BI Premium capacity.
You need to enable scale-out for a semantic model.
What should you do first?

• A.At the semantic model level, set Large dataset storage format to Off.
• B.At the tenant level, set Create and use Metrics to Enabled.
• C.At the semantic model level, set Large dataset storage format to On.
• D.At the tenant level, set Data Activator to Enabled.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric warehouse that contains a table named Staging.Sales. Staging.Sales contains the following columns.

You need to write a T-SQL query that will return data for the year 2023 that displays ProductID and ProductName arxl has a summarized Amount that is higher than 10,000. Which query should you use?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *