Avnet interview question

In SQL they will ask you about joins, datetime function, subquery, cte, views, index, and some optimization questions. In Excel lookup, pivot table, and how to clean data In Power BI Data cleaning, Data collaboration from different source like excel, SQL and cloud, RLS, DAX