I applied online. The process took 5 days. I interviewed at Cygnet Infotech in Jul 2024
Interview
They delayed the interview 2 hours and informed me prior 2 mins of scheduled interview. And the interviewer still hold the call for other 15 mins. And the interviewer started with taking introduction and about daily tasks
Interview questions [1]
Question 1
Max degree of parallelism
RPO & RTO
Table type
Column store index
Joins
Update stats
Fill factor
Online index rebuild
Partitioning
Temp table vs temp variable