DATABRICKS
DATA ENGINEERING ASSOCIATE WITH DATABRICKS EXAM WITH GUARANTEED
ACCURATE ANSWERS
What is done with the control plane? - ACCURATE ANSWERS✔✔
web application
notebooks
jobs
cluster management
What is done with the data plane? - ACCURATE ANSWERS✔✔
spinning up clusters
data processing
accessing data sources
,SQL: Create table with specific columns - ACCURATE ANSWERS✔✔
CREATE TABLE students (id INT, name STRING)
SQL: Insert data - ACCURATE ANSWERS✔✔ INSERT INTO students
VALUES (1, "Omar")
Does ACID guarantee inserting many records in a single transaction? -
ACCURATE ANSWERS✔✔ Yes
SQL: Update record - ACCURATE ANSWERS✔✔ UPDATE students
SET value = value + 1
WHERE name LIKE "T%" // starts with T
SQL: Delete record - ACCURATE ANSWERS✔✔ DELETE FROM
students
WHERE value > 6
// Boolean is lowercase
// equals is single =
What is upsert? - ACCURATE ANSWERS✔✔ Allows updates, inserts
and other manipulations in a single command
, SQL: Merge for CDC - ACCURATE ANSWERS✔✔ MERGE INTO
students b
USING updates u
ON b.id=u.id
WHEN MATCHED AND u.type = "update"
THEN UPDATE SET *
THEN INSERT *
WHEN NOT MATCHED AND
THEN DELETE
Which metastore does databricks use by default? - ACCURATE
ANSWERS✔✔ Hive
SQL: See details about Delta table including number of files -
ACCURATE ANSWERS✔✔ DESCRIBE DETAIL students
What does OPTIMIZE do? - ACCURATE ANSWERS✔✔ Replace
existing data files by combining files and rewriting results
SQL: OPTIMIZE - ACCURATE ANSWERS✔✔ OPTIMIZE students
ZORDER BY id