| Developing Code with Python and SQL | 22% | PySpark and SQL, window functions, joins, and UDFs. The single largest section: the exam expects you to read and reason about real code, not just recognize syntax. |
| Cost and Performance Optimization | 13% | Liquid clustering, deletion vectors, data skipping, compute sizing including serverless, and tuning jobs to be fast without wasting spend. This is where the Professional goes well beyond the Associate. |
| Data Transformation, Cleansing, and Quality | 10% | Building reliable transformations, enforcing data quality expectations, and the Medallion architecture from bronze to gold. |
| Monitoring and Alerting | 10% | System tables, the Spark UI, the Query Profiler, and setting up alerts so pipeline failures and drift surface before users notice. |
| Ensuring Data Security and Compliance | 10% | Row filters and column masks, PII masking and anonymization, and securing data across a Unity Catalog governed workspace. |
| Debugging and Deploying | 10% | Unit and integration testing, CI/CD with Declarative Automation Bundles and Git folders, and the Databricks CLI and REST API. |
| Data Ingestion and Acquisition | 7% | Auto Loader, Lakeflow declarative pipelines and jobs, and streaming and batch ingestion patterns. |
| Data Governance | 7% | Unity Catalog structure, lineage, and managing access to catalogs, schemas, and tables at scale. |
| Data Modeling | 6% | Modeling for the Lakehouse, change data feed and AUTO CDC, and designing tables that stay maintainable. |
| Data Sharing and Federation | 5% | Delta Sharing and querying federated sources, sharing data securely without copying it. |