Data Engineering Associate with Databricks
What is done with the control plane? - Answer- web application notebooks jobs cluster management What is done with the data plane? - Answer- spinning up clusters data processing accessing data sources SQL: Create table with specific columns - Answer- CREATE TABLE students (id INT, name STRING) SQL: Insert data - Answer- INSERT INTO students VALUES (1, "Omar") Does ACID guarantee inserting many records in a single transaction? - Answer- Yes SQL: Update record - Answer- UPDATE students SET value = value + 1 WHERE name LIKE "T%" // starts with T SQL: Delete record - Answer- DELETE FROM students WHERE value 6 // Boolean is lowercase // equals is single = What is upsert? - Answer- Allows updates, inserts and other manipulations in a single command SQL: Merge for CDC - Answer- 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? - Answer- Hive SQL: See details about Delta table including number of files - Answer- DESCRIBE D
Información del documento
- Subido en
- 6 de septiembre de 2023
- Número de páginas
- 9
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
