NEW
Font size
WorksheetsQuiz on Delta Lake Features
Total questions: 20
Worksheet time: 10mins
Which layer in the Medallion architecture stores raw, unprocessed data?
Gold
Silver
Bronze
Delta Log
Which command automatically prevents reloading already processed files?
CTAS
COPY INTO
MERGE INTO
INSERT INTO
What is the main purpose of rescued columns?
Improve query performance
Store extra or malformed data
Remove invalid data automatically
Compress Delta files
Which Delta Lake feature allows you to see older versions of a table?
ACID Transactions
Time Travel
Schema Enforcement
Delta Sharing
Which layer provides curated and aggregated data for reporting?
Bronze
Silver
Gold
Unity Catalog
Which feature enforces that new data matches the existing table schema?
Schema Evolution
Schema Enforcement
Rescued Columns
MERGE INTO
Which feature allows Delta tables to adapt to new columns automatically?
Schema Evolution
Schema Enforcement
Rescued Columns
Time Travel
Which managed feature of Databricks ingests data directly from SaaS apps like Salesforce?
Standard Connectors
Managed Connectors
COPY INTO
Delta Sharing
What file format does Delta Lake use under the hood?
JSON
CSV
Parquet
ORC
Which folder in a Delta table tracks all operations and versions?
/bronze/
/_delta_log/
/parquet/
/silver/
What is the benefit of using Auto Loader?
Manual file selection
Continuous ingestion of new files
Schema mismatch prevention
File compression
Which Delta operation is best for applying incremental updates?
MERGE INTO
CTAS
COPY INTO
DELETE
Which layer is best suited for machine learning models?
Bronze
Silver
Gold
Unity Catalog
Which Databricks feature allows secure data sharing with external partners?
COPY INTO
Delta Sharing
Unity Catalog
Auto Loader
What is the purpose of ACID transactions in Delta Lake?
Improve storage costs
Ensure reliable concurrent writes
Remove duplicates
Compress files
Which ingestion method would you choose for near real-time streaming data?
Batch
COPY INTO
Auto Loader
Streaming
Ingestion pipelines that use COPY INTO are best for:
One-time loads only
Incremental file-based ingestion
Schema migration
Streaming IoT data
Which command creates a new table from existing files in one step?
MERGE INTO
CTAS
COPY INTO
UPDATE
Which Delta feature allows both INSERT, UPDATE, and DELETE operations?
Rescued Columns
ACID Transactions
Time Travel
Unity Catalog
Which Medallion layer is most likely to store duplicate or malformed records?
Bronze
Silver
Gold
Unity Catalog
