Pennant Technologies Senior Business Analyst Interview Questions and Answers

Basic aptitude questions, statics, probability etc

Q1. Where do you live in the USA
Ans. 
I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.
• I reside in the heart of Manhattan, surrounded by towering skyscrapers.

• New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.

• The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.

• I enjoy exploring the diverse neighborhoods and ...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior data analyst leading a team, utilizing advanced analytics to drive strategic decision-making.
• Leading a team of data analysts

• Utilizing advanced analytics techniques

• Driving strategic decision-making

• Continuously learning and staying updated with the latest trends in data analysis
Answered by AI
Add your answer

Q1. Difference between Primary Key and Unique Key ?
Ans. 
Primary key uniquely identifies each record in a table, while Unique key allows only unique values but can have null values.
• Primary key enforces uniqueness and not null constraint on a column

• Primary key can consist of multiple columns

• Unique key allows only unique values but can have null values

• Unique key can be applied to multiple columns as well
Answered by AI
Add your answer

Sql, Python mcq test

Q1. Joins, Rank Dense Rank Rownumber, Window Function, Query to find 2nd highest salary
Add your answer

Q1. Why do you want to change job
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking for new challenges and opportunities for growth

• Interested in working in a more dynamic environment

• Seeking a change to further develop my skills and knowledge
Answered by AI
Add your answer
Q2. See yourself in 5yrs
Ans. 
In 5 years, I see myself as a seasoned Business Analyst leading cross-functional teams to drive strategic initiatives and deliver impactful solutions.
• Leading cross-functional teams to drive strategic initiatives

• Delivering impactful solutions to meet business objectives

• Continuing professional development to stay current with industry trends
Answered by AI
Add your answer

Q1. Basics of python, project related questions
Add your answer
Q2. Basic SQL, few simple problem solving questions
Add your answer

Q1. Interests, hobbies ,general HR questions
Add your answer
Q2. Expected hike, salary, work timings preferred
Add your answer

Q1. SQL and domain - Use case scenarios and real time examples
Ans. 
SQL is used in various domains for data analysis and reporting. Use cases include financial analysis, inventory management, and customer relationship management.
• Financial analysis - using SQL to analyze revenue, expenses, and profitability

• Inventory management - tracking stock levels, orders, and shipments

• Customer relationship management - analyzing customer data, preferences, and interactions
Answered by AI
Add your answer
Q2. SQL questions and domain related questions.
Add your answer

Q1. SQL Questions on Aggregations
Add your answer