Pergunta de entrevista da empresa ABC

How do you optimize DAX queries for better performance? What are the differences between CALCULATE and FILTER in DAX? Explain SUMX vs. SUM—when would you use each? How do you handle performance issues in Power BI with large datasets? What are star schema and snowflake schema? Which is better for Power BI?