Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 72 discussion

Actual exam question from Microsoft's DP-600

Question #: 72
Topic #: 1

HOTSPOT -

You have an Azure Data Lake Storage Gen2 account named storage1 that contains a Parquet file named sales.parquet.

You have a Fabric tenant that contains a workspace named Workspace1.

Using a notebook in Workspace1, you need to load the content of the file to the default lakehouse. The solution must ensure that the content will display automatically as a table named Sales in Lakehouse explorer.

How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by taphyoe at April 5, 2024, 4:38 p.m.

Comments

Submit Cancel

taphyoe

Highly Voted 1 year, 2 months ago

delta sales

upvoted 45 times

DarioReymago

1 year ago

thats ok delta is the format needed to creat managed table. using saveastable you don't need to specify the path

upvoted 6 times

...

neoverma

1 year, 2 months ago

why? please provide some explanation

upvoted 2 times

harshalt10

1 year, 2 months ago

I think it should only be sales because if saveastable is used, the argument should only be table name. Link: https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-notebook-load-data.

upvoted 15 times

...

dp600dataroots

Highly Voted 1 year, 2 months ago

delta tables/sales

upvoted 8 times

vernillen

1 year ago

Yep, you're wrong. This would have been right with .save but ALWAYS look carefully: saveAsTable can just be used with the table name

upvoted 8 times

...

lelima

1 year ago

I think this is wrong since it's usingsaveAsTable

upvoted 2 times

...

Pkah

Most Recent 11 months ago

df.write.mode("overwrite").format("delta").partitionBy("Year","Quarter").save("Tables/" + table_name)

upvoted 2 times

...

woliveiras

1 year, 1 month ago

delta and sales (100%)

upvoted 7 times

...

282b85d

1 year, 1 month ago

delta - sales : df = spark.read.parquet("abfss://[email protected]/files/sales.parquet") df.write.mode("overwrite").format("delta").saveAsTable("sales")

upvoted 2 times

...

trysec

1 year, 1 month ago

df.write.format("delta").mode("overwrite").saveAsTable("Sales"): Writes the DataFrame to the default Lakehouse using the Delta format, and saves it as a table named Sales.

upvoted 2 times

...

2dc6125

1 year, 1 month ago

Delta, sales: the code already using "SaveasTable" so no need to reference the table again.

upvoted 1 times

...

2dc6125

1 year, 1 month ago

DELTA, Sales. This is the correct answer since the destination was to loaded Delta the comand SaveAsTable you only need the table name no path. https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-notebook-load-data

upvoted 3 times

...

c8f5bdf

1 year, 2 months ago

I gave it a try, it is 'sales' not 'File/sales'

upvoted 1 times

...

4fd861f

1 year, 2 months ago

Saveastable so it is directly the name of the tables don't need to add tables/name

upvoted 3 times

...

Nefirs

1 year, 2 months ago

delta & sales. other options do not work in the context of the given code fragments (e.g. files/sales is for external tables but the path-parameter is missing here)

upvoted 4 times

...

earlqq

1 year, 2 months ago

"The solution must ensure that the content will display automatically as a table named Sales in Lakehouse explorer." - so only Delta in Tables section, otherwise table won`t be displayed automatically. Delta, Tables.

upvoted 4 times

earlqq

1 year, 2 months ago

i missed that it has saveastable, so "Tables/" is not needed, it`s included to save function. So only 1.Delta 2.sales.

upvoted 9 times

...

dp600

1 year, 2 months ago

A) delta B) Table/ sales --> The solution must ensure that the content will display automatically as a table named Sales in Lakehouse explorer

upvoted 2 times

...