Chapter 1 of 3 · Microsoft DP-700
Implement and Manage an Analytics Solution
Fabric workspace settings, Git and deployment pipelines, security and governance, and orchestrating pipelines and notebooks.
- 5topics
- 25 minfast track
- 2diagrams and exhibits
- 30–35%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Configuring Fabric Workspace SettingsDP-700 workspace settings: Spark pools, environments and high concurrency, domain assignment, OneLake shortcut caching and Apache…5 min
- 2Lifecycle Management with Git, Database Projects and Deployment PipelinesDP-700 lifecycle management: Git integration with Azure DevOps or GitHub, SQL database projects for warehouses, and deployment…Diagram5 min
- 3Workspace and Item Access, Labels, Endorsement and Audit LogsDP-700 security and governance: workspace roles, item permissions, sensitivity labels, endorsement (promoted, certified, master…5 min
- 4Row, Column, Object and Folder Security, Masking and OneLake SecurityDP-700 granular security: row-level, column-level and object-level security in T-SQL, dynamic data masking, folder access and…5 min
- 5Orchestrating Processes with Pipelines, Notebooks and Dataflow Gen2DP-700 orchestration: choose Dataflow Gen2, a pipeline or a notebook, set schedules and event triggers, and use parameters and…Diagram5 min
About this chapter
What this chapter covers
Implement and Manage an Analytics Solution is 30 to 35% of the Microsoft DP-700 exam. It covers configuring workspace settings for Spark, domains, OneLake and Apache Airflow, lifecycle management with Git integration, database projects and deployment pipelines, security and governance from workspace roles down to rows, columns and folders, and orchestrating work with Dataflow Gen2, pipelines and notebooks.
Questions are mostly scenarios: you pick the setting, role, permission or orchestration item that meets a requirement with the least effort or the least privilege. Expect short T-SQL security statements and pipeline dynamic expressions to read.
How the topics fit together
You set up the workspace first, put its items under source control and promote them through stages, secure who can see what, and then schedule the processes that load the data.
When two answers both work, DP-700 usually wants the least privilege option or the one with the least custom code.
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-700 question bank has 645 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.