🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate76 / 150
Question 76 of 150

You maintain an Eventhouse (KQL database) containing a large table named PageViews with millions of rows and a small reference table named PageMetadata that maps PageId to Category. You need to write a KQL query that returns each page view enriched with its Category. The PageMetadata table has only a few hundred rows and is much smaller than PageViews. Which KQL join approach gives the best performance for this scenario?

Reviewed for accuracy · Report an issueNext question