Databricks Delta Lake Management Quiz

Submit

2. Which operations can trigger a full rewrite of Delta table files? (Select all that apply)

ALTER TABLE SET TBLPROPERTIES

Column name changes via ALTER TABLE RENAME COLUMN

Data type changes via ALTER TABLE MODIFY COLUMN

Adding new columns with ALTER TABLE ADD COLUMN

Submit

3. True or False: Partitioning a Delta table changes the underlying Parquet file structure but not the logical table schema.

True

False

Submit

5. Which Spark SQL syntax is used to restore a Delta table to a previous version?

RESTORE TABLE table_name TO VERSION version_id

ALTER TABLE table_name RESTORE VERSION version_id

SELECT * FROM table_name@v=version_id

REVERT TABLE table_name AT VERSION version_id

6. Match each Delta Lake feature with its primary use case:

Time Travel

Z-order

MERGE

VACUUM

Submit

7. The OPTIMIZE command consolidates small files into larger ones. What is this process called?

Compaction

Clustering

Partitioning

Indexing

8. True or False: Data files in a Delta table can be directly modified by external tools without corruption.

True

False

9. Which of the following statements about Delta Lake merge operations are true? (Select all that apply)

MERGE supports INSERT, UPDATE, and DELETE clauses

MERGE operations are atomic at the table level

MERGE requires the target table to be partitioned

MERGE can handle schema mismatches gracefully

Submit

10. What is the minimum Databricks Runtime version required for Delta Lake support?

Databricks Runtime 4.1 or higher

Databricks Runtime 5.0 or higher

Databricks Runtime 6.0 or higher

Delta Lake requires a separate installation

11. What are the four ACID properties that Delta Lake guarantees?

Atomicity, Consistency, Isolation, Durability

Availability, Compatibility, Integration, Distribution

Abstraction, Compression, Indexing, Deduplication

Aggregation, Caching, Integration, Deployment

12. Which parameter controls the retention period for Delta table history?

Delta.logRetentionDays

Delta.historyDuration

Delta.versionTimeout

Delta.archiveWindow

13. What does the DESCRIBE HISTORY command show for a Delta table?

Physical file locations and storage paths

User access logs and authentication records

Version history with timestamps and operation types

Column data types and nullable constraints

14. True or False: Delta Lake transactions are serializable, meaning concurrent writes cannot cause data inconsistency.

True

False

Submit

16. Which of the following are valid Delta Lake optimization techniques? (Select all that apply)

OPTIMIZE command with Z-order

VACUUM to remove old files

Partitioning on frequently filtered columns

Converting parquet files directly to Delta

Submit

17. What is the primary benefit of Delta Lake's Z-order clustering?

Reduces storage size by 50%

Improves query performance by co-locating related data

Automatically deletes duplicate rows

Encrypts sensitive columns

Submit

19. Which command is used to enable schema enforcement on a Delta table?

ALTER TABLE SET SCHEMA ENFORCEMENT

SET DELTA.SCHEMA.VALIDATION = true

ENFORCE SCHEMA ON table_name

Delta tables enforce schema by default

Databricks Data Engineer Delta Lake Management Quiz

1. Delta Lake implements ACID properties through a write-ahead ____ stored in the transaction log.

2.

What first name or nickname would you like us to use?

2. Which operations can trigger a full rewrite of Delta table files? (Select all that apply)

3. True or False: Partitioning a Delta table changes the underlying Parquet file structure but not the logical table schema.

4. Delta Lake's ______ property ensures that only valid data conforming to the schema is written to the table.

5. Which Spark SQL syntax is used to restore a Delta table to a previous version?

6. Match each Delta Lake feature with its primary use case:

7. The OPTIMIZE command consolidates small files into larger ones. What is this process called?

8. True or False: Data files in a Delta table can be directly modified by external tools without corruption.

9. Which of the following statements about Delta Lake merge operations are true? (Select all that apply)

10. What is the minimum Databricks Runtime version required for Delta Lake support?

11. What are the four ACID properties that Delta Lake guarantees?

12. Which parameter controls the retention period for Delta table history?

13. What does the DESCRIBE HISTORY command show for a Delta table?

14. True or False: Delta Lake transactions are serializable, meaning concurrent writes cannot cause data inconsistency.

15. The VACUUM command in Delta Lake removes files older than ______ days by default.

16. Which of the following are valid Delta Lake optimization techniques? (Select all that apply)

17. What is the primary benefit of Delta Lake's Z-order clustering?

18. Delta Lake's time travel feature allows you to query a table at a specific ____.

19. Which command is used to enable schema enforcement on a Delta table?