Answer-first summary for fast verification
Answer: Create an external table while specifying the object storage path to LOCATION
The correct answer is E because when creating external tables in Databricks to ingest data directly from cloud object storage (such as AWS S3, Azure Blob Storage, or Google Cloud Storage), the LOCATION clause is used to specify the object storage path. This is confirmed by the community discussion where E has 100% consensus and 2 upvotes, with detailed syntax examples showing 'LOCATION' followed by the cloud storage path (e.g., 's3://<bucket_path>/<table_directory>'). Option A and B are incorrect as they mention DBFS storage paths, which are not for direct cloud object storage ingestion. Option C is false because direct ingestion from cloud storage is possible. Option D is incorrect as it uses 'FROM' instead of 'LOCATION', which is not the standard syntax for external table creation in Databricks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following methods can be used to load data directly from cloud object storage?
A
Create an external table while specifying the DBFS storage path to FROM
B
Create an external table while specifying the DBFS storage path to PATH
C
It is not possible to directly ingest data from cloud-based object storage
D
Create an external table while specifying the object storage path to FROM
E
Create an external table while specifying the object storage path to LOCATION
No comments yet.