Perguntas de entrevista da empresa Lagozon Technologies

1. Time intelligence functions; 2. M transformations 3. Joins, coelsce based SQL queries 4. 8/2023, 9/2023: convert these type of date formats into 01/08/2023 and 01/09/2023 using M query; The solution should be generalised. 5. Incremental refresh and where it's won't work.

1. SQL basics to intermediate questions like windows functions, CTE and joins.