Dentsu Aegis Network Senior Client Engagement Manager Interview Questions and Answers

Q1. What is rank in sql .. kind of scenario based
Add your answer
Q2. Examples of with/ sub query in sql
Ans. 
Using subqueries in SQL allows for more complex queries by nesting queries within other queries.
• Subquery in SELECT statement: SELECT column_name FROM table_name WHERE column_name = (SELECT column_name FROM table_name)

• Subquery in WHERE clause: SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM table_name)

• Subquery in FROM clause: SELECT column_name FROM (SELECT column_name FROM table_name) A
Answered by AI
Add your answer

Q1. Tell about work experience
Add your answer
Q2. Details about skill set
Add your answer

Q1. All questions were related to SQL and Context of the role
Add your answer
Q2. Joins, Unions and case scenario
Add your answer

Q1. How do you handle conflict between resources
Ans. 
I encourage open communication and collaboration to resolve conflicts and find mutually beneficial solutions.
• Encourage open communication and active listening

• Identify the root cause of the conflict

• Brainstorm potential solutions together

• Find a mutually beneficial solution

• Document the resolution and follow up to ensure success
Answered by AI
Add your answer
Q2. What challenges you faced and what’s your contribution , how did you handle
Add your answer

General grammar questions for checking the english proficiency of the candidates

Q1. You'll have a direct one on one with the elad and they will enquire about yourself and your skills, especially they will check your communication skills
Add your answer
Q2. What is Adobe and Office 365
Ans. 
Adobe and Office 365 are software suites commonly used for various business purposes.
• Adobe is a software suite used for graphic design, video editing, and web development.

• Office 365 is a cloud-based suite of productivity applications including Word, Excel, PowerPoint, and Outlook.

• Both Adobe and Office 365 are widely used in businesses for creating, editing, and sharing documents and multimedia content.
Answered by AI
Add your answer
Q3. Communication skills test
Add your answer

Q1. Questions regarding BA documentation and deliverables
Add your answer
Q2. Questions related to customer retention and loyalty bonuses.
Add your answer

Percentage,work and time

It can be related to a scenario which might be related to an organization who is looking to move into digital domain to sell their products, ask will be create a roadmap, program plan, proposed technology stack and budgeting.

Q1. Generic questions related to the role & responsibilities in current company Scenario based questions to understand customer handling capability, people management skills, risk management, communication ski...read more
Add your answer

Q1. Mostly VP or SVP round where they look at the candidate's communication skills and expression while talking in terms of confidence, articulation and presentation. This is the time when you can again call o...read more
Add your answer