Data Engineering Associate with Databricks (All questions correctly solved)

What is done with the control plane? correct answers web application notebooks jobs cluster management What is done with the data plane? correct answers spinning up clusters data processing accessing data sources SQL: Create table with specific columns correct answers CREATE TABLE students (id INT, name STRING) SQL: Insert data correct answers INSERT INTO students VALUES (1, "Omar") Does ACID guarantee inserting many records in a single transaction? correct answers Yes SQL: Update record correct answers UPDATE students SET value = value + 1 WHERE name LIKE "T%" // starts with T SQL: Delete record correct answers DELETE FROM students WHERE value 6 // Boolean is lowercase // equals is single = What is upsert? correct answers Allows updates, inserts and other manipulations in a single command SQL: Merge for CDC correct answers MERGE INTO students b USING updates u ON = WHEN MATCHED AND = "update" THEN UPDATE SET * THEN INSERT * WHEN NOT MATCHED AND THEN DELETE Which metastore does databricks use by default? correct answers Hive