Databricks Certified Data Analyst Associate — Question 28

Which of the following approaches can be used to ingest data directly from cloud-based object storage?

Answer options

• 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

Correct answer: E

Explanation

The correct answer is E because specifying the object storage path to LOCATION allows for direct data ingestion from cloud-based object storage. Options A and B incorrectly refer to DBFS storage paths, which are not applicable for external tables in this context. Option C is incorrect as it states that direct ingestion is not possible, while option D uses 'FROM' instead of 'LOCATION', which is not the correct syntax for this operation.