Data Engineering Associate with Databricks Exam Questions And Answers.docx

Data Engineering Associate with Databricks
Exam Questions And Answers
What is done with the control plane? -
correct answer ✅web application
notebooks
jobs
cluster management


What is done with the data plane? -
correct answer ✅spinning up clusters
data processing
accessing data sources


SQL: Create table with specific columns -
correct answer ✅CREATE TABLE students (id INT, name STRING)


SQL: Insert data -
correct answer ✅INSERT INTO students
VALUES (1, "Omar")


Does ACID guarantee inserting many records in a single
transaction? -
correct answer ✅Yes

,Data Engineering Associate with Databricks
Exam Questions And Answers

SQL: Update record -
correct answer ✅UPDATE students
SET value = value + 1
WHERE name LIKE "T%" // starts with T


SQL: Delete record -
correct answer ✅DELETE FROM students
WHERE value > 6


// Boolean is lowercase
// equals is single =


What is upsert? -
correct answer ✅Allows updates, inserts and other manipulations
in a single command


SQL: Merge for CDC -
correct answer ✅MERGE INTO students b
USING updates u

, Data Engineering Associate with Databricks
Exam Questions And Answers
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? -
correct answer ✅Hive


SQL: See details about Delta table including number of files -
correct answer ✅DESCRIBE DETAIL students


What does OPTIMIZE do? -
correct answer ✅Replace existing data files by combining files and
rewriting results


SQL: OPTIMIZE -
correct answer ✅OPTIMIZE students