SQL Interview with Saravana(Senior Architect) from Indegene were as follows. This interview occurred on 23/01/2020.
[For questions asked during the first 2 rounds prior to this , refer to Indegene_Interview]
1. What data structure is more suited if we use ADO.NET(or any other C# framework) to read millions of records from SQL.
2. How would query plans work under the hood when you use cursors as compared to when you use inner joins. Also, explain how query plans are chosen in detail whenever we have a particular kind of data against particularly indexed columns in SQL.
3. Have you ever worked on SSIS, SSRS and SSAS previously?
4. If SP is executing fast enough but the ADO.NET application is not fast enough, then what could be the possible reasons?
5. Whether you had used Pivoting and under what circumstance I had used it. On SQL end, we use pivoting as a means to reduce the number of records(and thereby data) to be sent across to the TSQL Query optimiser. Similarly, how can I retrieve only necessary records from C# application end ( I think they were expecting something on the lines of us using GraphQL or OData. However, unsure of this) ?
6. How do you fasten calls from ADO.NET end like using plan caches.
7. How familiar are you with SPs, Views, Functions, TVPs and Triggers.
8. In what all ways can we optimise TSQL code and overall from C# to SQL (using SQL Adapter) when making calls to SQL ? (I think he was expecting osmething along the lines of optimizing adhoc queries, using SP's with AddWithParameter for parameterised SQL requests and proper indexing mechanisms to ensure right query plans(using plan guides) and forced caching of optimised plans using the options tags)
9. How familiar are you with Entity Framework ?
10. What’s the best place to register abstract interfaces with Concrete types in ASP.NET Core application ?
11. What all DI containers had I made use of in ASP.NET Core solution and how does the registrations work under the hood?
12. How good are you with jQuery and Javascript ?
Please feel free to share your experiences with Indegene if you had attended any interviews. So, these were the questions asked and I must tell that they consider experience in data stack more prominently that they would consider .NET stack. I am currently in "On Hold" status and I wonder if the process clears that stage or not.
Ending this post by wishing you a productive and happy day. Enjoy :)
Comments