How to Convert CSV to Delta with V-Order in Fabric Lakehouse?

Get data Transform data

Answer Correct answer: A — Use the Load to Tables feature in Lakehouse explorer to convert Subfolder1 CSV files into Delta tables with V-Order optimization enabled.

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files. You need to convert the CSV files into the delta format that has V-Order optimization enabled. What should you do from Lakehouse explorer?

Use the Load to Tables feature. Correct Answer
Create a new shortcut in the Files section.
Create a new shortcut in the Tables section.
Use the Optimize feature.

fabric load to tables csv to delta v-order lakehouse explorer convert csv dp-600 fabric lakehouse

Community Votes

100%

100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

This question tests whether you know that Load to Tables ingests files as Delta with V-Order, while the common trap is choosing Optimize, which only maintains existing Delta tables.

In Microsoft Fabric, the Load to Tables feature from Lakehouse explorer converts CSV files in a subfolder into Delta tables with V-Order optimization enabled by default. This page confirms option A is the correct action for the DP-600 scenario.

Many learners pick Optimize (D) because it sounds like it applies V-Order, but it cannot convert CSV files into Delta tables.

Community Discussion (14 comments)

Sanji931 👍 11 Selected: A

With ''Load to tables'' : tables are always loaded using the Delta Lake table format with V-Order optimization enabled. https://learn.microsoft.com/en-us/fabric/data-engineering/load-to-tables#load-to-table-capabilities-overview

Rakesh16 👍 1 Selected: A

Use the Load to Tables feature.

cafb698 👍 1 Selected: A

A, since optimize alone won't convert the CSV to Delta Format

cafb698 👍 1 Selected: D

Optimize feature alone does not convert CSV files to Delta format. It is used for optimizing Delta tables after they have been created. To fully address the requirement of converting CSV files into Delta format with V-Order optimization, the correct approach involves: Loading CSV files into a Delta table: This is typically done using features that allow for the import and conversion of data into Delta format. Applying V-Order optimization: Once the data is in Delta format, you use the Optimize feature to apply V-Order. Hence, D

Training_ND 👍 1 Selected: D

The Optimize feature in a Lakehouse environment is specifically designed to optimize data, including converting it into more efficient formats like Delta and applying optimizations like V-Order. This feature is what you would use to convert CSV files into the Delta format and enable V-Order optimization, which reorganizes the data to improve query performance.

byyleoo 👍 2 Selected: A

A is correct

282b85d 👍 2 Selected: A

The "Load to Tables" feature in Lakehouse explorer allows you to import data from various file formats (such as CSV) into a table within the lakehouse. During this process, you can specify the file format for the table, and by choosing the delta format, you can enable optimizations like V-Order.

stilferx 👍 2 Selected: A

IMHO, "A" is right. Because: The Lakehouse in Microsoft Fabric provides a feature to efficiently load common file types to an optimized Delta table ready for analytics. The Load to Table feature allows users to load a single file or a folder of files to a table. https://learn.microsoft.com/en-us/fabric/data-engineering/load-to-tables

prabhjot 👍 2

I think Optimize ( Ans D) - https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order?tabs=sparksql

XiltroX 👍 4 Selected: A

A is the correct answer.

Momoanwar 👍 3 Selected: A

Correct

Nicofr 👍 2 Selected: A

"Load to Tables" functionality, the Optimize check mark is set by default.

fabric1 👍 3 Selected: A

Hi IshtarSQL, the "Optimize" feature is only applicable on already existing tables and cannot convert CSV files as far as I know. When loading a CSV file as table using the "Load to Tables" functionality, the Optimize check mark is set by default. Therefore, A should be correct. Cheers fabric1

IshtarSQL 👍 1 Selected: D

The "New Optimize" feature in the Lakehouse Explorer to convert CSV files into Delta format with V-Order optimization enabled. The "New Optimize" feature allows you to optimize your data in Delta Lake format, including enabling V-Order optimization. V-Order optimization improves query performance by organizing data according to the values of frequently queried columns.

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Expert Analysis

Why the Answer Is Correct

The Load to Tables feature in Fabric lakehouse explorer is designed to promote files from the Files section into managed Delta tables. When you select Subfolder1 and use Load to Tables, Fabric reads the CSV files and creates a Delta table with V-Order optimization enabled by default, satisfying both the format conversion and the optimization requirement. Community member Sanji931 pointed to Microsoft Learn stating that "tables are always loaded using the Delta Lake table format with V-Order optimization enabled". Another learner, fabric1, added that "the Optimize check mark is set by default" during this load. Therefore A is the direct, supported action.

Why the Other Options Are Wrong

Creating a shortcut in the Files section (B) or Tables section (C) only points to external data; it does not materialize or convert the CSVs into a new Delta table, and shortcuts do not apply V-Order transformation. The Optimize feature (D) operates only on existing Delta tables to compact small files and apply V-Order, but it cannot read CSV files or change their format. As prabhjot suggested, Optimize is about delta optimization, not file format conversion. Option D would leave the CSVs as CSVs, so it cannot meet the requirement. Thus B, C, and D fail.

Community Comment Notes

The community overwhelmingly selected A, with Sanji931, fabric1, stilferx, and Nicofr all confirming that Load to Tables produces Delta with V-Order enabled. fabric1 specifically noted that "the Optimize check mark is set by default" and that Optimize cannot convert CSV files. A few learners, such as prabhjot and Training_ND, voted for D, arguing that Optimize converts to Delta and applies V-Order, but they appear to confuse table maintenance with ingestion. The strongest evidence, including the linked Microsoft Learn page from Sanji931, supports A over D. Overall, the comment consensus aligns with the official feature behavior.

Official Reference

Exam Strategy

In Fabric lakehouse explorer, distinguish actions that convert files into tables (Load to Tables) from actions that maintain existing Delta tables (Optimize). For DP-600, if the file is CSV and the goal is Delta with V-Order, look for Load to Tables; Optimize cannot change the underlying file format.

Frequently Asked Questions

Why can't I use the Optimize feature to convert CSV files to Delta?

Optimize only applies to existing Delta tables to compact files and apply V-Order; it cannot read CSV files or change the table format.

Does Load to Tables automatically enable V-Order for new tables?

Yes. Tables created via Load to Tables use the Delta Lake format with V-Order optimization enabled by default.

Related Analysis

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide