Microsoft Fabric Analytics Engineer Associate DP-600
Comments
Loading comments...
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are managing a Delta table in Azure Databricks that has grown significantly in size, leading to performance degradation during query execution. The table is critical for daily analytics and must remain available with minimal downtime. You need to identify and implement the most efficient solution to optimize the table's performance without compromising data integrity or availability. Which of the following actions should you take to address the issue? (Choose one option)
A
Increase the number of partitions in the Delta table to distribute the data more evenly, potentially improving query performance but not directly addressing the file size issue.
B
Execute the 'optimize' command on the Delta table to reorganize and compact the underlying files, improving read and write performance without data loss.
C
Delete the current Delta table and recreate it with the same schema and data, which could lead to temporary unavailability and potential data loss if not handled carefully.
D
Add additional indexes to the Delta table to speed up query performance, which may not reduce the physical file size or improve overall table management efficiency.