Asper AI Interview Questions and Answers

Q1. Coalesce, SQL Order of Execution
Add your answer
Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
Ans. 
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
• Write a SQL query to count number of reportees for each manager using GROUP BY clause

• Add HAVING clause to filter out managers with atleast 5 reportees

• Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Answered by AI
Add your answer
Q3. How to manage large datasets in python
Ans. 
Use libraries like pandas and dask to efficiently manage large datasets in Python.
• Use pandas library for data manipulation and analysis.

• Use dask library for parallel computing and out-of-core processing.

• Optimize memory usage by loading data in chunks or using data types efficiently.

• Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Answered by AI
Add your answer
Q4. Name few of the commonly used python libraries used by DA
Ans. 
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
• Pandas - used for data manipulation and analysis

• NumPy - used for numerical computing and working with arrays

• Matplotlib - used for data visualization

• Scikit-learn - used for machine learning and data mining
Answered by AI
Add your answer

Q1. Scenario based leadership questions
Add your answer
Q2. Revenue, margin, leadership skills
Add your answer
Q3. Conflict management, stakeholder management
Add your answer

Q1. Portfolio management
Add your answer
Q2. CI CD pipeline based questions, some other technical questions
Add your answer
Q3. Stakeholder management, project metrics, leadership, team upskilling, resource management, risk management
Add your answer

Q1. Solution architecture questions scenario based
Add your answer
Q2. DR activity scenario based questions
Add your answer

Q1. Cultural fit related
Add your answer
Q2. Leadership and team handling related questions
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced Senior Product Manager with a background in tech industry and a passion for driving product innovation.
• Over 8 years of experience in product management roles

• Strong background in the tech industry, with a focus on software development

• Proven track record of successfully launching and managing products from concept to market

• Passionate about driving product innovation and improving user experiences

• Skilled in cr...read more
Answered by AI
Add your answer
Q2. Aptitude Question
Add your answer

Q1. Experience Questions
Add your answer
Q2. Hobbies and Passion
Add your answer

Q1. Assignment Round with Review at the end
Add your answer
Q2. Pitch GoComet to the founder
Add your answer

C and Golang related questions, 2 Hours assement, The test involved writing code by hand in paper in the office (Bengaluru)

Q1. Write a go code to remove duplicate elements from a slice.
Ans. 
Go code to remove duplicate elements from a slice of strings
• Use a map to keep track of unique elements

• Iterate over the slice and add elements to the map

• Create a new slice with unique elements from the map
Answered by AI
Add your answer
Q2. Difference between array and slice in Go.
Ans. 
Arrays have fixed length, slices are dynamic and can grow/shrink. Slices are references to arrays.
• Arrays have fixed length, specified at compile time.

• Slices are dynamic, can grow or shrink at runtime.

• Slices are references to arrays, allowing for more flexibility.

• Example: var arr [3]string // array with fixed length of 3

• Example: slice := make([]string, 0) // slice with dynamic length
Answered by AI
Add your answer
Q3. Explain struct and interface
Ans. 
Struct is a user-defined data type that groups related data fields together. Interface defines a set of methods that a type must implement.
• Struct is used to create complex data structures by grouping related data fields together.

• Interface defines a set of methods that a type must implement. It allows for polymorphism in Go.

• Example: type Person struct { Name string; Age int }

• Example: type Shape interface { Area() float6...read more
Answered by AI
Add your answer
Q4. What is containerization.
Ans. 
Containerization is a method of packaging, distributing, and running applications in isolated environments called containers.
• Containers are lightweight, portable, and can run on any platform that supports containerization.

• They include everything needed to run the application, such as code, runtime, system tools, libraries, and settings.

• Popular containerization tools include Docker, Kubernetes, and Podman.

• Containerizati...read more
Answered by AI
Add your answer
Q5. Write a go code to implement struct.
Ans. 
Implementing a struct in Go code
• Define a struct using the 'type' keyword

• Add fields to the struct with their respective data types

• Access struct fields using dot notation
Answered by AI
Add your answer
Q6. Explain goroutine.
Ans. 
Goroutine is a lightweight thread managed by Go runtime, allowing concurrent execution of functions.
• Goroutines are created using the 'go' keyword in Go programming language.

• They are more lightweight than threads and are managed by the Go runtime.

• Goroutines allow for concurrent execution of functions without the need for manual thread management.

• Example: go myFunction()

• Example: go func() { // code here }
Answered by AI
Add your answer
Q7. How do you achieve concurrency in Go?
Ans. 
Concurrency in Go is achieved using goroutines and channels.
• Use goroutines to run functions concurrently

• Communicate between goroutines using channels

• Avoid using shared memory for synchronization
Answered by AI
Add your answer
Q8. What is channel in Go? What are the differences between buffered and unbuffered channel?
Ans. 
A channel in Go is a communication mechanism that allows goroutines to communicate with each other.
• Buffered channels have a specific capacity and can send multiple values without the need for a corresponding receive operation immediately.

• Unbuffered channels have no capacity and require both a send and receive operation to be ready at the same time for communication to occur.
Answered by AI
Add your answer
Q9. What is scaling? Horizontal and vertical scaling.
Ans. 
Scaling refers to the ability of a system to handle increasing amounts of work or its potential to accommodate growth.
• Horizontal scaling involves adding more machines to distribute the load, while vertical scaling involves increasing the resources of a single machine.

• Horizontal scaling is more cost-effective and provides better fault tolerance, but can be more complex to implement.

• Vertical scaling is simpler to impleme...read more
Answered by AI
Add your answer

1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.

Q1. Python code was asked for checking the anagrams
Add your answer
Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
Add your answer

Q1. Python code was asked for swaping any number but without using python libraries
Add your answer
Q2. Sql code was asked using concepts of rank dense,rank, partition by
Add your answer