Microsoft Corporation Interview Questions, Process, and Tips

Q1. Design a news app for Youngsters - This was the GD round, but Microsoft took one on one interviews
Add your answer
Q2. . I was also asked how the backend of the news app would look like. This round lasted around 35 mins
Add your answer

Q1. To design a platform that helps users know about the relationship between celebrities (something like Six Degrees of Kevin Bacon). . I was asked how to implement it
Add your answer
Q2. I was also asked questions like what a database is, how is a database different from a data warehouse
Add your answer
Q3. What is Business Intelligence, what is predictive analytics? Give an example of both
Ans. 
Business Intelligence is analyzing data to make informed business decisions. Predictive analytics is using data to predict future outcomes.
• Business Intelligence involves collecting, analyzing, and presenting data to help businesses make informed decisions

• Predictive analytics uses statistical algorithms and machine learning techniques to analyze historical data and make predictions about future outcomes

• Example of Busine...read more
Answered by AI
Add your answer
Q4. How would you implement predictive analytics in this question to make the platform better?
Ans. 
Predictive analytics can improve the platform by providing insights into user behavior and preferences.
• Collect and analyze user data to identify patterns and trends

• Use machine learning algorithms to predict user behavior and preferences

• Implement personalized recommendations based on predictive analytics

• Continuously monitor and update the predictive models to improve accuracy
Answered by AI
Add your answer
Q5. I was also asked to draw the UI of the platform. I was asked questions on Amazon Redshift - what is it? what makes it unique? What are its competitors? What's the difference between Redshift and MySQL Serv...read more
Add your answer

Q1. - Design a platform for wedding planners in India - The interviewer gave me a background of the problem
Add your answer

Q1. Design a personal assistant for a physical shoe store that eliminates the need of a salesman
Ans. 
A personal assistant for a physical shoe store that eliminates the need of a salesman
• Develop a mobile app that allows customers to scan the barcode of a shoe and get all the necessary information about it

• Include a virtual try-on feature that uses augmented reality to show customers how the shoe would look on their feet

• Integrate a chatbot that can answer customer queries and provide personalized recommendations

• Use senso...read more
Answered by AI
View 1 more answer
Q2. . I was asked to define the customer, what sort of shoe stores would this work at? and how the personal assistant would work. I was also asked which Team in Microsoft would I like to join and why? What sho...read more
Add your answer
Q3. What should Microsoft focus on in the near future and why?
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Reverse a tree using DSA
Ans. 
Reverse a tree using DSA involves traversing the tree in a specific order and swapping the left and right child nodes.
• Start by traversing the tree in post-order or level-order traversal.

• Swap the left and right child nodes of each node as you traverse the tree.

• Continue until all nodes have been visited and their children swapped.
Answered by AI
Add your answer

Case study an in depth study oc one person,group,or event

A situation faced when individual collectvely make a choice for the alternative before them

Data Structures and Algorithms - Easy

Code a chineese pebble game

Q1. 2 Entities for cross site sale promotion.
Ans. 
Two entities for cross site sale promotion are affiliate marketing platform and customer loyalty program.
• Affiliate marketing platform: Allows businesses to partner with affiliates who promote their products on their own websites in exchange for a commission.

• Customer loyalty program: Rewards customers for repeat purchases or other actions, encouraging them to continue shopping with the brand.
Answered by AI
Add your answer
Q2. Grill on Q1 with questions on security and loop holes. List SPOF and how to fix it.
Add your answer

Q1. Do you want to do a Puzzle round?
Add your answer
Q2. Then asks Celebrity problem which I obviously didn't know at that time.
Add your answer

How would you integrate tech to improve customer experience of any public place like amusement park, sporting events, historical sites, etc.
A- For this I picked up Universal studio as my area of work. Applying CIRCLES framework aggressively,
I started with defining the customer persona -
Families with small kids, youth, older population (45+), school children Then i picked up on the issues they face currently - prioritizing issues of long waiting time in lines for rides like roller coasters and creating a memorable experience by getting pics clicked at crucial moments/candid pics

Once getting the defined on above lines, i moved onto creating solutions.My basic idea was to get customized app made for the park, which can be downloaded on entry. It would have a map of the place, point user's location and show his colleagues
if they separate out for trying different rides.
this would help large groups to not keep calling but reach out directly to fellows.

The next important feature i would include is generating a "customized route" for the
user based on his interest. E.g. if the user is aged 25 and is adventurous and risk taker, the route will direct him to those rides which would satisfy his need. for another user who is 12-14 years old, the route would be different.

Lastly, the app will show the latest waiting time for all rides. it would be a indicator for anyone to make his/her decision to move towards that ride rather than going all the way there and finding out. this would give user a clear view and will act as load balancer for the park.

Lastly, the app will be used to push notification to the user - about the Hollywood parade starting time or the adventure show timings.

Once the scope was defined, i made a quick wireframe of the app along with discussion
with the interviewer.

Post this, I analyzed some risks -
1. the app may direct a lot of crowd to same place and this would add to waiting issues.
To counter this, i suggested on using GPS services and having a real time data on where
the customers are and accordingly, giving updates to new users for different rides and
balancing the load

2. The battery usage would be huge - for this, I suggested to have charging points inside the locker where every user has to submit his belongings before going for the ride. This would actually assist users in getting quick charge on every ride we also discussed the implementation strategy on what resources would be needed which was short and quick.

Design Bing for kids (up to 10 years).
- now this was ideal case of applying the Circles Framework again. I started with what’s the current situation - The UI is not cool - internet and search engine usage is difficult for kids to adapt - Language barriers (since most kids speak their native language and English can be tedious) - too long and complex content with high vocabulary isn’t acceptable to kids - too much text - no fun - internet access to poor is low Once this was discussed in detail, we moved onto identifying our customers and their attributes - Kids in age of 6-10 - need internet mostly for school homework’s - interested in games and fun - like color and images over text - Language has to be made easy - Child lock/ Parental control facility needed to avoid exposure to unwanted content - lite pages for poor who have limited data packs The basic need identified was "creating a search engine which is focused on kids with cool, fun and colorful search results in various languages and based on lite pages for easy search and download" Then I enquired on whether I have to start from zero and make a new Bing altogether, or use current version and have a toggle between normal Bing and Kind Bling. On this the interviewer mentioned about using a single product but having various versions. Once this was confirmed, I decided that I would be prioritizing language settings and colorful, fun searches in phase 1 I started listing solutions - on opening Edge, Bing would come up with profile-based images. for normal user, a password would be asked For kids’ profile, there would be no password and would directly load the Kid Bing homepage with a game of the day present there. BTC Interview Handbook Co2019 19 the search box would be big and there would be autocorrect feature present as kids can make mistakes while searching and using AI, the system should be able to rectify the input for proper search. Secondly, on search, there would be 2 features present - Only Display result and Display Audio result the results would be only those which have kid content flag marked on it. This would be an activity which has to be done in backend while mapping and indexing the pages. the flag would be a new attribute for every page uploaded onto the net. Once the search is over and results appear, firstly, the font or image would be too huge, there would not be much scroll feature available, but the page layout would be in sort of a book with "Turn page" / "arrow" marked on the right side for next page. This would give them a feel of using a book. There would be audio feature available besides the search and the kid can click on play button for listening to the content. the language would be both - English and regional. Lastly, the whole of history would be stored for every session which would be available for parents/guardians/teachers. This will not only help in control but also to refer to the pages which the kid saw and not wants to use but forgot to bookmark or copy the data. While this discussion was being done, I also made a framework on the paper which assisted me in explaining my solution. The fun game part was a brownie solution as the interviewer seemed to like it when i explained that this would actually be a crowd-puller, encouraging kids to play the game and then see how they performed over time. the games would be analytics and GK based and would act as barrier-breaker for parents to allow their children to access net. The Risks highlighted were - Support of regional voiceovers - Disturbance to surroundings by kids misusing this feature - Reworking on the indexing of the whole content on the engine The discussion ended here, and the interviewer highlighted about the missing point of usage of current search data to identify what is primarily being searched in schools and learning from it to determine the new content to be made.

How can you use mobile phones for quality control of a bottle making plant?
I first started with gathering more information from the interviewer about what is the plant about? How’s the process of bottling? What is the current process for quality control?

The scope of discussion post above questions was just to make sure that every bottle that comes out from the assembly line is proper. If yes - accept it, if no reject it. this is currently being done by humans and i was given liberty to use only mobile phones to make the process automated. My customer in this scenario was a small-scale bottling factory.

There was no need to focus further on needs and thus i moved onto designing the solution. I first introduced hawk eye process to the interviewer. I knew a bit about it and thus explained that one of the ways to complete this process is using 6 cameras adjusted at particular angles to capture the 3D image of the bottle. then there was a question on orientation, for which I advise on having a marking on the bottle, a line running from the top to the bottom which would be taken as reference and the image would be aligned accordingly.

This would then be checked with the ideal image and if ok, it would be passed else thrown out. Lastly, I highlighted about the issue of not able to capture the image from below as the conveyor belt would not be opaque. for this, the interviewer highlighted that this can be ignored.

Post this, I worked on costing for a bit and suggested the pricing would be based on service and not the product. It would be given out on rent and payment collected annually. This helps us in recurring revenue and also a good way to perform B2B marketing by constant interactions. BTC Interview Handbook Co2019 18 the risk was again about the battery usage and low definition cameras, but this were countered by low cost phones available today and a constant power supply providing ability at the factory. also, the backend program would have to be developed in-house to check for quality and that can be improved in multiple iterations and new versions upgrade.

Q1. Design Bing for kids (up to 10 years)
Ans. 
Bing for kids up to 10 years should be colorful, interactive, and educational.
• Use bright colors and fun animations to engage kids

• Include educational content such as games, quizzes, and videos

• Ensure safety by filtering out inappropriate content and limiting access to certain features

• Make it easy for kids to navigate and search for age-appropriate content

• Include parental controls and monitoring tools

• Partner with trusted ...read more
Answered by AI
View 1 more answer

This was the last round with a very senior person from the firm We started by discussing cricket as it was one of the extra-curricular activity mentioned in my resume.

There were some behavioral questions on what you learn from cricket, how do you plan to incorporate the learnings into your work environment, have you ever captained the team (on saying yes) What are your key learnings on team management?
The discussion went on for around 20 minutes and this eased the pressure of the final round. Then we went onto a short discussion

Microsoft is thinking of incorporating speech-bot for movie booking on Bing to replace the current process of search and book- You are the product manager for Bing overall- what is your view?
In this case, I initially started with applying the framework again but was cut short by the interviewer. He asked me to directly jump to the core issue of what is good, what isn’t and give a suggestion.

So i quickly moved to the pros of Speech botAdvantages- Easy, Fast, Exciting, doesn’t require attention to the screen, tickets can be
booked on the go - while driving, travelling, walking it is the new tech which Microsoft is investing in (as shared by the interviewer) and thus there is a need to incorporate it in many more products. Movie booking can be the pilot for integration with Bing and thereon it can be expanded into different searches. Here I quoted about the Bing for Children (from last case :P)

Then I moved onto disadvantages- the biggest one for me was disturbance and lose of privacy while making such bookings, others were disturbance, still not a foolproof technology, lot of languages present in India, pronunciation difference across people, limited results

I gave example of each disadvantage

Loss of privacy - what if a son is planning to go for movie with girlfriend or friends and while booking, if he uses speech, the parents may come to know which he doesn’t want - so he would avoid

Disturbance - although a person may use earphones to hear the bot but while speaking, he may disturb others - say a person booking tickets in office

Disturbance - In India, there is a huge crowd at public places like metro and local train and thus the chat could be impacted by noises around. the user may have to shout at times

Not foolproof - I gave example of Bhagat Singh movie (from top of the mind) and highlighted there are multiple movies with same name, so giving additional information which would take a long time may get incorrectly reported with the bot.

Languages - Easily explained through multiple film industries in India in regional languages and thus the bot has to cater to many such languages pronunciation - In India, again there maybe children or not English-speaking people who maybe wanting to go for English cartoon movie but they lack the clear pronunciation and these may lead to errors E.g. going for Ratatouille

Based on above, and with discussions on each, i took the decision that i would not like to incorporate speech bot in Bing as of now.

He was convinced but followed with another question - that while you took the decision, the VP of Speech Bot who reports to CXO member has reached out to you - highlighting that this incorporation needs to be done. what will be your response?
I replied with a firm NO for current day's implementation. I said that although there is a lot of push, i would highlight the same disadvantages to the VP, make him understand the issues, if there is any disagreement - I would recommend to go for a market study and check how a sample population is responding to the change and that would provide us a better evidence for decision making.

As the intention is to incorporate speech bot and movies was a suggestion, I would also look at other possibilities for speech bot rather than movies - like story reading, novel reading or news reading. Maybe Food booking services.

However, in the end if the push is still on, I would go ahead but with the disclaimer highlighted to all my stakeholders. The interview ended post 45-50 min. This was the last round and then i was offered PM2 role in Microsoft.

2Coding questions were there

Q1. Reverse string standard DSA
Add your answer
Q2. Tapping rainwater standard DSA
Add your answer