Databricks Exam Databricks Certified Data Analyst Associate Topic 3 Question 13 Discussion

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

Question #: 13
Topic #: 3

[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: A

Option A uses theSELECT DISTINCTstatement to remove duplicate rows from thetable_bronzeand create a new tabletable_silverwith the deduplicated data.This is the correct way to deduplicate data using Spark SQL12. Option B simply inserts all the rows fromtable_bronzeintotable_silver, without removing any duplicates. Option C is not a valid syntax for Spark SQL, as there is noMERGE DEDUPLICATEstatement. Option D appends all the rows fromtable_bronzeintotable_silver, without removing any duplicates. Option E overwrites the existing data intable_silverwith the data fromtable_bronze, without removing any duplicates.Reference:Delete Duplicate using SPARK SQL,Spark SQL - How to Remove Duplicate Rows

by Jettie at May 13, 2024, 02:38 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

Avery

1 months ago

I'm going with option E. 'Create an external table while specifying the object storage path to LOCATION.' You know, because LOCATION is where the party's at.

upvoted 0 times

...

Virgie

1 months ago

Wait, so I can't just use a teleportation device to beam the data straight from the cloud into my database? Darn, there goes my plan for world domination.

upvoted 0 times

...

Benedict

1 months ago

Haha, option C is a classic. 'It's not possible to directly ingest data from cloud-based object storage'? Yeah, right. Clearly the person who wrote that option has never heard of external tables.

upvoted 0 times

Rashad

17 days ago

A) Create an external table while specifying the DBFS storage path to FROM

upvoted 0 times

...

2 months ago

I agree with Page. Option D is the way to go. Time to show those cloud skills!

upvoted 0 times

Rosendo

24 days ago

Let's get those cloud skills in action and start ingesting data using the correct approach.

upvoted 0 times

...

Dalene

28 days ago

I agree, creating an external table while specifying the object storage path to FROM is the way to go.

upvoted 0 times

...

Leigha

2 months ago

I think option D is the best choice for ingesting data from cloud-based object storage.

upvoted 0 times

...

3 months ago

I think the answer is E) Create an external table while specifying the object storage path to LOCATION.

upvoted 0 times

...