Real questions from top companies in SQL
What strategies and technologies would you consider when designing a data warehouse architecture for efficient data storage and retrieval?
What strategies would you use to manage dynamic partitions efficiently?
What technologies are you most comfortable with?
What types of columns support PARTITION_BY in BigQuery?
What's the role of surrogate keys in dimensional modeling?
When can you start if selected?
When would you choose partitioning over bucketing, or vice versa?
Where is the PARTITION_BY option in the BigQuery UI?
Where to store secret keys?
Why is HAVING clause used only after GROUP BY?
Why not use ROW_NUMBER() instead? Discuss pros and cons.
Why star schema? Compared with snowflake schema and normalized approaches.
Window Functions: ROW_NUMBER(), RANK(), PARTITION BY - produce output using dataset
Write SQL query for sum of marks grouped by student.
Write SQL query to find names starting with 'R' and ending with 't', sorted by first_name descending
Write SQL query to replace specific patterns in a string column.
Write SQL to identify employees whose salary is higher than their manager's.
Write a Merge Statement for SCD Type 2.
Write a PySpark job to find the top 3 employees of each department, where Age < 30 and Salary > department average salary.
Write a SQL query leveraging window functions and timestamps to identify updates over time
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.