DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #15
A data engineer is designing a data pipeline. The source system generates files in a shared directory that is also used by other processes. As a result, the files should be kept as is and will…
The correct answer is E. Auto Loader. Auto Loader is the appropriate tool for incrementally identifying and ingesting only new files from a continuously accumulating shared directory.
Question
Options
- AUnity Catalog
- BDelta Lake
- CDatabricks SQL
- DData Explorer
- EAuto Loader
How the community answered
(50 responses)- A14% (7)
- B10% (5)
- C2% (1)
- D4% (2)
- E70% (35)
Why each option
Auto Loader is the appropriate tool for incrementally identifying and ingesting only new files from a continuously accumulating shared directory.
Unity Catalog provides a unified governance layer for data and AI assets, not a mechanism for incremental file ingestion from directories.
Delta Lake is an open-source storage layer that brings ACID transactions to data lakes, but it does not directly handle the incremental identification of new files in a directory.
Databricks SQL is an environment for running SQL queries and dashboards, not a tool for managing file ingestion pipelines.
Data Explorer is a UI tool within Databricks for browsing and managing data objects, not for building data ingestion pipelines.
Auto Loader is specifically designed to efficiently ingest new data files as they arrive in cloud storage, providing exactly-once processing guarantees and automatically tracking processed files without manual state management, which perfectly fits the described scenario.
Concept tested: Auto Loader for incremental ingestion
Source: https://docs.databricks.com/en/ingestion/auto-loader/index.html
Topics
Community Discussion
No community discussion yet for this question.