🔥 3-day streak
Microsoft Fabric Data Engineer Associate134 / 144
Question 134 of 144

A reporting team runs the same complex aggregation query against a Fabric warehouse dozens of times per hour, and the underlying tables change only once per night after the ETL load completes. Users complain that each execution takes 15-20 seconds even though the data has not changed. You need to reduce the response time for these repeated, identical queries with the least administrative effort and without duplicating data. What should you do?

Reviewed for accuracy · Report an issueNext question