2) follow a link to a sql tool which shows 4 tables. Run some provided sql to populate the tables, Create the sql to aggregate the data and provide a result set showing the top row.
Senior Data Engineer Interview Questions
2,622 senior data engineer interview questions shared by candidates
Por que estoy buscando un cambio?
many different questions and discussions about my previous roles and experience
Do you need an EP Sponsorship?
What streaming technologies did you work on?
longest common suffix path without file masks
SQL questions: 1. First question was based on the ranking and join to get the solution 2. Second follow up question used the same database and tables. The question asked for a rolling average based on last 3 days. 3. Third question was again based on a rolling sum and then count query based on that rolling sum. All of the SQLs required CTE statements Lastly the Python programming question was a basic for loop to search the position of a target number. Interviewer asked for a different approach of solving it.
How to implement CDC in ADF with native functionality?
Problem: o A traveler flies to many cities (airports) in an unbroken chain of flights with no loops i.e never revisiting an airport. o For every flight, she has a boarding pass with only a From (City) and To (City) printed on it but no date/time. o At the end of her journey, she hands you all her boarding passes but they’re shuffled, so you don’t know the starting or the ending city. Can you: o Write logic or pseudocode to print her whole journey in sequence. It should print e.g. (Starting) City1 -> City2 ->….-> (Ending) CityX o State the time complexity of your solution. o you’re given a Set of BoardingPass objects as input. o there could be as many as hundreds of thousands of unique cities/airports. o memory is no concern (i.e. you have infinite memory!). Optimize for execution time (time complexity).
Domain knowledge related question
Viewing 181 - 190 interview questions