Yamaha Motors Solutions SDE Interview Questions and Answers

MCQ based on c++ and java

Solve 5 DSA questions

Q1. 1. Buy and sell stocks 2. String balance 3. Storing algo
Add your answer
Q2. String balance questions and String manipulation
Add your answer
Q3. Sorting algorithms and their implementations
Ans. 
Sorting algorithms are used to arrange elements in a specific order.
• Common sorting algorithms include bubble sort, selection sort, insertion sort, merge sort, quick sort, and heap sort.

• Each sorting algorithm has its own time complexity and space complexity.

• Sorting algorithms can be implemented in various programming languages such as C++, Java, Python, etc.
Answered by AI
Add your answer

Q1. All employees having same salary in the smae department sql and pysprk
Add your answer
Q2. How to create pipeline in databricks
Ans. 
To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.
• Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

• Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

• Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.
Answered by AI
Add your answer
Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...read more
Add your answer
Q4. String manuplation questions inpython
Add your answer

Q1. Java questions and data engineering
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Two coding questions

Q1. DBMS questions, keys
Add your answer
Q2. SQL related queries
Add your answer

Q1. SQL questions on performance tuning, some programming practices to ensure bug free code
Add your answer

Q1. Testing concepts STLC
Add your answer
Q2. Java code to reverse a string
Ans. 
Java code to reverse a string
• Use StringBuilder class to reverse the string

• Call reverse() method on the StringBuilder object

• Convert the StringBuilder object back to String using toString() method
Answered by AI
Add your answer

Q1. Agile concepts like sprints planning and Jira
Add your answer

Coding test was bad. they asked irrelevant things that were not related to the field

Q1. What is data engineering
Ans. 
Data engineering is the process of designing, building, and maintaining the infrastructure for data storage and processing.
• Data engineering involves creating and managing data pipelines

• It includes tasks such as data modeling, data integration, and data warehousing

• Data engineers work with big data technologies such as Hadoop, Spark, and NoSQL databases

• They also ensure data quality, security, and scalability

• Examples of d...read more
Answered by AI
Add your answer
Q2. What is resilient distributed database
Ans. 
A resilient distributed database is a database that can continue to function even if some of its nodes fail.
• It is designed to be fault-tolerant and highly available.

• Data is distributed across multiple nodes to ensure redundancy.

• If one node fails, the database can continue to function using data from other nodes.

• Examples include Apache Cassandra, Riak, and HBase.
Answered by AI
Add your answer