Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

Which of the following approaches can be used to ingest data directly from cloud-based object storage?
E) Create 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.
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

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Marge
13 hours ago
I’m leaning towards D. FROM sounds familiar, but E feels more accurate.
upvoted 0 times
...
Maryln
6 days ago
C is definitely wrong. We can ingest data directly!
upvoted 0 times
...
Maybelle
11 days ago
I feel like A could be a contender too, but it’s not as clear as E.
upvoted 0 times
...
Alise
16 days ago
Agreed! E makes sense. It specifies the storage path correctly.
upvoted 0 times
...
Terrilyn
21 days ago
I think the answer is E. LOCATION is key for external tables.
upvoted 0 times
...
Joanna
26 days ago
Just to clarify, LOCATION is definitely the right keyword here.
upvoted 0 times
...
Shawnna
1 month ago
I disagree, I think option C makes sense in some cases.
upvoted 0 times
...
Holley
1 month ago
No way, I didn't know external tables worked like that!
upvoted 0 times
...
Derick
1 month ago
I thought you could use FROM too?
upvoted 0 times
...
Johnna
2 months ago
Option E is the correct way to specify the object storage path!
upvoted 0 times
...
Ethan
2 months ago
Wait, so we can actually create external tables like that? Sounds too easy!
upvoted 0 times
...
Lawrence
2 months ago
Totally agree, LOCATION is the way to go!
upvoted 0 times
...
Jillian
2 months ago
No way, I thought it was impossible to ingest directly!
upvoted 0 times
...
Elli
2 months ago
I thought you could use FROM too?
upvoted 0 times
...
Josefa
2 months ago
Option E is the correct way to specify the storage path!
upvoted 0 times
...
Stefania
3 months ago
I remember something about DBFS paths, but I can't recall if they apply here. Is it possible to use DBFS for external tables?
upvoted 0 times
...
Serina
3 months ago
I practiced a similar question where LOCATION was emphasized, so I’m leaning towards E as well.
upvoted 0 times
...
Cordell
3 months ago
I'm not entirely sure, but I feel like FROM is used in other contexts, maybe not for external tables.
upvoted 0 times
...
Melvin
4 months 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
...

Save Cancel