Microsoft | Senior Consultant | Bangalore [Rejected]

Role: Senior Consultant

Questions:

1. There is a list of employee data which has 1000+ records. Get the employee who has the least salary in an efficient way.

Employee name Employee id Employee gender Employee salary

Get min salary of an employee

Select employee_name From EMPLOYEE Where employee_salary == (select MIN(employee_salary) from EMPLOYEE)

Select top 1 employee_name from EMPLOYEE order by salary ASC 100 23 130 200 555

2. Multiple and multi-level inheritance.

3. CORS and security practices in UI (Angular) and Backend (.NET).

4. Microsoft Goals

5. Write a program - Based on the stock profit, tell the investor when to buy and sell a stock given 7 days stock profit.

80 100 115 90 120 95 110 - buy on Monday and sell on Thursday to get max profit.

6. Latest Project Architecture

7. What is Monolithic Architecture?

8. Single Responsibility and Dependency Inversion principles.

9. Explain SOLID principles—use cases.

10. Any questions?