Real questions from top companies
Explain the concept of window functions in SQL and provide an example
Explain the difference between Star and Snowflake schemas. When would you choose one over the other?
Explain the difference between partition count and query performance in Spark.
Explain the differences between OLTP and OLAP databases and their relevance in Adidas's operations.
Explain the differences between Redshift and Snowflake, and how I've used them in previous projects.
Explain the differences between table re-creation and ALTER TABLE operations.
Explain the order in which SQL clauses are executed.
Explain the process you would follow for optimizing a database query that is running slow.
Explain the purpose of windowing and triggering in streaming data pipelines.
Explain the scalability, performance, and cost-efficiency of both Redshift and Snowflake in different use cases.
Explain the use of Amazon Athena for serverless querying.
Explain the use of Elastic Resize vs. Classic Resize in Redshift.
Explain the use of surrogate keys vs. natural keys in data modeling.
Explain types of joins in Spark with examples.
Explain your approach to optimizing a slow-running query on a table with billions of rows.
Explain your understanding of indexing, partitioning, and execution plans.
Fact vs Dimension Table - categorize data
Facts and Dimension Tables Properties
Features of NoSQL Databases
Filter Rows Where Employee Salary > Manager Salary
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.