Answer-first summary for fast verification
Answer: Auto Loader provides a SQL warehouse which is a compute resource that lets you run SQL commands on data objects within Databricks SQL.
Auto Loader is designed to efficiently process new data files as they arrive in cloud storage, detect schema drifts, reduce cloud costs through file notification mode, and resume operations from checkpoint locations for exactly-once guarantees. However, providing a SQL warehouse is not a feature of Auto Loader. This functionality is separate and pertains to Databricks SQL's compute resources. For more details, refer to the [Auto Loader documentation](https://docs.databricks.com/spark/latest/structured-streaming/auto-loader.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following is not a feature of Auto Loader in Databricks?
A
Auto Loader can detect schema drifts, notify you when schema changes happen, and rescue data that would have been otherwise ignored or lost.
B
Auto Loader provides a SQL warehouse which is a compute resource that lets you run SQL commands on data objects within Databricks SQL.
C
Auto Loader incrementally and efficiently processes new data files as they arrive in cloud storage. It can be used to process billions of files to migrate or backfill a table.
D
Auto Loader's file notification mode can help reduce your cloud costs further by avoiding directory listing altogether. It can automatically set up file notification services on storage to make file discovery much cheaper.
E
Auto Loader can resume from where it left off by information stored in the checkpoint location and continue to provide exactly-once guarantees when writing data into Delta Lake in case of any failures.