Databricks Certified Associate Developer for Apache Spark

0/7 checked

Q_01 domain/d2 · medium single discuss →

A data engineering team is replacing complex procedural ingestion and transformation logic with concise, incremental pipeline definitions written entirely in SQL on Databricks. Which set of declarative building blocks are they most likely adopting?

A Streaming Tables, Materialized Views, and AUTO CDC
B Temporary Views, Common Table Expressions, and MERGE statements
C External Tables, Window Functions, and CACHE TABLE
D Global Temp Views, Broadcast Joins, and REFRESH TABLE

Q_02 domain/d2 · medium single discuss →

An analytics team wants to express complex row-pattern matching queries against sequential data on Databricks SQL, replacing dozens of lines of code with a few readable lines. Which SQL feature is highlighted as enabling this?