Vertex Data Associate Interview Questions and Answers

Q1. Using sql extract substring of name
Ans. 
Using SQL to extract substring of name
• Use the SUBSTRING function in SQL to extract a specific portion of a string

• Specify the starting position and length of the substring to be extracted

• Example: SELECT SUBSTRING('John Doe', 1, 4) AS First_Name will return 'John'
Answered by AI
Add your answer
Q2. Using sql print cummulative sum of sales
Ans. 
Use SQL to print cumulative sum of sales
• Use the SUM() function to calculate the cumulative sum of sales

• Utilize the OVER() clause with ORDER BY to specify the order of the cumulative sum

• Example: SELECT date, sales, SUM(sales) OVER (ORDER BY date) AS cumulative_sales FROM table_name
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. Behaviural Questions
Add your answer

Q1. Tableau Desktop Technical
Add your answer

Q1. About your self
Add your answer

17 questions including mcq, case study, sql coding

Q1. 10 quiz about ML questions, case study
Add your answer

Good and not that much difficult

Q1. Good, interview was gone very smooth and you should know about what you mentioned in resume
Add your answer

Q1. They will ask about personal information and inform you about your role
Add your answer

Tableau Developer

I was given an assignment where I had to build dashboard with final story within 1 hour

Q1. Why Novo? Why this role?
Add your answer

Q1. Director Round with department head
Add your answer

Q1. Affiliate Round with either US folks or Denmark folks
Add your answer

Q1. What is your family background?
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. Tell me about yourself.
Add your answer
Q4. What are your salary expectations?
Add your answer

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.