Infosys interview question

1. How to optimize SQL? 2. How do you authorize it in .NET MVC? 3. How to create an Azure App/Resource? 4. What is DENSE_RANK and RANK?