ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 72 discussion

Actual exam question from Microsoft's DP-600
Question #: 72
Topic #: 1
[All DP-600 Questions]

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 Hide Answer
Suggested Answer:
by taphyoe at April 5, 2024, 4:38 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
taphyoe
Highly Voted 1 year ago
delta sales
upvoted 45 times
DarioReymago
10 months, 2 weeks 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 ago
why? please provide some explanation
upvoted 2 times
harshalt10
1 year 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 ago
delta tables/sales
upvoted 8 times
vernillen
11 months 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 7 times
...
lelima
11 months ago
I think this is wrong since it's usingsaveAsTable
upvoted 1 times
...
...
Pkah
Most Recent 9 months ago
df.write.mode("overwrite").format("delta").partitionBy("Year","Quarter").save("Tables/" + table_name)
upvoted 2 times
...
woliveiras
11 months ago
delta and sales (100%)
upvoted 7 times
...
282b85d
11 months, 1 week 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
11 months, 1 week 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
11 months, 2 weeks ago
Delta, sales: the code already using "SaveasTable" so no need to reference the table again.
upvoted 1 times
...
2dc6125
11 months, 3 weeks 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 ago
I gave it a try, it is 'sales' not 'File/sales'
upvoted 1 times
...
4fd861f
1 year ago
Saveastable so it is directly the name of the tables don't need to add tables/name
upvoted 3 times
...
Nefirs
1 year 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 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 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 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago