The interviewer did not look at my resume and did not introduce himself. He was busy with his mobile during the video call. It seemed like he was not interested in conducting the interview or was confused about something. Precisely, the interview took 57 minutes and 30 seconds (as he joined 2 minutes and 30 seconds late). 21 questions were asked.

They will majorly ask SQL. Although, in my case, the interviewer himself was confused with his own examples, mixing OLAP and OLTP in the same questions and forcing his own solutions over the candidate's solutions.

Why Azure Synapse? Pros and Cons

Different File Storage Formats: Pros and Cons Which to use and when

Factors applicable while selecting a storage type

If sudden slowness occurs between two different systems, what can be the root cause?

Partitioning: Why to use and how to use

What is data skewness? Effect of the same in Synapse and query processing with an example

Integration Runtime

Factors to be considered for ingestion or set of answers you are looking for.

4-5 SQL questions