Using Spark SQL — Databricks Certified Associate Developer for Apache Spark

The official DATABRICKS documentation our Using Spark SQL practice questions are cited to. Review the primary sources, then practise.

Official references for this objective

Databricks — Buliding ETL Pipelines with SQL | Databricks

the declarative building blocks — Streaming Tables, Materialized Views, and AUTO CDC — that replace complex procedural ingestion and transformation logic
Databricks — Advanced SQL Patterns for Production Analytics | Databricks

MATCH_RECOGNIZE is landing on Databricks SQL — and it changes how analysts express row patterns.
Databricks — Migrating from SQL Server and Synapse to Azure Databricks | Databricks

begin with Lakehouse Federation for read‑through access to SQL Server and Synapse, add CDC‑based replication
Databricks — Building ETL Pipelines with SQL | Databricks

Genie, an innovative Databricks feature that simplifies data exploration through natural language queries
Databricks — Databricks SQL Integration With Excel and Google Sheets | Databricks

how teams get started with minimal setup. Ideal for analytics teams looking to meet users where they work without duplicating data or workflows
Databricks — How Nubank Migrated to Databricks SQL Reducing Costs by 40% and Doubling Queries | Databricks

Leverage of UC for centralized data governance in highly regulated FSI industry