Carvana Business Analyst Interview Questions and Answers

Q1. Tell me about a project you faced difficulties?
Add your answer
Q2. Given a table ..asked some SQL questions
Add your answer

Q1. Shared a table ...asked to write some SQL queries
Add your answer
Q2. Sman queries result how to derive in excel
Ans. 
Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.
• Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.

• Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.

• Import SQL query results into Excel using data connection or copy-paste method.
Answered by AI
Add your answer

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

Q1. Different joins in sql
Ans. 
Different types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns all rows when there is a match in either table
Answered by AI
Add your answer

Q1. Something you have done beyond your duty in your previous job.
Add your answer

Casestudy relate dto ab testing

Sql tests on joins and emp database

Q1. Why do you want to switch
Ans. 
I am looking for new challenges and opportunities for growth in my career.
• Seeking opportunities to expand my skill set

• Interested in working on different projects and industries

• Want to learn new technologies and methodologies

• Desire for career advancement and professional development
Answered by AI
Add your answer
Q2. Why do you want to join flipkart?
Ans. 
I want to join Flipkart because of its innovative work culture and market leadership in the e-commerce industry.
• Impressed by Flipkart's innovative approach to e-commerce

• Excited about the opportunity to work in a market leader in the industry

• Interested in contributing to Flipkart's growth and success

• Appreciate Flipkart's focus on customer satisfaction and user experience
Answered by AI
Add your answer

Q1. Questions mostly focused on window functions like row_number and aggregate functions like group by there was also a question based on self-join.
Add your answer

Q1. Excel Test which had Pivot table creation and vlookups and countifs
Add your answer
Q2. Sql Questions based on joins
Add your answer

Sql joins and ranks and all

Q1. Tell about yourself
Add your answer
Q2. What is expected
Add your answer

SQL and Python Questions

Q1. SQL and case study question
Add your answer