-
Notifications
You must be signed in to change notification settings - Fork 0
.NET Technical Test & Interview Questions
Onadebi edited this page Mar 19, 2025
·
1 revision
- What are the main advantages of using .NET Core over .NET Framework?
- Explain the difference between asynchronous and synchronous programming in C#. Provide an example of an async method.
- What are the key principles of SOLID design patterns? How would you apply them in a .NET Core application?
- What is dependency injection in .NET Core? Explain how it works with an example.
- How does garbage collection work in .NET Core? What are the different generations in GC?
- Explain the request pipeline in ASP.NET Core. What are middleware components?
- What are the differences between API controllers and MVC controllers in ASP.NET Core?
- How would you implement authentication and authorization in an ASP.NET Core Web API using JWT?
- What is model binding and model validation in ASP.NET Core? Provide an example of how to validate incoming API requests.
- How can you implement global exception handling in an ASP.NET Core Web API?
- What are the advantages of using event-driven architectures in a microservices environment?
- How does an event bus work in microservices? Provide an example using RabbitMQ, Kafka, or Azure Event Grid.
- Explain how to implement the Saga pattern in a distributed system.
- What are the common challenges of microservices architecture, and how do you overcome them?
- How can you handle distributed transactions across microservices?
- Explain the differences between Code-First and Database-First approaches in Entity Framework. Which one would you prefer and why?
- What is lazy loading, and how does it differ from eager loading in Entity Framework?
- How would you optimize the performance of an SQL query that joins multiple large tables?
- What are database indexes, and how do they impact query performance? Provide an example of how to create an index in SQL.
- How would you handle database migrations in a .NET Core application using Entity Framework?
- What are the different Azure services available for hosting .NET Core applications?
- How would you configure an Azure App Service to automatically scale based on incoming traffic?
- What is Azure Key Vault, and how would you use it to store sensitive information in a .NET Core application?
- How can you implement logging and monitoring for a .NET Core application running on Azure?
- Explain the differences between Azure Functions and Azure Web Jobs. When would you use each?
- What are the key components of a CI/CD pipeline?
- How would you implement CI/CD for a .NET Core application using GitHub Actions, Azure DevOps, or GitLab CI/CD?
- How can you use Docker containers in a CI/CD pipeline for deploying .NET Core applications?
- Explain how to automate unit tests and integration tests in a CI/CD pipeline.
- How can you secure secrets and credentials in a CI/CD pipeline?
- Develop a simple .NET Core Web API that allows users to register and authenticate using JWT.
- Implement an endpoint
/api/usersthat fetches all users from the database (use Entity Framework Core). - Implement an endpoint
/api/ordersthat accepts order creation requests and triggers an event using RabbitMQ (simulate an event-driven architecture).
-
Given the following SQL query, optimize it for better performance:
SELECT Orders.OrderID, Customers.CustomerName, SUM(OrderDetails.Quantity * OrderDetails.Price) AS TotalAmount FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID WHERE Orders.OrderDate > '2024-01-01' GROUP BY Orders.OrderID, Customers.CustomerName ORDER BY TotalAmount DESC;
-
Identify potential indexing strategies to improve query performance.
- Deploy a .NET Core Web API to Azure App Service using a CI/CD pipeline.
- Configure Azure Application Insights to log API performance metrics.
- Conceptual Understanding (30%): Ability to explain and apply .NET Core, ASP.NET, microservices, and database concepts.
- Problem-Solving & Optimization (30%): SQL query optimization, API design, and CI/CD implementation.
- Practical Implementation (40%): Hands-on ability to develop, test, and deploy .NET Core applications.