Please refer below topics that may help you in exam-

• Describe Databricks SQL and its capabilities, including:
  • Databricks SQL (users, benefits, queries, dashboards, compute)
  • Integrations (Partner Connect, data ingestion, other BI tools)
  • Lakehouse (medallion architecture, streaming data)
• Manage data with Databricks tools and best practices, including:
  • Delta Lake (basics, benefits)
  • Storage and Management (tables, databases, views, Data Explorer)
  • Security (table ownership, PII data)
• Use Structured Query Language (SQL) to complete tasks in the Lakehouse, including:
  • Basic SQL (basic query structure, combining data, aggregations)
  • Complex Data (nested data objects, roll-ups, windows, cubes)
  • SQL in the Lakehouse (ANSI SQL, working with silver-level data, query history, higher-order functions, user-defined functions)
• Create production-grade data visualizations and dashboards, including:
  • Visualization (Databricks SQL capabilities, types of visualizations, storytelling with data)
  • Dashboarding (Databricks SQL capabilities, parameterized dashboards and queries, sharing)
  • Production (refresh schedules, query alerts)
• Develop analytics applications to solve common data analytics problems, including:
  • Descriptive Statistics (discrete statistics, summary statistics)
  • Common Applications (data enhancement, data blending, last-mile ETL)