Slowly Changing Dimension Types (DataWarehouse - SCDs)
Data Engineer Interview Questions
20,250 data engineer interview questions shared by candidates
Considerations to define table structure with billion of records
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).
Whats are different the different spark Mode and explain them
What is partitioning in SQL?
explain the joins in DBMS and concepts of dbms
Describe a situation where you were seeing lot of data incoming and how did you handle the situation.
SQL, python related questions . Logical questions and puzzles
Leadership principles related questions. Can't mention the exact questions since I signed the NDA.
Viewing 1681 - 1690 interview questions