What technical topics actually come up during business intelligence interviews

I spent the last few weeks preparing for data analyst roles and noticed a common pattern in technical rounds. Candidates almost always get tested on the difference between calculated columns and measures. Understanding memory usage and row context seems to be what separates junior applicants from stronger candidates. Focus on explaining how star schemas improve query speed instead of just memorizing syntax. What was the most unexpected technical question you received recently?