Microsoft Security interview questions

Very structured and somewhat mechanical. The recruitment process made me wonder what sort of a company this would be to work for and gave me that "big corporation" feel from start to end. I felt like I was dealing with corporate replicants from start to end, with rigidly defined processes for interviews etc. The technical interview was very mechanical, with someone simply reeling off a list of questions. The interview process totally put me off the company. I should have never gone for this role, as it was very product focused and I'm not an MS expert. Generic industry/technical knowledge seemed to have little value. I would only apply to MS, if you already work with their technology and have detailed nowledge of it.

I'm an international student in USA. I applied for this job through one of my friends and I got the interview. It took 3 weeks to be called as they were investigating whether they can offer me this full-time job (because of F1 visa and the effort needs for it to be changed to H1b). My interview was at 2:00pm pacific time and I was called on time. I was interviewed 38min as: a) Warm up: 1. First 15min: I was asked about my university and my study more on my visa status and what I would do if I get accepted. I was also asked about whether I liked to move out to Seattle and so on. I answered the questions well. I had done some research about the University of Washington and some on google map so I knew about my options and how I would continue my study and work at the same time at Microsoft. Moreover, I talked about the different USA visa types and their options to work and so far. 2. 5min: The second question was about whether I like to work as a developer or as an Qa. I answered that I would love to work as an QA and get some more experience in that field. I also added that I had been working as a developer so I would be more experienced as a software developer but I like to work in QA team and I know about what they do and their responsibilities. b) Technical Interview 1. SQL Problem: The problem was about this Employee table in SQL with four columns: Name(string, PK), Alias(string, Unique), Phone(string, NULL), ManagerAlias(string, FK) I was asked about three different questions: 1.1. Finding an employee's manager 1.2. Finding a manager's employees 1.3. Finding the all employees under on manager 2. The second question was a testing question about a function in which I should validate a Tic Tac Toe game. The input is a snapshot of the game and the output should be whether the game is correct or not. Answer: I could choose my ideal data structure for the snapshop so I chose 2-dimension character array. Test Cases: two players have won, either x or o has won, the game has already finished. 3. The third question was about what XSS is. I was passed technically but I was rejected as they said that I wasn't motivated enough. The problem was that I didn't care to be in QA team or the development team so they interviewer thought that I am not motivated for being in Microsoft. Overall, the interview was great, I couldn't understand from my interviewer's voice whether I was doing good or not but I was so confident about myself and I tried to answer with reasons. I tried to think loud so I could let the other side know that even if I am answering wrong, I know the differences between view, stored procedures, local table variables, and cursors.