Saras Analytics Senior Business Analyst Interview Questions, Process, and Tips

Q1. SQL: What is the difference between UNION and UNION ALL?
Ans. 
UNION combines and removes duplicates, UNION ALL combines without removing duplicates
• UNION merges the result sets of two or more SELECT statements and removes duplicates

• UNION ALL merges the result sets of two or more SELECT statements without removing duplicates

• UNION is slower than UNION ALL as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FR
Answered by AI
Add your answer
Q2. SQL: What is the difference between HAVING and WHERE? Can WHERE be replaced with HAVING?
Ans. 
HAVING is used with GROUP BY to filter grouped rows, WHERE is used to filter individual rows. WHERE cannot be replaced with HAVING.
• WHERE is used to filter individual rows before grouping, HAVING is used to filter grouped rows after grouping

• HAVING is used in conjunction with GROUP BY clause, WHERE is used independently

• WHERE filters rows based on conditions, HAVING filters groups based on conditions

• Example: SELECT depart...read more
Answered by AI
Add your answer
Q3. Aptitude: There are 2 jugs: one measures 7L and another measures 11L. How do you measure 15L?
Add your answer
Q4. Guesstimate: How many ballons can fill in an aeroplane?
Ans. 
The number of balloons that can fill an airplane depends on the size of the airplane and the size of the balloons.
• The size of the airplane (e.g. small private plane vs. commercial airliner) will greatly impact the number of balloons that can fit.

• The size of the balloons (e.g. standard party balloons vs. large weather balloons) will also affect the total number that can be accommodated.

• Consider the available space insid...read more
Answered by AI
Add your answer

The position is for SBA but they expect you to be as good as developer in coding. They want someone as good as developer but they don't call him/her as developer and give the designation as BA which I did not like. No questions regarding BA or PM or any Agile or waterfall methodologies 3 rounds every thing about coding (SQL, Python, ) and tools like Alteryx, AWS glue