Real questions from top companies in SQL · 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.
Create Spark Session, read CSV, join, and write as table. Provide example code.
Data Warehouse Design from scratch
Describe a challenging project where you optimized a complex ETL process.
Describe a recent project where you used AWS services extensively. What was your role, and what challenges did you face?
Describe a scenario where you used Databricks for real-time data processing.
Describe a situation where you had to redesign a data model to meet changing business needs
Describe how metadata is stored and accessed for internal tables in a relational database.
Design a Custom API that can query a backend server and return customer data such as the number of orders placed by a user based on their user ID
Design a daily ETL pipeline to ingest API data into BigQuery.
Design a financial database system focusing on database models, schema design, partition keys, and query optimization techniques.
Design a relational data model for a sales database, incorporating normalization techniques
Design a structure (data model) that allows efficient querying of movies based on multiple search criteria (title, genre, actor, director).
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.