Databricks Certified Data Analyst Associate Exam - Topic 5 Question 52 Discussion

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam

Question #: 52
Topic #: 5

[All Databricks Certified Data Analyst Associate Questions]

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

ACreate an external table while specifying the DBFS storage path to FROM

BCreate an external table while specifying the DBFS storage path to PATH

CIt is not possible to directly ingest data from cloud-based object storage

DCreate an external table while specifying the object storage path to FROM

ECreate an external table while specifying the object storage path to LOCATION
External tables are tables that are defined in the Databricks metastore using the information stored in a cloud object storage location. External tables do not manage the data, but provide a schema and a table name to query the data. To create an external table, you can use the CREATE EXTERNAL TABLE statement and specify the object storage path to the LOCATION clause. For example, to create an external table named ext_table on a Parquet file stored in S3, you can use the following statement:
SQL
CREATE EXTERNAL TABLE ext_table (
col1 INT,
col2 STRING
)
STORED AS PARQUET
LOCATION 's3://bucket/path/file.parquet'
AI-generated code. Review and use carefully.More info on FAQ.

Show Suggested Answer

Suggested Answer: E

by Nana at May 17, 2026, 05:03 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Melvin

16 days ago

I think the answer might be E, since I remember that LOCATION is the correct keyword for specifying the path in external tables.

upvoted 0 times

...