0–2 years · Junior — C# · ASP.NET Core · Entity Framework · SQL Server · LINQ · Azure
Checks for exceptions being thrown in the async method; verifies that all awaited tasks are properly awaited; looks for race conditions or shared state issues; examines the calling code for proper handling of async results; considers the impact of thread pool exhaustion.
If exceptions are being thrown, how do you ensure they are logged and handled correctly?
Starts with performance monitoring tools to gather metrics; identifies slow-running queries and inspects execution plans; assesses recent code changes for performance impacts; checks for unnecessary data loading or processing; evaluates resource usage on Azure.
You identify a particular query is slow. What steps do you take to optimize it?
Details the specific problem and its context; explains the reasoning behind reaching out for assistance; names the resources or individuals consulted and why; describes the outcome of the interaction and any changes made based on the feedback received; reflects on the learning gained from the experience.
What would you consider before asking for help next time?
Identifies a specific design choice, explains the context and constraints; mentions the signs that indicated issues, such as performance degradation or data integrity problems; describes the re-evaluation process and changes made; explains the impact of the decision on the project, including time and resource costs; avoids attributing blame to others.
What would you do differently if faced with the same decision again?
Checks if the DbContext is being tracked correctly; verifies that changes are being made to a tracked entity; confirms that SaveChanges() is being called; looks for validation errors that could prevent saving; examines if the transaction scope is affecting the commit.
What would you do if SaveChanges() is being called but still no changes are saved?
Verifies the service registration and lifetime in the Startup class; checks instantiation logic for shared state; inspects the code for static fields or properties; reviews where and how the service is being used; considers isolating the state within the service.
What would you change in your service design to prevent this issue?
Load six more — you will get questions you have not seen first.
Give me six more →Say your answer out loud before revealing. Reading the answer first feels like learning and is not.