Groupm Media Internship Trainee Interview Questions and Answers

Q1. Introduce yourself
Add your answer
Q2. Whats your role and responsibilities
Add your answer

Q1. How do you plan campaigns for your client
Add your answer
Q2. How to allocate budgets to a campaign?
Ans. 
Allocate budgets based on campaign goals, target audience, and channels.
• Identify campaign goals and objectives

• Understand target audience demographics and behaviors

• Allocate budget based on channels that reach target audience effectively

• Consider cost per acquisition (CPA) and return on investment (ROI)

• Monitor and adjust budget allocation based on campaign performance
Answered by AI
Add your answer

Q1. Dot net related stuffs
Add your answer
Q2. Dependency injection
Add your answer

Built an app using dot net and angular

Mails,for offboarding , Onboarding

Q1. About yourself, about company
Add your answer

Q1. Difference between union and union all in SQL?
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union combines result sets and removes duplicates

• Union All combines result sets 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 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. How to show top 5 in pandas?
Ans. 
To show top 5 in pandas, use the nlargest() function.
• Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

• For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.
Answered by AI
Add your answer

Q1. If we have 3 numerical columns, which chart is a better representation these column?
Ans. 
A scatter plot is a better representation for 3 numerical columns.
• Use a scatter plot to show the relationship between the numerical columns.

• Scatter plots are effective for visualizing correlations and patterns in data.

• Each point on the plot represents a data point with values from all 3 columns.
Answered by AI
Add your answer

Q1. Add and power bi related
Add your answer
Q2. Azure sql
Add your answer

Q1. Tell me about Projects done during course
Add your answer