Brillquest Technologies Interview Question

SQL: Write complex queries (e.g., second highest salary, window functions, joins, performance tuning). Python: Data processing with pandas, exception handling, lambda/map/filter, file handling. ADF: Pipeline creation, triggers, parameterization, incremental load, error handling. Data Lake: ADLS Gen1 vs Gen2, folder structure, security, access. Databricks: Delta Lake, notebooks, schema enforcement, performance tuning. Walk me through your recent data engineering project.