Advist Global Interview Questions and Answers

Q1. To know basic details about my profile, if I match the profile criteria and company matches my expectations.
Add your answer

There was a task provided to me for the role and I had to submit it within the provided timeline.

Q1. It was more related to my assignment, skills, and past experience. Situations I handled in the past. More of a practical round.
Add your answer

Q1. Final discussion round.
Add your answer

Q1. Are you planning pregnancy?
Ans. 
It is not appropriate to ask about pregnancy in a job interview as it is a personal matter.
• Politely redirect the conversation back to your qualifications and experience

• Explain that personal matters such as family planning are not relevant to the job

• Express that you are focused on your career and committed to your work
Answered by AI
Add your answer
Q2. Are you comfortable working late nights?
Add your answer

Q1. SQL Window Functions and RANK, DENSE RANK Difference
Ans. 
SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.
• RANK function assigns a unique rank to each distinct row within a partition.

• DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.

• Both functions are used with the OVER() clause in SQL to define the partition and order of rows.
Answered by AI
Add your answer
Q2. Hadoop Default Replication Factor
Add your answer

Q1. At Moris Media, we create for a wide range of clients. How would you adapt your motion graphics style to resonate with a target audience of young children versus senior citizens?
Ans. I understand the importance of tailoring visuals to specific demographics. For children, I'd use bright colors, simple shapes, and playful animation. For seniors, I'd focus on clear communication, slower pacing, and high-contrast visuals for better readability
Answered by Linkedin User
Add your answer
Q2. You're given tight deadlines and limited resources for a project. How do you ensure high-quality motion graphics are still delivered?
Ans. Effective communication is key. I'd collaborate with the team to prioritize elements and suggest time-saving techniques like pre-made assets or animation libraries. My experience allows me to work efficiently while maintaining quality
Answered by Linkedin User
Add your answer
Q3. Describe a situation where you had to collaborate with a team member whose design vision differed from yours. How did you navigate this?
Ans. Open communication is crucial. I'd actively listen to their ideas, present my perspective, and find common ground. Perhaps by sketching variations or creating mood boards, we could reach a solution that incorporates both visions
Answered by Linkedin User
Add your answer
Q4. How do you stay up-to-date with the latest trends and software in motion graphics?
Add your answer
Q5. I actively follow industry publications, attend online workshops, and participate in online communities. I'm also a quick learner and eager to experiment with new software to stay ahead of the curve
Add your answer
Q6. Moris Media creates video content with live-action integration. Describe your experience, or how you'd approach learning, this aspect of motion design.
Ans. 
I have extensive experience in creating video content with live-action integration, including working on various projects that required this skill.
• I have worked on projects where I had to seamlessly integrate live-action footage with motion graphics to create engaging videos.

• I am familiar with techniques such as rotoscoping, green screen keying, and compositing to blend live-action and motion graphics effectively.

• I sta...read more
Answered by AI
View 1 more answer

Q1. Reasons for the drop in CPM
Ans. 
Possible reasons for drop in CPM include seasonality, changes in ad inventory, shifts in audience demographics, and increased competition.
• Seasonal fluctuations in advertising demand

• Changes in available ad inventory

• Shifts in audience demographics affecting targeting effectiveness

• Increased competition leading to lower bids
Answered by AI
Add your answer
Q2. Types of floor in GAM
Ans. 
Types of floors in GAM include carpet, hardwood, tile, and laminate.
• Carpet

• Hardwood

• Tile

• Laminate
Answered by AI
Add your answer

Q1. Do u know video editing
Ans. 
Yes, I have experience with video editing using tools like Adobe Premiere Pro and Final Cut Pro.
• Proficient in using video editing software such as Adobe Premiere Pro and Final Cut Pro

• Experience in editing videos for various projects including short films, promotional videos, and social media content

• Knowledge of video effects, transitions, color correction, and audio editing

• Familiarity with video formats and exporting o
Answered by AI
Add your answer
Q2. Do u know image processing
Ans. 
Yes, I have experience with image processing in Python.
• I have used libraries like OpenCV and PIL to manipulate and analyze images.

• I have worked on tasks like image enhancement, object detection, and image segmentation.

• I am familiar with techniques like edge detection, image filtering, and feature extraction.

• I have implemented image processing algorithms for various projects.

• I have experience with handling different ima...read more
Answered by AI
Add your answer

Software testing and coding related questions

Programming test coding

Q1. Myself intro HR subject question with answer
Add your answer
Q2. Subject related questions
Add your answer
Q3. What is types software testing
Ans. 
Types of software testing include unit testing, integration testing, system testing, and acceptance testing.
• Unit testing focuses on testing individual components or modules of the software.

• Integration testing involves testing how different modules work together.

• System testing checks the entire system as a whole.

• Acceptance testing ensures that the software meets the requirements of the end users.
Answered by AI
View 1 more answer
Q4. What is unit testing
Ans. 
Unit testing is a software testing method where individual units or components of a software are tested in isolation.
• Unit testing helps in identifying bugs early in the development process.

• It ensures that each unit of code is working as expected.

• Unit tests are automated and can be run frequently to catch regressions.

• Mocking and stubbing are often used in unit testing to isolate the unit being tested.

• Example: Testing a ...read more
Answered by AI
Add your answer
Q5. What is integration testing
Ans. 
Integration testing is testing the interactions between different components/modules of a software system.
• Tests how well different parts of the system work together

• Ensures that data flows correctly between components

• Identifies any issues with communication or data transfer

• Examples: testing API integrations, testing database connections
Answered by AI
Add your answer
Q6. What is types of software testing
Ans. 
Types of software testing include unit testing, integration testing, system testing, and acceptance testing.
• Unit testing focuses on testing individual components or modules of the software.

• Integration testing involves testing the interactions between different components/modules.

• System testing tests the entire system as a whole.

• Acceptance testing is performed to validate if the software meets the requirements of the st
Answered by AI
Add your answer
Q7.  What is integration testing
Ans. 
Integration testing is testing the interactions between different components or systems to ensure they work together correctly.
• Integration testing verifies that different modules or components of a software work together as expected.

• It focuses on testing the interfaces and interactions between components.

• Examples include testing the integration between a front-end user interface and a back-end database, or between diff
Answered by AI
Add your answer

Q1. Myself and education
Add your answer
Q2. Experience of previous companies
Add your answer