Stealth ml engineer Interview Questions and Answers

3 simple coding questions

Q1. Merge sort with list
Ans. 
Merge sort is a divide and conquer algorithm that recursively divides the input array into smaller subarrays, sorts them, and then merges them back together.
• Divide the input list into two halves

• Recursively apply merge sort to each half

• Merge the sorted halves back together
Answered by AI
Add your answer
Q2. Similar to coin exchange DP
Add your answer
Q3. SQL query medium level
Add your answer

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Q1. WAP to check occurrence of words in a paragraph.
Ans. 
A program to check the occurrence of words in a paragraph.
• Split the paragraph into words using space as delimiter

• Create a hashmap to store word frequencies

• Iterate through the words and update the hashmap accordingly

• Display the word frequencies
Answered by AI
Add your answer
Q2. What git command do you use incase PR build is failed

Ans. 

Use git bisect command to find the commit that caused the build failure

• Use 'git bisect start' to start the bisect process

• Mark the current commit as bad with 'git bisect bad'

• Mark a known good commit with 'git bisect good '

• Git will automatically checkout commits for testing, mark them as good or bad until the culprit commit is found

Add your answer