TresVista Interview Questions, Process, and Tips

Included typical logical reasoning and problem solving questions, the test was for 1 hour

Q1. How many iphones are there in india
Ans. 
It is difficult to provide an exact number of iPhones in India as it constantly changes due to sales and imports.
• The number of iPhones in India can vary based on factors such as sales, imports, and upgrades.

• Apple does not typically release specific sales numbers for individual countries.

• One could estimate the number of iPhones in India by looking at market research reports or industry trends.
Answered by AI
Add your answer

Q1. Liters of water to fill a 4L jug with a 3L and 5L jug
Add your answer

First round was aptitude test

Q1. Current affairs and general knowledge
Add your answer

Q1. Are you ready to relocate
Add your answer
Q2. General accounting
Add your answer

Q1. Write me a query to get the last month's data and it only runs 1st of everymonth
Ans. 
Query to retrieve last month's data on the 1st of every month
• Use the DATEADD function to subtract a month from the current date

• Filter the results to only include data from the 1st of the month

• Example: SELECT * FROM table_name WHERE date_column = DATEADD(month, -1, DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))
Answered by AI
Add your answer

Medium level of questions across all sections of aptitude

Q1. Related to SQL and python Power BI dax questions Project related questions
Add your answer

Sql, python, power bi

Q1. Cte functions in sql
Ans. 
CTE functions in SQL are Common Table Expressions used to create temporary result sets for complex queries.
• CTEs are defined using the WITH keyword

• They can be referenced multiple times in a query

• They improve readability and maintainability of complex queries
Answered by AI
Add your answer
Q2. Power bi related questions
Add your answer

Q1. Salary negotiations
Add your answer
Q2. Salary expectation
Add your answer

The aptitude test contained word problems, logical reasoning, math questions and grammar related questions. Basic to mid level

Q1. Technical round was more around, 'why you wanna join the company', accounting and investment banking and private equity related questions. 'What is PE/IB'?, 'Explain the flow of transactions in the books o...read more
Add your answer

Q1. This was the final round with one of the VPs where again questions related to GAAP, Investment banking and accounting were asked. Questions such as ''Prepare a basic Cash Flow and Income Statement", "Line...read more
Add your answer