Demo Databricks Databricks-Certified-Data-Engineer-Associate Exam Questions

Demo practice questions for guest users.

Section: Practice Mode 6 Questions

Demo Practice

Back To Exam

Question 1

Which of the following describes the storage organization of a Delta table?

A

Delta tables are stored in a single file that contains data, history, metadata, and other attributes.

B

Delta tables store their data in a single file and all metadata in a collection of files in a separate location.

C

Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.

D

Delta tables are stored in a collection of files that contain only the data stored within the table.

E

Delta tables are stored in a single file that contains only the data stored within the table.

Correct Answer: C

Explanation:

Delta Lake is the optimized storage layer that provides the foundation for storing data and tables in the Databricks lakehouse. Delta Lake is open source software that extends Parquet data files with a file-based transaction log for ACID transactions and scalable metadata handling1. Delta Lake stores its data and metadata in a collection of files in a directory on a cloud storage system, such as AWS S3 or Azure Data Lake Storage2. Each Delta table has a transaction log that records the history of operations performed on the table, such as insert, update, delete, merge, etc. The transaction log also stores the schema and partitioning information of the table2. The transaction log enables Delta Lake to provide ACID guarantees, time travel, schema enforcement, and other features1. Reference: What is Delta Lake? | Databricks on AWS Quickstart — Delta Lake Documentation

‹
1
2

Demo Practice Mode

You are viewing only the questions marked as Demo.