🔥 3-day streak
Microsoft Fabric Data Engineer Associate135 / 144
Question 135 of 144

A data engineer notices that several analytical queries against a Fabric warehouse have become significantly slower over the past week. A large fact table recently received millions of new rows via nightly loads. When reviewing the query plan for one slow query, the engineer sees the optimizer is dramatically underestimating row counts for a filtered predicate on a frequently used column, causing poor join strategies. What is the most appropriate action to improve query performance?

Reviewed for accuracy · Report an issueNext question