Navigate Domains

Configure Workspace Settings

MS LearnUse Apache Spark in Microsoft FabricSpark pool/environment config, cluster settings, runtimes›MS DocsWorkspace admin settings – SparkConfigure pools, environments, runtime versions›MS DocsFabric Spark Capacity & Cluster PlanningNode sizing, autoscale, high-concurrency session guidance›YouTubeData Exposed – Spark ConfigurationSearch 'Spark configuration' on Data Exposed show›

MS LearnAdminister a Microsoft Fabric environmentDomain workspace settings, governance, capacity settings›MS DocsDomains in Microsoft FabricDomain creation, delegation, workspace assignment›MS LearnManage a Microsoft Fabric environment (LP)4-module path: admin, security, CI/CD, monitoring›

MS LearnSecure data access in Microsoft FabricOneLake RBAC, folder/table access roles›MS DocsOneLake security access control modelEngine access, RLS/CLS model, effective roles›MS DocsGet started with OneLake securityStep-by-step: create roles, assign users, scope tables/folders›

MS LearnIngest Data with Dataflows Gen2 in Microsoft FabricPower Query-based ingestion, workspace settings, scheduling›MS DocsDataflows Gen2 in FabricWorkspace settings for Dataflows Gen2›

Implement Lifecycle Management

MS LearnImplement CI/CD in Microsoft FabricGit integration, version control, deployment pipelines – 8 units›MS DocsGet started with Git integrationConnect workspace to Azure DevOps or GitHub›MS DocsCI/CD for pipelines in Fabric Data FactoryBranch strategy, PR workflow, selective branch mapping›UdemyDP-700 Prep: Fabric Data Engineer (Phillip Burton)Aligned to Jan 2026 + Apr 2026 syllabus updates›

MS DocsSQL database projects in Microsoft FabricCreate, deploy, and manage database projects with DacFx/SQLPackage›MS LearnImplement operational databases in Microsoft Fabric3-module path: SQL DB, GraphQL, pipelines›MS DocsDevelopment and deployment workflows – WarehouseDacFx CLI, Azure DevOps tasks, Git + deployment pipelines›

MS LearnImplement CI/CD in Microsoft FabricModule unit 4: deployment pipelines – dev/test/prod stages›MS DocsGet started with deployment pipelinesStage creation, workspace assignment, deploy with rules›MS DocsChoose the best Fabric CI/CD workflow optionfabric-cicd Python lib, Bulk Import API, pipeline comparison›

Configure Security & Governance

MS LearnSecure data access in Microsoft FabricWorkspace roles: Admin, Member, Contributor, Viewer + item sharing›MS DocsPermission model in Microsoft FabricWorkspace roles, item permissions, sharing model›MS DocsSecurity overview in Microsoft FabricWorkspace access, item sharing, RLS/CLS/OLS summary›

MS DocsShare Fabric itemsShare individual items without workspace role – restricted access›MS LearnSecure a Microsoft Fabric data warehouseItem-level security in warehouse context›MS DocsLakehouse sharing and permissionsShare lakehouse, manage lakehouse-level permissions›

MS DocsRow-level security in OneLakeSQL predicate syntax, enforcement engines, RLS+CLS combination›MS DocsColumn-level security in OneLakeCLS enforcement: Spark, SQL endpoint, semantic model behavior›MS DocsObject-level security in FabricHide tables/columns from specific roles in semantic models›MS DocsOneLake security access control modelEffective role evaluation: UNION/INTERSECTION semantics›MS LearnSecure data access in Microsoft FabricCovers all security layers in one module›

MS DocsDynamic data masking in Fabric Data WarehouseDDM syntax, mask functions, UNMASK permission›UdemyDP-700 Fabric Data Engineer Associate CourseDynamic data masking with hands-on Azure SQL/Fabric demos›

MS LearnGovern data in Microsoft Fabric with PurviewPurview integration, sensitivity labels, data classification›MS DocsSensitivity labels in Microsoft FabricApply, propagate, and inherit sensitivity labels across items›

MS DocsEndorsement in Microsoft FabricPromoted vs Certified endorsement, who can certify, UI walkthrough›MS LearnAdminister and govern Microsoft Fabric (LP)4-module path covering endorsement, Purview, security, admin›

MS DocsTrack user activities in Microsoft FabricAudit log events, PowerShell retrieval, Microsoft 365 audit log›MS DocsWorkspace monitoring in Microsoft FabricEnable workspace-level logging via Monitoring Eventhouse + KQL›MS LearnMonitor activities in Microsoft FabricMonitoring Hub, alerts, Activator – module in Manage Fabric LP›

MS DocsGet started with OneLake securityCreate OneLake security roles, grant table/folder access›MS DocsOneLake security access control modelEngine access, user access, authorized 3rd-party engine model›MS LearnSecure data access in Microsoft FabricPractical module covering OneLake access and workspace security›

Orchestrate Processes

MS DocsFabric ingestion decision guideCopy activity vs Dataflows Gen2 vs Spark/Notebook comparison›MS LearnOrchestrate processes and data movement with Microsoft FabricPipelines module – when to use pipelines vs other tools›MS LearnIngest Data with Dataflows Gen2 in Microsoft FabricDataflows use cases, M language, Power Query›

MS DocsSchedule and trigger pipelines in Microsoft FabricScheduled triggers, storage event triggers, custom triggers›MS LearnOrchestrate processes and data movement with Microsoft FabricSchedule activities, trigger types, monitoring runs›MS DocsDataflow Gen2 refresh schedulingSchedule dataflows, incremental refresh, gateway options›

MS DocsHow to use notebooks in Microsoft FabricParameterized notebooks, notebookutils.notebook.run(), chaining›MS DocsNotebook activity in pipelineNotebook activity – parameters, dynamic expressions›MS LearnImplement CI/CD in Microsoft FabricAutomate CI/CD using Fabric APIs – dynamic pipeline configuration›

Design and Implement Loading Patterns

MS LearnImplement a Lakehouse with Microsoft Fabric (LP)7-module path; full/incremental patterns via pipelines›MS DocsDimensional modeling in Fabric Warehouse: Load tablesIncremental load, high-water mark, SCD types 1/2/3›MS DocsIncremental refresh in Dataflows Gen2Incremental refresh with Power Query: date ranges, partitions›UdemyDP-700 Implementing Data Engineering Solutions (Phillip Burton)Covers loading patterns from zero – batch and incremental›

MS DocsDimensional modeling overview in Fabric WarehouseFact tables, dimension tables, surrogate keys, SCD types›MS DocsLoad tables: process dimension and fact tablesETL orchestration: staging → dimensions → facts → logging›MS LearnGet started with data warehouses in Microsoft FabricWarehouse concepts, T-SQL, loading, modeling basics›CourseraExam Prep DP-700 Specialization (Whizlabs / Coursera)Course 2 covers dimensional modeling + ingestion patterns›

MS DocsData streaming into a lakehouse with SparkSpark Structured Streaming to lakehouse: triggers, partitioning›MS LearnUse real-time eventstreams in Microsoft FabricEventstream ingestion, routing, real-time transformation›MS DocsEventstream overview in Microsoft FabricSources, destinations, routing, schema alignment for streaming›

Ingest and Transform Batch Data

MS DocsDecide between a Lakehouse and a Warehouse in FabricSide-by-side decision matrix: SQL, Spark, unstructured data›MS LearnGet started with lakehouses in Microsoft FabricLakehouse architecture, when to use vs warehouse›MS DocsWhen to use EventhouseEventhouse for telemetry, logs, IoT, time-series vs warehouse›

MS DocsData transformation options in Microsoft FabricCopy vs Dataflow vs Spark/Notebook – decision guide›MS LearnUse Apache Spark in Microsoft FabricPySpark transformation – notebooks, DataFrames, Delta tables›MS LearnWork with real-time data in a Microsoft Fabric eventhouseKQL transformation and querying in eventhouse›

MS DocsOneLake shortcutsShortcut types: ADLS, S3, GCS, Dataverse – create and manage›MS DocsAccelerated vs non-accelerated shortcuts in RTIAccelerated shortcut behavior in KQL databases›MS LearnImplement a Lakehouse with Microsoft FabricShortcuts covered in lakehouse learning path›

MS DocsWhat is Mirroring in Microsoft Fabric?Mirror Azure SQL, Snowflake, Cosmos DB, Databricks to OneLake›MS DocsAzure SQL Database mirroring in FabricSet up continuous replication from Azure SQL to OneLake›

MS LearnOrchestrate processes and data movement with Microsoft FabricCopy activity, linked services, data flows in pipelines›MS DocsPipeline runs and monitoringMonitoring Hub, workspace monitoring, KQL log queries›MS DocsPerformance guidelines for COPY INTOFile size, parallelism, CTAS/INSERT best practices›

MS LearnUse Apache Spark in Microsoft FabricPySpark DataFrames, transformations, Delta Lake writes›MS LearnWork with Delta Lake tables in Microsoft FabricDelta tables: merge, upsert, time travel, OPTIMIZE/VACUUM›MS LearnWork with real-time data in a Microsoft Fabric eventhouseKQL: summarize, join, parse, project, extend›MS DocsT-SQL in Microsoft Fabric WarehouseSQL editor, stored procedures, views, COPY INTO, CTAS›

MS DocsDimensional modeling: denormalization patternsStar schema, denormalization rationale, conformed dimensions›MS LearnOrganize a Fabric lakehouse using medallion architectureSilver → Gold layer transformations including denormalization›

MS LearnUse Apache Spark in Microsoft FabricPySpark: groupBy, agg, window functions›MS LearnWork with real-time data in a Microsoft Fabric eventhouseKQL: summarize, bin(), count(), avg(), percentile()›MS DocsKQL summarize operator referenceSummarize operator syntax and examples›

MS DocsData quality in Fabric streaming pipelinesLate-arriving data handling in streaming ingestion›MS DocsDimensional modeling: inferred members and late dataInferred dimension members, soft deletes, late-arriving facts›MS LearnUse Apache Spark in Microsoft FabricPySpark: dropDuplicates(), fillna(), handling nulls›

Ingest and Transform Streaming Data

MS DocsEventstream overview – when to useEventstream: managed, no-code. Spark SS: code-first, complex transforms›MS LearnGet started with Real-Time Intelligence in Microsoft FabricRTI overview: Eventstream, Eventhouse, KQL – when to use each›UdemyDP-700 Exam Prep – Fabric Data Engineer Associate 2026Streaming engine selection with hands-on RTI coverage›

MS DocsStorage options in Real-Time IntelligenceNative KQL storage vs mirrored OneLake vs OneLake shortcuts in RTI›MS DocsOne Logical Copy – OneLake availability in EventhouseEnable OneLake availability for KQL database tables›

MS DocsAccelerated shortcuts in Real-Time IntelligenceAccelerated shortcut: materialized cache for faster KQL queries›MS DocsOneLake shortcuts – types and accessShortcut types, access patterns, performance characteristics›

MS LearnUse real-time eventstreams in Microsoft FabricEventstream: sources, transformations, destinations – full module›MS DocsMonitor the status and performance of an eventstreamData insights tab, runtime logs, IncomingMessages/Bytes metrics›MS DocsAdd and manage eventstream sourcesEvent Hubs, IoT Hub, Kafka, Fabric events as sources›

MS DocsData streaming into a lakehouse with SparkStructured Streaming: triggers, partitionBy, Optimized Write›MS LearnUse Apache Spark in Microsoft FabricSpark module covering structured streaming and Delta writes›

MS LearnWork with real-time data in a Microsoft Fabric eventhouseKQL: ingest, query, transform streaming data in eventhouse›MS DocsKQL language referenceFull KQL reference: operators, functions, syntax›MS DocsT-SQL in Real-Time IntelligenceUsing T-SQL to query KQL databases›

MS DocsKQL windowing functions – bin() and summarizebin() for time-series windows; tumbling/sliding patterns›ApacheSpark Structured Streaming window operationsTumbling, sliding, session windows in PySpark›MS LearnWork with real-time data in a Microsoft Fabric eventhouseWindowing patterns in KQL covered in this module›

Monitor Fabric Items

MS LearnMonitor activities in Microsoft FabricMonitoring Hub: pipeline runs, dataflow status, ingestion tracking›MS DocsHow to monitor pipeline runs in Microsoft FabricWorkspace monitoring, ItemJobEventLogs KQL table, capacity metrics›MS DocsMonitor the status and performance of an eventstreamIncomingMessages, OutgoingBytes, runtime logs›

MS DocsMonitor Spark jobs and notebooks in Microsoft FabricSpark Advisor, inline monitoring, job concurrency, queue behavior›MS DocsDataflow Gen2 monitoring and refresh historyRefresh history, status, duration, error details›MS LearnMonitor activities in Microsoft FabricAll item types: pipeline, dataflow, notebook, semantic model refresh›

MS DocsQuery insights in Fabric WarehouseQuery insights view for semantic model and warehouse activity›MS DocsRefresh history in Power BI semantic modelsRefresh types, incremental refresh monitoring, failure diagnostics›MS LearnMonitor activities in Microsoft FabricSemantic model refresh monitoring in Monitoring Hub›

MS DocsMicrosoft Fabric Activator overviewSet rules on streaming data and trigger alerts/actions›MS DocsData Activator rules overviewAlert conditions, thresholds, action types (email, Teams, pipeline)›MS LearnMonitor activities in Microsoft FabricActivator alert configuration covered in monitoring module›

Identify and Resolve Errors

MS DocsTroubleshoot pipeline runs in Microsoft FabricCommon pipeline errors, activity failures, connection issues›MS DocsMonitor pipeline runsWorkspace monitoring KQL queries for error trends›MS LearnOrchestrate processes and data movement with Microsoft FabricPipeline error handling: conditional activities, retry logic›

MS DocsTroubleshoot Dataflows Gen2Common Dataflow failures: gateway, source errors, refresh failures›MS DocsDataflow Gen2 monitoringRefresh history, error details, step-level diagnostics›

MS DocsSpark Advisor in Microsoft FabricReal-time recommendations for notebook performance and errors›MS DocsDebug Apache Spark in Microsoft FabricBreakpoints, variable explorer, step-through debugging›MS LearnUse Apache Spark in Microsoft FabricSpark error patterns: OOM, shuffle, serialization exceptions›

MS DocsEventhouse monitoringEventhouse monitoring templates, KQL database health dashboard›MS DocsEventhouse and KQL Database consumptionEventhouse uptime, CU consumption, autoscale behavior›

MS DocsMonitor the status and performance of an eventstreamData insights, runtime logs – error detection per source/destination›MS LearnUse real-time eventstreams in Microsoft FabricEventstream troubleshooting patterns in this module›

MS DocsT-SQL troubleshooting in Fabric Data Warehousequeryinsights.exec_requests_history view for query diagnostics›MS DocsFabric Data Warehouse DMVssys.dm_exec_requests, sys.dm_tran_locks for T-SQL diagnostics›MS DocsPerformance guidelines in Fabric Data WarehouseNon-scalable operation warnings, FORCE DISTRIBUTED PLAN hint›

MS DocsOneLake shortcuts – troubleshoot accessShortcut listing vs access behavior, RLS on shortcut targets›MS DocsOneLake security access control modelHow shortcut security evaluation works – target permission model›

Optimize Performance

MS DocsDelta Lake table optimization and V-OrderV-Order, OPTIMIZE, ZORDER BY, auto-compaction, adaptive file size›MS DocsLakehouse table maintenanceOPTIMIZE and VACUUM from portal or notebook, scheduled maintenance›MS DocsCross-workload table maintenance and optimizationBronze/Silver/Gold layer recommendations per engine›MS DocsSQL analytics endpoint performance considerations2M rows/file, 400 MB target, maxRecordsPerFile tuning›MS LearnWork with Delta Lake tables in Microsoft FabricOPTIMIZE, VACUUM, time travel – hands-on Delta operations›

MS DocsPipeline performance and optimization in Microsoft FabricParallel copy, retry settings, data movement optimization›MS DocsLakehouse Maintenance activity in pipelineSchedule OPTIMIZE/VACUUM via pipeline Lakehouse Maintenance activity›MS LearnOrchestrate processes and data movement with Microsoft FabricPipeline optimization: parallel execution, ForEach concurrency›

MS DocsPerformance guidelines in Fabric Data WarehouseCOPY INTO tuning, CTAS/INSERT, query plan hints, statistics›MS DocsStatistics in Fabric Data WarehouseAuto-maintained histogram stats, CREATE/UPDATE STATISTICS›MS DocsEvaluate and optimize your Microsoft Fabric capacityCapacity metrics app, CU smoothing, per-experience optimization›CourseraExam Prep DP-700 Specialization – Course 3 (Monitor & Optimize)Course 3 maps directly to this domain›

MS DocsEventhouse and KQL Database consumptionAutoscale, CU billing, uptime monitoring for eventhouse›MS DocsMonitor eventstream performanceMonitor IncomingBytes/OutgoingBytes, detect bottlenecks›GitHubEventhouse monitoring templates (Fabric Toolbox GitHub)Real-time dashboard + Power BI template for eventhouse ops›

MS DocsFabric Spark Capacity and Cluster PlanningNode sizing, high-concurrency mode, NEE, autoscale guidance›MS DocsIntelligent cache in Microsoft FabricSSD caching, 50% default cache, auto-invalidation on change›MS DocsNative Execution Engine (NEE) overviewNEE for vectorized Spark execution – up to 6x performance boost›MS DocsData streaming into a lakehouse: optimize streaming performancerepartition, coalesce, Optimized Write, trigger intervals›MS LearnUse Apache Spark in Microsoft FabricSpark performance: executors, partitioning, caching strategies›

MS DocsPerformance guidelines in Fabric Data Warehouse – QueryFilter early, avoid SELECT *, distributed plan hints, locking›MS DocsQuery insights in Fabric Warehousequeryinsights.exec_requests_history – historical query analysis›MS DocsKQL query optimization best practicesFilter early, use materialize(), avoid repeated subexpressions›MS LearnWork with real-time data in a Microsoft Fabric eventhouseKQL optimization patterns covered in eventhouse module›

DP-700
Learning
Atlas

🎓 Official Instructor-Led Course

📚 Microsoft Learn Learning Paths (Free)

🔬 Microsoft Applied Skills (Free)

✅ Free Practice Assessment

💳 Third-Party Courses (Paid)

🌐 Community & Official Channels

For clarifications, reach out to
Nth Dimension Academy

Accelerate Your DP-700 Certification Journey

DP-700 LearningAtlas