Data Engineering Associate with Databricks Questions and Answers 100% Pass

Data Engineering Associate with Databricks Questions and Answers 100% Pass What is done with the control plane? web application notebooks jobs cluster management What is done with the data plane? spinning up clusters data processing accessing data sources SQL: Create table with specific columns CREATE TABLE students (id INT, name STRING) SQL: Insert data INSERT INTO students VALUES (1, "Omar") Does ACID guarantee inserting many records in a single transaction? Yes SQL: Update record UPDATE students SET value = value + 1 WHERE name LIKE "T%" // starts with T SQL: Delete record DELETE FROM students WHERE value 6 // Boolean is lowercase // equals is single = What is upsert? Allows updates, inserts and other manipulations in a single command SQL: Merge for CDC 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? Hive SQL: See details about Delta table including number of files DESCRIBE DETAIL students What does OPTIMIZE do? Replace existing data files by combining files and rewriting results SQL: OPTIMIZE OPTIMIZE students ZORDER BY id What are the configs for vacuuming? SET tionDurationCed = false; SET ed = true; What does ZORDER do? speeds up data retrieval when filling on provided fields by colocating data SQL: View history DESCRIBE