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 situation where you had to redesign a data model to meet changing business needs
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).
Design the data model for an ETL pipeline that ingests data from a database and loads it into Snowflake
Designing backend architecture for SQL Warehouse?
Designing scalable data models - explain approach
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.