wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Quiz on Delta Lake Features

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

Which layer in the Medallion architecture stores raw, unprocessed data?

a)

Gold

b)

Silver

c)

Bronze

d)

Delta Log

2.

Which command automatically prevents reloading already processed files?

a)

CTAS

b)

COPY INTO

c)

MERGE INTO

d)

INSERT INTO

3.

What is the main purpose of rescued columns?

a)

Improve query performance

b)

Store extra or malformed data

c)

Remove invalid data automatically

d)

Compress Delta files

4.

Which Delta Lake feature allows you to see older versions of a table?

a)

ACID Transactions

b)

Time Travel

c)

Schema Enforcement

d)

Delta Sharing

5.

Which layer provides curated and aggregated data for reporting?

a)

Bronze

b)

Silver

c)

Gold

d)

Unity Catalog

6.

Which feature enforces that new data matches the existing table schema?

a)

Schema Evolution

b)

Schema Enforcement

c)

Rescued Columns

d)

MERGE INTO

7.

Which feature allows Delta tables to adapt to new columns automatically?

a)

Schema Evolution

b)

Schema Enforcement

c)

Rescued Columns

d)

Time Travel

8.

Which managed feature of Databricks ingests data directly from SaaS apps like Salesforce?

a)

Standard Connectors

b)

Managed Connectors

c)

COPY INTO

d)

Delta Sharing

9.

What file format does Delta Lake use under the hood?

a)

JSON

b)

CSV

c)

Parquet

d)

ORC

10.

Which folder in a Delta table tracks all operations and versions?

a)

/bronze/

b)

/_delta_log/

c)

/parquet/

d)

/silver/

11.

What is the benefit of using Auto Loader?

a)

Manual file selection

b)

Continuous ingestion of new files

c)

Schema mismatch prevention

d)

File compression

12.

Which Delta operation is best for applying incremental updates?

a)

MERGE INTO

b)

CTAS

c)

COPY INTO

d)

DELETE

13.

Which layer is best suited for machine learning models?

a)

Bronze

b)

Silver

c)

Gold

d)

Unity Catalog

14.

Which Databricks feature allows secure data sharing with external partners?

a)

COPY INTO

b)

Delta Sharing

c)

Unity Catalog

d)

Auto Loader

15.

What is the purpose of ACID transactions in Delta Lake?

a)

Improve storage costs

b)

Ensure reliable concurrent writes

c)

Remove duplicates

d)

Compress files

16.

Which ingestion method would you choose for near real-time streaming data?

a)

Batch

b)

COPY INTO

c)

Auto Loader

d)

Streaming

17.

Ingestion pipelines that use COPY INTO are best for:

a)

One-time loads only

b)

Incremental file-based ingestion

c)

Schema migration

d)

Streaming IoT data

18.

Which command creates a new table from existing files in one step?

a)

MERGE INTO

b)

CTAS

c)

COPY INTO

d)

UPDATE

19.

Which Delta feature allows both INSERT, UPDATE, and DELETE operations?

a)

Rescued Columns

b)

ACID Transactions

c)

Time Travel

d)

Unity Catalog

20.

Which Medallion layer is most likely to store duplicate or malformed records?

a)

Bronze

b)

Silver

c)

Gold

d)

Unity Catalog