Black Friday50% off your first month on any monthly plan with EARLY50 See plans
All 33 lessons
  1. Start here: cloud and data basics

    1. 1. Start here: the exam, the plan and what you already know
    2. 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
    3. 3. Data basics: files, tables, formats and the lakehouse idea
    4. 4. A tour of Microsoft Fabric: OneLake, workspaces and items
    5. 5. The three languages: SQL, PySpark and KQL side by side
    6. 6. Getting data in: the map of Fabric tools
  2. Store, ingest and transform batch data (exam area 2, 30-35%)

    1. 7. Choosing a data store and a transformation tool
    2. 8. Shortcuts and mirroring: use data without copying it
    3. 9. Ingest data with pipelines and Copy job
    4. 10. Transform with PySpark and SQL: join, denormalize, aggregate
    5. 11. Messy data: duplicates, missing values and late arrivals
    6. 12. Full and incremental loads, and loading a star schema
  3. Orchestrate and stream (exam areas 1 and 2)

    1. 13. Pipeline or notebook? Choosing how to orchestrate
    2. 14. Schedules and event-based triggers
    3. 15. Parameters and dynamic expressions
    4. 16. Streaming in Fabric: Eventstreams, Spark streaming and KQL
    5. 17. KQL and windowing functions for real-time data
  4. Set up and secure a Fabric solution (exam area 1, 30-35%)

    1. 18. Workspace settings: Spark, domains, OneLake and data workflows
    2. 19. Version control with Git and database projects
    3. 20. Deployment pipelines: development, test and production
    4. 21. Who can see what: workspace roles and item permissions
    5. 22. Fine-grained security: rows, columns, objects, files and masking
    6. 23. Governance: sensitivity labels and endorsement
  5. Monitor, fix and optimize (exam area 3, 30-35%)

    1. 24. Monitoring hub, alerts and Activator
    2. 25. Fixing errors in pipelines, dataflows and notebooks
    3. 26. Fixing errors in Eventhouse, Eventstream and T-SQL
    4. 27. Optimize lakehouse tables: V-Order, OPTIMIZE, VACUUM and partitions
    5. 28. Optimize Spark, pipelines and warehouses
    6. 29. Optimize eventstreams, eventhouses and queries
  6. Exam practice and final review

    1. 30. Exam day: question types, timing and how to think
    2. 31. Mock exam 1
    3. 32. Mock exam 2
    4. 33. Final review: every decision on one page
See the leaderboard

18 min

Who can see what: workspace roles and item permissions

Grant the least access a person needs with workspace roles and item-level sharing.

By the end of this lesson you can

  • Pick the lowest workspace role that covers a person's tasks
  • Share one item with the right item permissions
  • Tell ReadData from ReadAll for a Lakehouse or Warehouse
  • Place OneLake security roles next to roles and sharing

From earlier lessons · 1 of 2

Northwind Rides deploys a Warehouse from Test to Prod with a deployment pipeline. Which of these is not copied to Prod?

Pick one answer.

From earlier lessons · 2 of 2

A release manager is a pipeline admin but has no role in the Test or Prod workspaces. What can this person do with the pipeline?

Pick one answer.

Northwind Rides' data workspace is getting crowded. The ops manager wants everyone made Admin "so nobody gets blocked". A finance analyst needs to query payments, and nothing else. A partner's data scientist needs one Lakehouse for a month. You must give each person exactly the access they need.

[4]

Three layers of access

Exam depth: know it cold.

Fabric controls access in layers, from broad to narrow.

  1. Workspace roles apply to every item in a workspace.
  2. Item permissions apply to one item that you share, without giving workspace access.
  3. Granular security limits what someone sees inside an item: folders, tables, rows or columns.

Microsoft calls the first two the control plane: what you can do to items. The third is the data plane: which data you can see. Layer 3 is the next lesson.

[196]

Rendering diagram…
Broad to narrow: a role covers the workspace, sharing covers one item, granular security covers part of an item.

[196]

The four workspace roles

Exam depth: know it cold.

A workspace role is a set of rights over a whole workspace. There are four: Admin, Member, Contributor and Viewer.

You can assign a role to a person, a security group, a Microsoft 365 group or a distribution list. If someone gets roles through several groups, the highest one wins.

CapabilityAdminMemberContributorViewer
Update or delete the workspace.✅❌❌❌
Add or remove anyone, including Admins.✅❌❌❌
Connect the workspace to Git.✅❌❌❌
Add people with Member role or lower.✅✅❌❌
Share items and allow others to reshare.✅✅❌❌
Publish an app.✅✅❌❌
Create, edit and delete items.✅✅✅❌
Run or cancel notebooks and pipelines.✅✅✅❌
Read data with Spark or OneLake APIs (ReadAll).✅✅✅❌
Read Lakehouse or Warehouse data with T-SQL (ReadData).✅✅✅✅
View items and run output.✅✅✅✅

[191][192][193]

[191][192]

Match

Match each Northwind task to the lowest workspace role that can do it

Pick an item on the left, then its match on the right.

[191][192]

You are a data engineer at Northwind Rides. A new engineer must create Notebooks and Pipelines and run them in the data workspace. They must not add people or share items. You need to follow least privilege. Which role should you assign?

Pick one answer.

[191]

Least privilege: hand over the one item they need, not the keys to the whole workspace. Picture: Classic two-panel reaction meme, cartoon style.

Item permissions: share one item

Exam depth: know it cold.

Sharing grants item permissions: rights on one item, with no access to the rest of the workspace. Admins and Members can share by default. A Contributor or Viewer needs Reshare permission to share.

Permission (name in the share dialog)What it allows
Read (always included).Find and open the item. Connect to its SQL endpoint, but query nothing.
ReadData (Read all with SQL analytics endpoint, or Read all data using SQL).Query every table and view with T-SQL, read-only.
ReadAll (Read all with Apache Spark).Read the files with Spark, OneLake APIs or the Lakehouse explorer.
Write (Edit).Change the item and its content.
Reshare (Share).Share onward, up to your own permissions.
Build.Build new content on a semantic model.
Execute.Run or cancel the item.

[167][194][195]

Workspace roles carry these permissions on a Warehouse automatically.

PermissionGiven by default to
Read and ReadData.Admin, Member, Contributor, Viewer.
ReadAll, Write, and Monitor (view running queries and sessions).Admin, Member, Contributor.
Reshare.Admin, Member.
Audit (set up and read audit logs).Admin.

[195]

The Manage permissions page of a Warehouse. Workspace Admin and Member rows show Read, Write, Reshare, ReadData, ReadAll. A Contributor shows Read, Write, ReadData, ReadAll. Two shared users with no role show Read, ReadData, ReadAll and Read, ReadData.
Microsoft Learn, CC BY 4.0

[167][194][195]

You are a data engineer at Northwind Rides. A finance analyst outside the data workspace must query every table in the payments Warehouse with T-SQL. They must not edit anything or see other items. What should you do?

Pick one answer.

[195]

You are a data engineer at Northwind Rides. A partner's data scientist works in their own workspace. They must read the trips Lakehouse's Delta files from a Spark notebook, with least privilege. What should you grant?

Pick one answer.

[167][194]

Where OneLake security fits

Exam depth: know it cold.

OneLake security lets you create roles inside an item that grant access to chosen tables, folders, rows or columns. Older pages call these OneLake data access roles.

  • Roles only grant access. There are no deny roles.
  • Admins and Members create them.
  • They limit Viewers and people with Read on the item. Admins, Members and Contributors already have all the data, so the roles don't restrict them.
  • Each Lakehouse has a DefaultReader role. It gives everyone with ReadAll access to all its data.

The next lesson shows how to build these roles.

[196][197]

[197]

Least privilege: the decision rule

Exam depth: know it cold.

Ask three questions in order.

  1. Does the person build or run things in this workspace? Give the lowest role that covers it. Usually that's Contributor.
  2. Do they only read one item? Share that item. Add ReadData for T-SQL or ReadAll for Spark.
  3. Must they see only part of the item? Add granular security on top.

Decision rule: share an item when the person needs one item; assign a role when they need the workspace.

[167][191][196]

Try it in Fabric

A free Fabric trial is enough. You need a workspace where you're Admin, with a Lakehouse in it.

Give a workspace role

  1. Open the workspace and select Manage access.
  2. Select Add people or groups.
  3. Enter a name or email, choose Viewer, and select Add.

Share one item

  1. In the workspace list, select the Share icon next to your Lakehouse.
  2. Enter a person and tick Read all with Apache Spark. Select Grant.
  3. Select ... next to the Lakehouse, then Manage permissions. Check the Direct access list.

[193][194]

Exam-style practice

You are a data engineer at Northwind Rides. You hold the Member role. A Viewer on your team now needs Contributor. You try to change the role and can't. You need the change made. What should happen?

Pick one answer.

[192]

You are a data engineer at Northwind Rides. Ops staff have the Viewer role. They complain they can't read the trips Lakehouse from a Spark notebook, but T-SQL works. You need them to read with Spark, with least privilege. What should you do?

Pick one answer.

[191][197]

FlashcardsIndex cardsFlashcards ⚡

Card 1 of 15

[167][191][192][195][196][197]

Worth keeping

  1. Admin manages the workspace; Member adds people; Contributor builds; Viewer reads.
  2. Share an item for one-item access; assign a role for the whole workspace.
  3. ReadData is T-SQL reads; ReadAll is Spark and OneLake reads.
  4. OneLake security roles only narrow access for Viewers and Read users.
  5. Least privilege: pick the lowest role or permission that still works.

The finance analyst can now read every payments table, including card numbers. Next lesson: how to show them only their region's rows and hide or mask the sensitive columns.

Leaderboard

Loading…

50 XP for each lesson you finish, 10 for each right answer. Names show only for learners who turn on Show me on leaderboards.

Sources for this lesson (10)

Each fact in the lesson is marked with the number of the page it comes from.

  1. [4]Microsoft Learn: Study Guide for Exam DP-700
  2. [167]Microsoft Learn: Share items in Microsoft Fabric
  3. [185]Microsoft Learn: The deployment pipelines process
  4. [191]Microsoft Learn: Roles in workspaces in Microsoft Fabric
  5. [192]Microsoft Learn: Roles in workspaces in Power BI
  6. [193]Microsoft Learn: Give users access to workspaces
  7. [194]Microsoft Learn: How lakehouse sharing works
  8. [195]Microsoft Learn: Share your data and manage permissions
  9. [196]Microsoft Learn: Data security in OneLake
  10. [197]Microsoft Learn: How OneLake security controls data access