Scenario Inside a notebook you wrap two databricks video
data-analyst video for scenario Inside a notebook you wrap two statements in one transaction: BEGIN ; INSERT INTO finance . fact_revenue Δ SELECT * FROM staging
Answer
Full Certification Question
Scenario Inside a notebook you wrap two statements in one transaction: BEGIN ; INSERT INTO finance . fact_revenue Δ SELECT * FROM staging . view1 ; DELETE FROM finance . dim_regions Δ WHERE region_code = 'ZZ' ; COMMIT ; During execution, the DELETE fails on a foreign-key constraint. You need every inserted row automatically rolled back without manual cleanup.