
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with optimizing the performance of a large Delta table in Azure Databricks. During your analysis, you discover that the table files are not properly ordered, leading to significant performance degradation during query execution. The organization prioritizes cost-efficiency and minimal downtime. Considering these constraints, which of the following actions would you take to identify and resolve the issues with the v-order of the Delta table files? (Choose one option)
A
Execute the 'vacuum' command to reorganize the table files, ensuring minimal impact on operational costs and downtime.
B
Increase the number of partitions in the Delta table to enhance parallelism, despite potential increases in storage costs.
C
Apply the 'optimize' command to improve the table's overall performance, acknowledging it may not directly address the v-order issue.
D
Develop and implement a custom script to manually reorder the table files, accepting the risks of errors and extended downtime.