He asked qs on SQL like cte, constraints,2 SQL queries,one challenging situation at work place,what all have you used or worked on ,nothing from my projects,when to use which database,is azure olap or oltp,things to make sure while loading data into database like data redundancy,when will be the first thing you need to ask customer while setting up a database,how do you differentiate between b2b or b2c via source system.The interview is not grilling or too much technical,it was very basic that you must have used already in your projects but be through with the business knowledge and the data being used since the interviewer sounded very sound with the techno business knowledge and you need to be in a facing role in this job profile.I wish he would have grilled more on technical aspects but it's just 30 mins so makes sense. The interviewer was quite intimidating,late for interview and no proper net connection:P