| Executing queries using Databricks SQL and warehouses | 20% | Running and tuning queries in the SQL editor, choosing and sizing SQL warehouses, understanding serverless versus classic, and managing query history and caching. |
| Creating dashboards and visualizations | 16% | Building AI/BI dashboards, picking appropriate visualization types, adding filters and parameters, scheduling refreshes, and sharing dashboards with the right audience. |
| Analyzing queries | 15% | Reading query profiles and execution plans, spotting why a query is slow or expensive, and applying the right fix rather than just adding compute. |
| Developing, sharing, and maintaining AI/BI Genie spaces | 12% | Creating Genie spaces over a set of tables, writing sample questions and domain instructions, sharing access, and improving answer accuracy by reviewing real user questions. |
| Understanding Databricks Data Intelligence Platform | 11% | Lakehouse architecture, the medallion pattern, Unity Catalog, Delta Lake fundamentals, and how the analyst-facing surfaces fit with the wider platform. |
| Managing data | 8% | Working with catalogs, schemas, tables, and views, managed versus external tables, and basic table maintenance and lifecycle tasks. |
| Securing data | 8% | Unity Catalog permissions and grants, row and column level controls, sharing data safely, and the governance model behind who can see what. |
| Importing data | 5% | Getting data in from files and external sources, small-scale uploads, and the ingestion options an analyst is expected to know. |
| Data modeling with Databricks SQL | 5% | Practical modeling for analytics: star schemas, dimensional design, joins, and structuring tables so dashboards stay fast and understandable. |