Exam DP-600 topic 1 question 37 discussion

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

Use the Load to Tables feature.

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

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

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.

A is correct

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.

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

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

A is the correct answer.

Correct

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

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

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.