DataEngPrep.tech
QuestionsBlogStore
Get PDF Bundle

Interview Questions

Real questions from top companies in SQL

700+ Easy450+ Medium650+ Hard
All CategoriesBehavioralSpark/Big DataSQLPython/CodingSystem Design/ArchitectureCloud/ToolsGeneral/Othereasymediumhard
1

Snowflake: Types of Caching, Time Travel vs. Fail-safe, Snowpipe, Materialized Views

SQLhard
2

Solve a coding question related to window functions using SQL and PySpark.

SQLmedium
3

Solve a problem using a window function in Spark or SQL.

SQLmedium
4

Solve a query using window functions and GROUP BY to rank or aggregate data.

SQLmedium
5

Solve a running sum query

SQLmedium
6

Solve medium-level SQL questions involving two tables with null values - LEFT JOIN, RIGHT JOIN, INNER JOIN

SQLmedium
7

Spark optimizations: Partitioning, caching, tuning parallelism

SQLhard
8

Stored Procedure Optimization

SQLhard

+20 More Questions with Expert Answers

Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.

Get PDF Bundle — from $21Try Free Sample
Previous1...1718192021...25Next