Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
Consider a scenario where a SQL query is taking an unusually long time to execute due to a large number of small files in a Delta table. Explain how you would identify this issue and what steps you would take to resolve it. Specifically, discuss the use of optimized writes and compaction techniques.
Explanation:
Using optimized writes can help to reduce the number of small files by ensuring that data is written in a way that minimizes fragmentation. Additionally, compaction techniques can be used to merge small files into larger ones, which can improve query performance by reducing the overhead associated with reading a large number of small files.