Amazon BI Engineer Interview Questions and Answers

Hackerrank Coding Test, Leetcode medium questions

HLD test, was asked to design an online coding platform like leetcode

Q1. Most interesting project you have worked on
Add your answer
Q2. How do you handle conflict at workplace
Add your answer

Q1. Find the leaves of the tree.
Ans. 
Leaves of a tree are the nodes with no children in a tree data structure.
• Traverse the tree and identify nodes with no children.

• Use depth-first search or breadth-first search algorithms to find leaves.

• Examples: In a binary tree, leaves are nodes with no left or right child.

• In a general tree, leaves are nodes with no children in their child list.
Answered by AI
Add your answer
Q2. Find the LCA of tree.
Ans. 
The Lowest Common Ancestor (LCA) of a tree is the shared ancestor of two nodes farthest from the root.
• Start from the root and traverse the tree to find the paths from the root to the two nodes.

• Compare the paths to find the last common node between them, which is the LCA.

• If one of the nodes is an ancestor of the other, then the ancestor node is the LCA.
Answered by AI
Add your answer

Q1. What projects you worked upon?
Ans. 
I have worked on projects involving web development, mobile app development, and data analysis.
• Developed a web application using React and Node.js for a client in the e-commerce industry

• Created a mobile app using Flutter for a startup in the healthcare sector

• Performed data analysis on customer behavior using Python and SQL for a marketing company
Answered by AI
Add your answer
Q2. What internships you did?
Ans. 
I completed internships at ABC Company and XYZ Company during my undergraduate studies.
• Interned at ABC Company working on web development projects

• Interned at XYZ Company assisting with software testing and quality assurance

• Gained hands-on experience in coding, debugging, and problem-solving
Answered by AI
Add your answer

1 hour on data structures and algorithms

Q1. Build Netflix architecture
Ans. 
Netflix architecture is a scalable microservices-based system with a focus on high availability and performance.
• Use microservices architecture to break down the system into smaller, independent services

• Implement a content delivery network (CDN) for efficient content distribution

• Utilize cloud services like AWS for scalability and reliability

• Implement a recommendation engine for personalized content suggestions

• Use a dist...read more
Answered by AI
Add your answer

Some database questions,some java questions .

Q1. What is the difference between javascript and jQuery.
Ans. 
JavaScript is a programming language used for web development, while jQuery is a library built with JavaScript to simplify HTML document traversal and manipulation.
• JavaScript is a programming language, while jQuery is a library written in JavaScript.

• JavaScript can be used for a wide range of tasks, while jQuery is mainly used for DOM manipulation and event handling.

• JavaScript is a core technology for web development, w...read more
Answered by AI
Add your answer
Q2. Define different types of join
Ans. 
Different types of joins are used in SQL to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full ...read more
Answered by AI
Add your answer
Q3. Define multithreading concept and exception handling.
Ans. 
Multithreading allows multiple threads to run concurrently, while exception handling deals with errors in a program.
• Multithreading involves running multiple threads simultaneously to improve performance and responsiveness.

• Threads share the same memory space but have their own program counter and registers.

• Exception handling is a mechanism to handle errors or exceptional situations in a program.

• It helps prevent the prog...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Got a leetcode easy question

Online assessment, leet code easy

Live coding assessment, leet code medium

Behavioral asking on past experience

Implement an iterator to flatten 2D vector

Q1. Find shortest path to get all keys
Ans. 
Use Dijkstra's algorithm to find the shortest path to get all keys
• Implement Dijkstra's algorithm to find the shortest path in a graph

• Consider the keys as nodes in the graph and the paths between keys as edges

• Keep track of the keys collected and update the shortest path accordingly
Answered by AI
Add your answer