DATABRICKS LAKEHOUSE BUNDLED EXAMS
STUDY GUIDE 2026 TESTED QUESTIONS AND
PRACTICE SOLUTION GRADED A+
◉ Which metastore does databricks use by default?
Answer: Hive
◉ SQL: See details about Delta table including number of files
Answer: DESCRIBE DETAIL students
◉ What does OPTIMIZE do?
Answer: Replace existing data files by combining files and rewriting
results
◉ SQL: OPTIMIZE
Answer: OPTIMIZE students
ZORDER BY id
◉ What are the configs for vacuuming?
Answer: SET spark.databricks.delta.retentionDurationCheck.enabled
= false;
SET spark.databricks.delta.vacuum.logging.enabled = true;
,◉ What does ZORDER do?
Answer: speeds up data retrieval when filling on provided fields by
colocating data
◉ SQL: View history
Answer: DESCRIBE HISTORY students
◉ SQL: Time travel
Answer: SELECT *
FROM students
VERSION AS OF 3
◉ SQL: Restore table
Answer: RESTORE TABLE students
TO VERSION AS OF 8
◉ What is the default time to vacuum files?
Answer: 7 days
◉ SQL: Vacuum
Answer: VACUUM students RETAIN 0 HOURS
, ◉ What does DRY RUN do with VACUUM?
Answer: Displays all files that will be deleted
◉ What does the LOCATION tag do?
Answer: If you set it, you can define a location for the data to reside,
otherwise it saves in /user/hive/warehouse/
◉ SQL: How do you specify a command to run in a database
Answer: USE dbname;
CREATE OR REPLACE TABLE
◉ SQL: How do you describe the table?
Answer: DESCRIBE TABLE EXTENDED
DESCRIBE EXTENDED
◉ SQL: Create a view, temp view and global temp view
Answer: CREATE VIEW view AS SELECT * FROM table
CREATE TEMPORARY VIEW
CREATE GLOBAL TEMPORARY VIEW name AS SELECT * FROM table
STUDY GUIDE 2026 TESTED QUESTIONS AND
PRACTICE SOLUTION GRADED A+
◉ Which metastore does databricks use by default?
Answer: Hive
◉ SQL: See details about Delta table including number of files
Answer: DESCRIBE DETAIL students
◉ What does OPTIMIZE do?
Answer: Replace existing data files by combining files and rewriting
results
◉ SQL: OPTIMIZE
Answer: OPTIMIZE students
ZORDER BY id
◉ What are the configs for vacuuming?
Answer: SET spark.databricks.delta.retentionDurationCheck.enabled
= false;
SET spark.databricks.delta.vacuum.logging.enabled = true;
,◉ What does ZORDER do?
Answer: speeds up data retrieval when filling on provided fields by
colocating data
◉ SQL: View history
Answer: DESCRIBE HISTORY students
◉ SQL: Time travel
Answer: SELECT *
FROM students
VERSION AS OF 3
◉ SQL: Restore table
Answer: RESTORE TABLE students
TO VERSION AS OF 8
◉ What is the default time to vacuum files?
Answer: 7 days
◉ SQL: Vacuum
Answer: VACUUM students RETAIN 0 HOURS
, ◉ What does DRY RUN do with VACUUM?
Answer: Displays all files that will be deleted
◉ What does the LOCATION tag do?
Answer: If you set it, you can define a location for the data to reside,
otherwise it saves in /user/hive/warehouse/
◉ SQL: How do you specify a command to run in a database
Answer: USE dbname;
CREATE OR REPLACE TABLE
◉ SQL: How do you describe the table?
Answer: DESCRIBE TABLE EXTENDED
DESCRIBE EXTENDED
◉ SQL: Create a view, temp view and global temp view
Answer: CREATE VIEW view AS SELECT * FROM table
CREATE TEMPORARY VIEW
CREATE GLOBAL TEMPORARY VIEW name AS SELECT * FROM table
