Acquia Senior Software Engineer Interview Questions and Answers

Q1. Types of filters
Ans. 
Types of filters include low-pass, high-pass, band-pass, and band-stop filters.
• Low-pass filter allows frequencies below a certain cutoff frequency to pass through.

• High-pass filter allows frequencies above a certain cutoff frequency to pass through.

• Band-pass filter allows a specific range of frequencies to pass through.

• Band-stop filter blocks a specific range of frequencies from passing through.
Answered by AI
Add your answer

Q1. Project Details
Add your answer

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Q1. Confidential to disclose
Add your answer

Q1. Confidential not to disclose
Add your answer

Q1. Confidential not to disclose
Add your answer

Q1. SQL query to join 3 tables
Ans. 
Use SQL JOIN to combine data from 3 tables based on a common key.
• Use INNER JOIN, LEFT JOIN, or RIGHT JOIN depending on the desired result

• Specify the columns to select from each table

• Use ON clause to specify the join condition
Answered by AI
Add your answer
Q2. Spring boot annotations
Add your answer
Q3. Hibernate annotations
Add your answer
Q4. Java 8 Streams + Lambda
Add your answer

Q1. Working style: Independent contributor or Team
Add your answer
Q2. Are green-field projects alright?
Ans. 
Green-field projects are great opportunities to start fresh and implement new technologies.
• Green-field projects allow for creative freedom and innovation

• They provide the opportunity to work with the latest technologies and tools

• Starting from scratch can lead to cleaner code and better architecture

• Examples: Developing a new mobile app, creating a new website from scratch
Answered by AI
Add your answer
Q3. Are you ok with learning new tech stacks?
Add your answer

Q1. Sql question, joins , store procedure
Add your answer
Q2. Mvc question, mvc frame work
Add your answer

I had to evaluate a software and let them understand where this software could be implemented and the pros and cons of the software.

Q1. There was simple DSA question ,
Add your answer

Q1. What is dependency injection in laravel
Ans. 
Dependency injection in Laravel is a technique to manage class dependencies and improve code flexibility.
• Dependency injection allows for easier testing and maintenance of code.

• It involves passing dependencies to a class through its constructor or method parameters.

• Laravel's container class manages the dependencies and resolves them when needed.

• Example: injecting a database connection into a repository class.

• Can also us...read more
Answered by AI
View 1 more answer
Q2. How do you find the second largest number in a coulmn in mySQL
Ans. 
To find the second largest number in a column in MySQL, you can use the ORDER BY and LIMIT clauses.
• Write a SELECT statement to retrieve the column values in descending order using ORDER BY.

• Use the LIMIT clause to limit the result set to the second row.

• The value in the second row will be the second largest number in the column.
Answered by AI
View 1 more answer

Q1. What do you know about magic Edtech
Ans. 
Magic Edtech is an innovative educational technology company.
• Magic Edtech develops interactive learning platforms and tools.

• They use advanced technologies like AI, AR, and VR to enhance the learning experience.

• Their products include virtual classrooms, adaptive learning systems, and educational games.

• Magic Edtech focuses on personalized learning and data-driven insights.

• They collaborate with schools, universities, and
Answered by AI
View 1 more answer
Q2. What was the most challenging task you faced and how you overcame it
Add your answer