Interview Questions

Nikunj V. - "OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are two types of data processing systems, each designed for specific purposes in the context of database and data warehouse environments. OLTP (Online Transaction Processing):Purpose: OLTP systems are designed to manage and handle high volumes of transactions, such as inserting, updating, and deleting data. These systems are typically used in day-to-day business operations. Characteristics: Handles small, si"See full answer

Ali H. - "SQL databases are relational, NoSQL databases are non-relational. SQL databases use structured query language and have a predefined schema. NoSQL databases have dynamic schemas for unstructured data. SQL databases are vertically scalable, while NoSQL databases are horizontally scalable."See full answer

Xash C. - "This one is a great example of Build, Borrow, or Buy strategy framework (http://www.build-borrow-buy.com/build-borrow-or-buy-in-practice/) - explore and evaluate three different approaches: organic growth and building a product from scratch (e.g. Amazon building its own Amazon Restaurants service), partnering with an existing provider (e.g. enterprise-level partnership with Instacart or Lyft), or acquisition growth (e.g. Uber acquiring Postmates). Evaluate which approach makes sense for the com"See full answer

shg - "In my experience, project success translates to three things: Customer Success => Quality increments to service leading to customer success. (Measure by KPIs like customer satisfaction score, SLA, Revenue growth etc) Team Success => High Team morale with successful execution and collaboration of project. Individual Success => Individual career goals and aspirations are met I think the later two are difficult are measured via KPIs. Although there can be indirect KPIs to measure those as we"See full answer

shg - "(This was not search autocomplete based on prefix matching question.) First of all, please note :- The interviewer is not expecting you to get to the right answer in just 1 hr. These systems have been designed over months and improved over years and its impractical for anyone to expect you to get to the right answer in 1 hr. (There is no one single right answer). At the end, the interviewer (director level person) told me the same. What they are looking for is your thought process, getting from"See full answer

Sayee M. - "depending on project phase, apply various methodologies. scrum for app dev, waterfall for data migration, Testing (TDD for dev, FUT FiT for manual, UAT) , OCM has it own methodology ."See full answer

Sayee M. - "i asked if she meant operations business analytics metrics.. she clarified that she meant operational/stability metrics.. i explained that i used dynatrace to monitor the product and she said i want to know about SLAs etc. she was looking for the words SLA SLO and SLI.. i then explained SLA 99.99% various SLO's contributed to it like system uptime, continous testing of business functions, and incident mgmt metrics."See full answer

Sayee M. - "talked about a time when customer is trying to go to cloud for first time and championing the effort.. it is strategic and also a risk because outside of the OEM, no one we know had implemented this product architecture on the cloud.. used first [principles, did a crawl, walk jog approach and implemented it. Risk because of lack of reference architecture, clodu tech was new to me . career making/breaking project for customer. result : project was successful. presented story in a conference."See full answer

Piya B. - "You are planning to start a grocery store. How many manual checkout and automated checkout aisles would you have? Clarify: Is this in an urban or a rural city ? For instance is this for NY, where population is 8m Densely populated? Not a franchise of walmart.or. A big brand Which means no restrictions? Approach This will definitely depend on my budget but also the target segment . For instance, for an older population, self checkout may not be very popular. Hence, I will be making some sweepi"See full answer

Caroline V. - "The answer likely depends on the objective, so I started out with what we were seeking to accomplish. Are we trying to eliminate under-utilized bills, save paper, reduce forgery, or something else? Establishing this focus enables you to dive deeper on the solution."See full answer

Aaron W. - "Clarification questions What is the purpose of connecting the DB? Do we expect high-volumes of traffic to hit the DB Do we have scalability or reliability concerns? Format Code -> DB Code -> Cache -> DB API -> Cache -> DB - APIs are built for a purpose and have a specified protocol (GET, POST, DELETE) to speak to the DB. APIs can also use a contract to retrieve information from a DB much faster than code. Load balanced APIs -> Cache -> DB **Aut"See full answer

Sangeeta P. - "Since I am residing in Bangalore, I will consider the Bengaluru airport. The airport has 2 terminals. I am going to consider the security scan done at both the terminals for the estimation. Does it include security scans for both international and domestic flights? --> Both The airport crew members and pilots also go through the security scan. So, should I include only them as well or only the passengers in my calculation? --> Only the passengers Number of people going through the security scan"See full answer

Kumaresh K. - "Provide me SAP ATTP consultant interview questions and answers"See full answer

Abdurhman M. - "Solving any problems related to Custemers profitable through new service or product offer"See full answer

Abdurhman M. - "For larger projects, companies will often hire project managers to plan, document, organize and oversee a project's life cycle, helping ensure projects are completed on time and on budget. However, due to limited resources such as limited budgets or personnel constraints, many teams function without a project manager."See full answer

David n. C. - "First of all, I would try to create and foster a good atmosphere. I will talk honestly with the team and I will expose my doubts openly in order to be transparent. I will talk calmly about my fears and I will ask for opinions. This way I will open the door of transparent communication."See full answer

Anonymous Shark - "The other team was depending on the outcome of the release we were working on, since the service end points could not be established, the other team had to reshuffle their plans, and had to plan for uncertainity."See full answer