Implement and manage an analytics solution
30–35% - Configure Fabric workspace settings for Spark, OneLake, domains, and Apache Airflow.
- Implement lifecycle management with version control, database projects, and deployment pipelines.
- Configure security, sensitivity labels, audit logs, and orchestration with pipelines and notebooks.
Practice Implement & Manage Questions →
Ingest and transform data
30–35% - Design full, incremental, dimensional, and streaming load patterns.
- Ingest and transform batch data with pipelines, PySpark, SQL, KQL, mirroring, and shortcuts.
- Process streaming data with Eventstreams, Spark structured streaming, and windowing.
Practice Ingest & Transform Questions →
Monitor and optimize an analytics solution
30–35% - Monitor ingestion, transformation, semantic model refresh, and alerts.
- Resolve pipeline, Dataflow Gen2, notebook, Eventhouse, Eventstream, and shortcut errors.
- Optimise lakehouse tables, pipelines, warehouses, Spark, Eventstreams, and queries.
Practice Monitor & Optimize Questions →