Exam DP-600 Topic 2 Question 103 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 103
Topic #: 2
You have an Azure Data Lake Storage Gen2 account named storage! 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.

Suggested Answer:


Explanation:

Step 1 - Read the Parquet file into a DataFrame
df = spark.read.parquet( " abfss://[email protected]/files/sales.parquet " ) This correctly loads the Parquet data into Spark.
Step 2 - Write into the Lakehouse as a managed table
If we want the result to be registered as a Lakehouse table and automatically appear in Lakehouse Explorer, we must:
Write the data in delta format (because Fabric Lakehouse tables are Delta tables ).
Save the table under the tables folder, not files .
So the correct code is:
df.write.mode( " overwrite " ). format ( " delta " ).saveAsTable( " tables/sales " ) Format: delta SaveAsTable Path: tables/sales References:
Lakehouse tables in Microsoft Fabric
Save DataFrame as Delta Table in Spark
# Answer Selection:
First dropdown # delta
Second dropdown # tables/sales

by Mabel at Sep 18, 2026, 01:01 PM

Limited Time Offer

15%

Off

Get Premium DP-600 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10