Basics of relational databases, OLAP vs OLTP, and the difference between a database and a data warehouse. They also asked to explain the need for stored procedures when the underlying SQL query can be executed on its own. Practical scenario-based questions like an e-commerce workflow (AWS login, orders, products, delivery, payments) and how all these systems are connected. Python-related questions, especially if it’s mentioned on your resume — they focus more on your project workflows and logic, not actual coding. Detailed discussion about the projects you’ve worked on — architecture, approach, challenges, and decisions. Questions about pipeline failure handling, such as how you would detect, troubleshoot, and recover using scripts or automation.