AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Microsoft Corporation
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Microsoft Corporation Associate Consultant Interview Questions and Answers
Microsoft Corporation Associate Consultant Interview Experiences
2 interviews found
Anonymous
(1 Question)
- Q1. Who developed c
- Ans.
C was developed by Dennis Ritchie at Bell Labs in the early 1970s.
Developed by Dennis Ritchie at Bell Labs
Created in the early 1970s
Influenced by B programming language
(1 Question)
- Q1. Coding problem statement
Interview Preparation Tips
Prabhanath Nair
Selected
I applied via Referral and was interviewed before Mar 2023. There were 3 interview rounds.
It was straightforward and basic technical scenarios
(1 Question)
- Q1. Combined DSA, and scenarios driven questions
(1 Question)
- Q1. Managerial round
Interview questions from similar companies
I was interviewed before Jun 2021.
(2 Questions)
Round duration - 180 minutes
Round difficulty - Easy
It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy
- Q1.
Find the Duplicate Number Problem Statement
Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...
- Ans.
Find the duplicate number in an array of integers from 0 to (N-2).
Iterate through the array and keep track of the frequency of each number using a hashmap.
Return the number with a frequency greater than 1 as the duplicate number.
Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.
- Q2.
Reverse String Operations Problem Statement
You are provided with a string
Sand an array of integersAof sizeM. Your task is to performMoperations on the string as specified by the indices in arrayA... - Ans.
Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.
Iterate through the array of indices and reverse the substrings accordingly
Ensure the range specified by each index is non-empty
Return the final string after all operations are completed
Round duration - 60 Minutes
Round difficulty - Easy
It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.
Interview Preparation Tips
Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes
Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
(1 Question)
- Q1. Questions on Salesforce Basics. One can learn all great features in Salesforce.com but we must know the basic admin functionalities and features in Saleforce.
(1 Question)
- Q1. The questions will be on your career, Resume. They will look for story telling skills, can you be a team player and individual player, etc. Can be technical as well.
Interview Preparation Tips
I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.
Interview Preparation Tips
You need to stay calm and should apply presence of mind. Please go through the job description thoroughly word-by-word and recheck your resume to ensure that you are a best-fit for the position.
Skills: Communication, Body Language, Problem Solving, Leadership, Presentation Skills
Duration: <1 week
Interview Questionnaire
6 Questions
- Q1. What is fan trap? How to solve it? Give one example.
- Ans.
Fan trap is a situation in which a query involving multiple tables results in a Cartesian product.
Fan trap occurs when a table is connected to multiple tables in a one-to-many relationship.
It can be solved by creating a bridge table or by using aggregate functions.
For example, if a customer table is connected to an orders table and a products table, a fan trap can occur when trying to retrieve information about custome...
- Q2. Two tables are joined. But joined type are not mentioned, then how much records will retrieve using select statement.
- Q3. How to use dynamic break in report?
- Ans.
Dynamic break in report allows for automatic page breaks based on data.
Define a break field in the report design
Set the break field to trigger a page break when its value changes
Use dynamic break to automatically adjust page breaks based on data
Example: A report on sales by region can use dynamic break to create a new page for each region
- Q4. Use of foreach function in report.
- Ans.
Foreach function is used to iterate through an array of strings in a report.
Foreach function is used to loop through each element in an array of strings.
It can be used to display each element in a report.
Example: foreach(string item in stringArray){ Console.WriteLine(item); }
- Q5. What is Aggregate awareness? When we use it? Syntax of it.
- Ans.
Aggregate awareness is a feature in Business Objects that allows reports to be optimized for performance by using aggregate tables.
Aggregate awareness is used when creating reports in Business Objects
It allows the report to use aggregate tables instead of detailed tables for improved performance
Syntax: AGGR_AWARE(
, , )
Example: AGGR_AWARE(Product, Sum(Sales), Sales_Fact_Table)
Answered by AIAdd your answer- Q6. @prompt function syntax and it's use.
- Ans.
The @prompt function syntax is used to display a prompt message to the user and receive input.
The syntax is @prompt('message', 'default value')
The message is the prompt message to be displayed to the user
The default value is optional and will be displayed in the input field
The function returns the value entered by the user
Answered by AIAdd your answer Interview Preparation Tips
Interview preparation tips for other job seekers - they ask question on basics and concepts more, rest interview is easy. I applied via Company Website and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. String manipulation , collections, framework understanding
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - For QA Automation - Basics of OOPS concept,collections,strings are enough I applied via Campus Placement and was interviewed before Apr 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me about Yourself?
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Before going to the interview the most important things to be done which works like miracles..
1. Sit in the meditative state for 2-5 mins just before the interview.
2.Think about all the blessings and all that you have and thank for having that.
3. Go with the mind set of being ethical and say to yourself that you are going to crack this interview no matter what (Easy,Medium or difficult)
Thank you
I would be happy if many people can take advantage of these advices. I applied via Campus Placement and was interviewed before May 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. I have attended the interview as a fresher in Off-Campus event. Its all about academic project and what skills you possess at the moment of time.
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Prepare well about the points mentioned the resume and face the interviewer with confidence. Microsoft Corporation Interview FAQsHow many rounds are there in Microsoft Corporation Associate Consultant interview?Microsoft Corporation interview process usually has 2-3 rounds. The most common rounds in the Microsoft Corporation interview process are Technical, One-on-one Round and Coding Test.How to prepare for Microsoft Corporation Associate Consultant interview?Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Microsoft Corporation. The most common topics and skills that interviewers at Microsoft Corporation expect are microsoft, Intellectual Property, Operational Excellence, Presales and Project Planning.Tell us how to improve this page.
Microsoft Corporation Interviews By Designations
- Microsoft Corporation Software Engineer Interview Questions
- Microsoft Corporation Software Developer Interview Questions
- Microsoft Corporation Senior Software Engineer Interview Questions
- Microsoft Corporation Software Developer Intern Interview Questions
- Microsoft Corporation Intern Interview Questions
- Microsoft Corporation Technical Support Engineer Interview Questions
- Microsoft Corporation Software Development Engineer Interview Questions
- Microsoft Corporation Data Scientist Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Software Engineer Interview Questions
- Senior Associate Consultant Interview Questions
- Project Associate Interview Questions
- Associate Systems Engineer Interview Questions
- Associate Interview Questions
- Associate Technical Consultant Interview Questions
- Application Development Associate Interview Questions
- Senior Associate Interview Questions
- Show more
Microsoft Corporation Associate Consultant Interview Process
based on 2 interviews
Interview experience
View more
View allAssociate Consultant Interview Questions from Similar Companies
View allFast track your campus placements
31% more than the average Associate Consultant Salary in IndiaView more detailsMicrosoft Corporation Associate Consultant Reviews and Ratings
based on 13 reviews
Rating in categories
Explore 13 Reviews and Ratings
Explore more salariesSoftware Engineer 1.9k salaries
₹0 L/yr - ₹0 L/yr
Senior Software Engineer 1.1k salaries ₹0 L/yr - ₹0 L/yr
Software Engineer2 1k salaries ₹0 L/yr - ₹0 L/yr
Software Developer 695 salaries ₹0 L/yr - ₹0 L/yr
Consultant 602 salaries ₹0 L/yr - ₹0 L/yr
Compare Microsoft Corporation with
Google
CompareAmazon
CompareDeloitte
CompareTCS
ComparePopular CalculatorsDid you find this page helpful?Yes No- Home >
- Interviews >
- Microsoft Corporation Interview Questions >
- Microsoft Corporation Associate Consultant Interview Questions
Share an Interview
