Explain Triggers in SQL with examples and scenarios for use.
SQLeasy
3
Explain a project where you had to influence stakeholders without having authority.
SQLeasy
4
Describe a cross-team data project where you had to align architectural boundaries, ownership, and SLAs. How did you handle conflicting priorities, technical debt, and the scalability of communication as the number of stakeholders grew?
SQLeasy
5
Walk through a production incident where data freshness or correctness was at risk. How did you balance immediate mitigation vs. root-cause remediation? What architectural changes would prevent recurrence, and what are the cost vs. reliability trade-offs?
SQLeasy
6
Explain how to flatten a multi-level nested JSON file while loading it into BigQuery.
SQLeasy
7
Explain normalization in databases and its importance. Write an SQL query to handle SCD-1 or SCD-3
SQLeasy
8
Explain the differences between Redshift and Snowflake, and how I've used them in previous projects.
SQLeasy
+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.