Chubb Data Engineer interview questions

Azure What is the difference between system assigned managed identity and user defined identity ? What are the different methods to secure the data in a azure data lake storage ? Data bricks What is the difference between mounting and volumes ? What are the different cluster types ? What are the different ways of installing libraries ? What is liquid clustering ? What are the advantages and dis advantages of parquet files ? Data Modelling What is the difference between data lake and lakehouse ? Types of dimensional modelling techniques? Types of data architectures ? difference between 2 tier and 3 tier architectures? SQL Different Query optimization techniques. Query: There are 2 tables 1. employee (columns: employee_id, employee_name) and 2. projects (columns: employee_id, project_id) Write a query to get all the employees with no projects.