Chapter 1 of 3 · Microsoft DP-600
Maintain a Data Analytics Solution
Fabric workspace and item access, row, column and file security, sensitivity labels, Git, deployment pipelines and XMLA.
- 5topics
- 26 minfast track
- 1diagrams and exhibits
- 25–30%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Workspace and Item Access ControlsFabric workspace roles Admin, Member, Contributor and Viewer, item permissions such as Read, ReadData, ReadAll and Build, and…5 min
- 2Row, Column, Object and File SecurityFabric granular security: T-SQL GRANT and DENY, warehouse security policies, semantic model RLS and OLS, and OneLake security…Diagram6 min
- 3Sensitivity Labels and EndorsementApply Microsoft Purview sensitivity labels to Fabric items, label inheritance and export, plus endorsing items as Promoted…5 min
- 4Git Integration, PBIP and Deployment PipelinesConnect a Fabric workspace to Git, save Power BI Desktop projects as .pbip with TMDL, and promote content with deployment…5 min
- 5Impact Analysis, XMLA and Reusable AssetsFabric impact analysis before changes, deploying semantic models over the XMLA endpoint, and reusable .pbit, .pbids files and…5 min
About this chapter
What this chapter covers
Maintain a data analytics solution is 25 to 30% of the Microsoft DP-600 exam. It has two skill groups: implementing security and governance, and maintaining the analytics development lifecycle.
Security and governance covers workspace roles, item permissions, row-level, column-level, object-level and file-level security, sensitivity labels and endorsement. The lifecycle group covers Git integration, Power BI Desktop projects (.pbip), deployment pipelines, impact analysis, the XMLA endpoint and reusable assets such as templates, .pbids files and shared semantic models.
Questions are mostly short scenarios: you pick the role, permission, file type or tool that meets a requirement with the least privilege or the least effort.
How the topics fit together
The first chain narrows access from the whole workspace down to single rows, then marks how trusted and how sensitive each item is. The second chain moves content safely from a developer's machine to production and keeps it reusable.
When two answers both work, DP-600 usually wants the one that grants the least access. A Viewer role or a single item permission beats Contributor when the user only needs to read.
How to use these pages
Each topic page has the same shape, so you can skim for what you need.
- What it is: the idea in plain words.
- How it works: the mechanism, with tables and code examples.
- What to remember for the exam: the facts to memorise and how questions are phrased.
- Common mistakes: the classic traps.
- Check yourself: three questions to test your understanding.
Ready for more practice?
The full Microsoft DP-600 question bank has 648 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Microsoft. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.