Your question is SQL Indexing and DAX Nuances. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Explain the difference between indexes storage in SQL Server, how INTERSECT works, and how you would use ROW_NUMBER without an ORDER BY; also compare SUM vs SUMX in DAX and how you would optimize Power BI DirectQuery.