Cohesity Data Engineer Interview Questions and Answers

Q1. Basic Question of mySQL like inner join,left join,right join,outer join.
Add your answer
Q2. Windows function in MySQL and Basic DSA question on implementation of heap sort
Add your answer

Q1. Explain the project you are working on.
Add your answer
Q2. A code on python, strings.
Add your answer
Q3. Two tables given and asked how many outputs will you get if you apply inner joim
Add your answer
Q4. Versioning in aws
Ans. 
Versioning in AWS allows you to manage different versions of your resources.
• AWS S3 supports object versioning to keep multiple versions of an object in the same bucket.

• AWS Lambda supports versioning to manage different versions of your functions.

• AWS API Gateway supports versioning to manage different versions of your APIs.
Answered by AI
Add your answer
Q5. Redshift related questions
Add your answer

Q1. What are cyclic linked lists
Ans. 
Cyclic linked lists are linked lists where the last node points back to the first node, creating a loop.
• Cyclic linked lists have no NULL pointers, making it difficult to determine the end of the list.

• They can be used to efficiently represent circular data structures like a round-robin scheduling algorithm.

• Detecting cycles in a linked list can be done using Floyd's cycle-finding algorithm.
Answered by AI
Add your answer
Q2. Coding question from BST
Add your answer

Q1. About data modelling and Architecture
Add your answer
Q2. Real world problem and solution
Ans. 
Real world problem: Predicting customer churn in a subscription-based service
• Collect and analyze customer data such as usage patterns, demographics, and interactions

• Use machine learning algorithms to identify factors leading to churn

• Implement targeted retention strategies based on the analysis

• Monitor and evaluate the effectiveness of the strategies over time
Answered by AI
Add your answer

Q1. Sql technical round
Add your answer
Q2. About various azure services
Add your answer

Q1. About my work area
Add your answer
Q2. Managerial and company fit
Add your answer

Q1. Project discussion
Add your answer
Q2. SQL
Add your answer

Test kn logical reasons , date time , train , relationship questions.

Basic python questions

Sql queries not too difficult asked to write on google document.

Q1. It’s was for contractual position and had only one round which is technical and HR combined
Add your answer

It was Python coding and Sql query assessment round.

Q1. Perform task on joins?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Use JOIN keyword to combine tables based on a common column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer
Q2. Explain projects
Ans. 
Projects are specific tasks or assignments that require a set of skills and resources to complete.
• Projects are temporary endeavors with a defined beginning and end.

• They are unique, with specific goals, deliverables, and constraints.

• Projects require a team of individuals with different roles and responsibilities.

• Examples: Developing a data pipeline for real-time analytics, building a recommendation system for an e-comme
Answered by AI
Add your answer