Microsoft NET Technical Architect interview questions

First Round. 1. What is fill factor in sql server ? 2. What does UPDATE STATISTICS command do ? 3. What is a page in sql server ? 4. Difference b/w Clustered & Non-Clustered indexes? With pros & cons. 5. What is the difference b/w scale-up & scale-out option? 6.Given a limited time frame describe some steps at each layer for scaling the web application? 7. Some questions about the project like some security concerns, how to improve authentication etc. 8. Questions relating to updating the delta feed using the full feed only b/w two similar DB's. 9. What is TempDB? 10. If there are two websites one for desktop & other for mobile and you need to create a service which interacts with both. Then how will you implement the service? 11. Which one is better WCF or REST? Why? Give some scenarios as suitable? Second Round 1. Explain the terms & your experience in Software Engg., Coding & Scalability? 2. What is your expertise? I said mobile development. 3. Why do you observe more traffic on mobile site as compared to desktop or apps? (Target audience for non-metro cities) 4. Where did you use RedisDB in the application? (Related to my project)