WhatsApp Analyst Interview Questions and Answers

Questions about python, r language, sql, c language, c++ are asked..

Q1. What is hight level programming language
Ans. 
High level programming languages are designed to be easily understood by humans and are closer to natural language.
• High level languages are more abstract and do not require knowledge of the computer's hardware.

• They are easier to read, write, and maintain compared to low level languages.

• Examples include Python, Java, C++, and Ruby.
Answered by AI
Add your answer
Q2. Why python language is so popular?
Ans. 
Python is popular due to its simplicity, readability, versatility, and strong community support.
• Easy to learn and use, with simple syntax and readability.

• Versatile language used in web development, data analysis, artificial intelligence, etc.

• Strong community support with a large number of libraries and frameworks available.

• Cross-platform compatibility allows code to run on different operating systems.

• Dynamic typing and...read more
Answered by AI
Add your answer

Coding round for analysing programming capabilities and skills.

Q1. Technical round comprise of SQL, Database and Analytics related scenario based questions.
Add your answer

Ok .first time asked me to write a code

Q1. Name of you hdu
Add your answer
Q2. Okay. It's all right
Add your answer

Q1. Asked some questions
Add your answer
Q2. Okay.its all right
Add your answer

Assessment was difficult

Q1. Tell me the difference between having and group by sql
Ans. 
GROUP BY is used to group rows that have the same values into summary rows, while HAVING is used to filter groups based on a specified condition.
• GROUP BY is used with aggregate functions to group the result-set by one or more columns.

• HAVING is used to filter groups based on a specified condition after the GROUP BY clause.

• HAVING is used with aggregate functions to filter the result-set based on a condition.

• Example: SELE...read more
Answered by AI
Add your answer
Q2. What are the variables?
Ans. 
Variables are factors that can change or be manipulated in a scientific experiment or study.
• Variables can be independent (manipulated by the researcher) or dependent (affected by the independent variable).

• Control variables are kept constant to ensure they do not affect the outcome of the study.

• Examples of variables include age, gender, temperature, time, and dosage.
Answered by AI
Add your answer

Q1. Behavioral round
Add your answer
Q2. Same again questions
Add your answer

General assesment, grammar, vocabulary

Q1. SQL and Python basic level
Add your answer
Q2. Sql problems regarding joins and window function
Ans. 
Understanding SQL problems related to joins and window functions
• Ensure you understand the different types of joins (inner, outer, left, right)

• Know how to use window functions like ROW_NUMBER(), RANK(), and PARTITION BY

• Practice writing queries that involve multiple tables and window functions
Answered by AI
Add your answer

Q1. Normal questions
Add your answer

Q1. Introduction to myself
Add your answer
Q2. Softskill and communication
Add your answer

Q1. Why Amazon ? What makes you motivated to join it?
View 1 more answer
Q2. What is your biggest mistake and what did you learn from it?
Add your answer
Q3. Which Leadership principle do you follow in your life?
Add your answer

Q1. What are shortterm liabilities.
Ans. 
Short-term liabilities are debts or obligations that are due within one year.
• Short-term loans

• Accounts payable

• Accrued expenses

• Short-term portion of long-term debt
Answered by AI
Add your answer