DataEngPrep.tech

JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.

DataEngPrep.tech

Questions Blog Store

Interview Questions

Real questions from top companies in SQL · easy

700+ Easy450+ Medium650+ Hard

All Categories Behavioral Spark/Big Data SQL Python/Coding System Design/Architecture Cloud/Tools General/Othereasy medium hard

Explain the differences between a Data Lake and a Data Warehouse.

SQLeasylakehousesnowflakesql0.5 min read

ChryselysFedEx DataworksLumiqNAB

Explain the concept of ACID properties in the context of databases.

SQLeasy0.4 min read

AccentureCognizantEPAMYash Technologies

Explain Common Table Expressions (CTEs) and their benefits.

SQLeasybigquery0.5 min read

AareteDunnhumbyIncedo

Explain the difference between UNION and UNION ALL.

SQLeasy0.4 min read

What is the difference between a clustered and non-clustered index?

SQLeasybigquerysql0.4 min read

What is the difference between DELETE and TRUNCATE?

SQLeasy0.4 min read

What is a CTE (Common Table Expression)? What are its uses?

SQLeasybigquerysnowflake0.6 min read

Fossil GroupKaseya

8

Aggregate surface areas and calculate cumulative surface area using the LAG function.

SQLeasy

9

Are you comfortable with the variable pay structure, and what are your expectations for the base salary?

SQLeasy

10

Building ETL pipelines to capture changes when new records are inserted into source tables?

SQLeasy

11

CSV Without Column Names/Schema - how to read

SQLeasy

12

Can CASE statements be used in an UPDATE query?

SQLeasy

13

Can you chain multiple triggers for a single pipeline?

SQLeasy

14

Can you provide a use case where Assert Transformations helped maintain data quality?

SQLeasy

15

Can you share an experience where you resolved a conflict within your team?

SQLeasy

+13 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 $21 Try Free Sample