DataEngPrep.tech
QuestionsBlogStore
Get PDF Bundle

Interview Questions

Real questions from top companies · medium

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

What metrics would trigger an auto-scaling event?

SQLmedium
2

What metrics would you analyze to determine if your partitioning strategy is effective?

SQLmedium
3

What motivates you to join Morgan Stanley?

SQLmedium
4

What strategies would you use to manage dynamic partitions efficiently?

SQLmedium
5

What types of columns support PARTITION_BY in BigQuery?

SQLmedium
6

When would you choose partitioning over bucketing, or vice versa?

SQLmedium
7

Where is the PARTITION_BY option in the BigQuery UI?

SQLmedium
8

Why is HAVING clause used only after GROUP BY?

SQLmedium

+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...24Next