JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
Data engineering interview questions · hard
What is a Common Table Expression (CTE), and when would you use it?
What is the difference between a primary key and a unique key?
Explain Fact and Dimension Tables with examples.
Joins and window functions - INNER, LEFT, RIGHT, FULL OUTER, ROW_NUMBER(), RANK(), DENSE_RANK()
Difference Between Internal and External Tables in BigQuery
How do you optimize a long-running SQL query?
Cloud Architecture - explain
Consolidate hotel reviews and create a dashboard. Design a data model for the reviews.
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.