Aureus Analytics Interview Questions and Answers

Q1. Rate yourself in js, node js, react, MongoDB (separately)
Add your answer
Q2. Typeof null, typeof undefined, typeof {}, typeof NaN
Add your answer
Q3. What changes came in es6
Ans. 
ES6 introduced several new features and improvements to JavaScript, making it more powerful and efficient.
• Arrow functions for more concise syntax

• Let and const for block-scoped variables

• Classes for easier object-oriented programming

• Template literals for easier string interpolation

• Default parameters and rest parameters for function arguments

• Destructuring assignment for easier data extraction

• Promises for asynchronous prog
Answered by AI
Add your answer
Q4. This keyword, closures, hoisting
Add your answer
Q5. Are let and cont variables hoisted?
Ans. 
Yes, let and const variables are hoisted but not initialized.
• let and const variables are hoisted to the top of their block scope, but they are not initialized until the actual line of code is executed.

• This means that you cannot access a let or const variable before it is declared in the code.

• For example, trying to access a let variable before it is declared will result in a ReferenceError.
Answered by AI
Add your answer
Q6. What is global context
Ans. 
Global context refers to the overall environment or setting in which something exists or operates.
• Global context encompasses all variables, functions, and objects that are accessible throughout an entire program.

• It can be thought of as the 'big picture' view of a program's execution.

• In web development, global context includes the window object in JavaScript.
Answered by AI
Add your answer
Q7. What is temporal deadzone
Ans. 
Temporal dead zone is a period during the variable creation process where accessing the variable results in a ReferenceError.
• Occurs when trying to access a variable before it has been declared with let or const

• Happens due to the variable being in the temporal dead zone until it is declared

• Example: accessing a variable before its declaration will result in a ReferenceError
Answered by AI
Add your answer
Q8. What is modules? types of modules in nodejs
Ans. 
Modules in Node.js are reusable blocks of code that encapsulate related functionality.
• Modules in Node.js can be built-in modules like fs (file system) or third-party modules like express.

• Modules help in organizing code into separate files for better maintainability and reusability.

• Modules can be imported using the require() function in Node.js.
Answered by AI
Add your answer
Q9. Index in mongodb, why we need index, is index good or bad?
Ans. 
Indexes in MongoDB improve query performance by allowing the database to quickly locate and retrieve specific documents.
• Indexes help to speed up query performance by allowing the database to quickly locate specific documents based on the indexed fields.

• Without indexes, MongoDB would have to perform a collection scan, which can be slow and resource-intensive.

• Indexes can be created on single fields or compound fields to ...read more
Answered by AI
Add your answer
Q10. What are hooks , use of useRef
Ans. 
Hooks are a feature in React that allow you to use state and other React features in functional components. useRef is a hook that allows you to create a mutable object that persists for the lifetime of the component.
• Hooks are used to add state and lifecycle methods to functional components in React

• useRef is used to create a mutable reference that persists between renders

• useRef can be used to access DOM elements directl
Answered by AI
Add your answer
Q11. Fs module, http module, worker thread?
Add your answer
Q12. Why we use mongoose not mongodb driver?
Ans. 
Mongoose is an Object Data Modeling (ODM) library for MongoDB that provides a higher level of abstraction and simplifies interactions with the database.
• Mongoose provides schema validation which helps maintain data integrity.

• Mongoose simplifies querying and data manipulation with built-in functions.

• Mongoose supports middleware functions for pre and post processing of data operations.
Answered by AI
Add your answer

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

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

Q1. Reverse the string and find occurance of character in java
Ans. 
To reverse a string and find the occurrence of a character in Java.
• Use StringBuilder to reverse the string.

• Use a loop to iterate through the string and count the occurrences of the character.

• Use the charAt() method to access individual characters in the string.
Answered by AI
Add your answer
Q2. Write screenshot script in selenium
Ans. 
To take a screenshot in Selenium, use the getScreenshotAs method
• Create a WebDriver instance

• Use the getScreenshotAs method to capture the screenshot

• Save the screenshot to a file using File class
Answered by AI
Add your answer
Q3. Write getter an setter method
Ans. 
Getter and setter methods are used to access and modify the values of private variables in a class.
• Create a method with the prefix 'get' followed by the variable name to retrieve its value.

• Create a method with the prefix 'set' followed by the variable name to set its value.

• Ensure the getter method returns the value of the variable and the setter method updates the variable with the passed value.
Answered by AI
Add your answer
Q4. Opps concept and its pillar
Ans. 
Object-oriented programming paradigm and its four pillars: Inheritance, Encapsulation, Abstraction, Polymorphism
• Inheritance: Allows a class to inherit properties and behavior from another class

• Encapsulation: Bundling data and methods that operate on the data into a single unit

• Abstraction: Hiding the complex implementation details and showing only the necessary features

• Polymorphism: Ability to present the same interface
Answered by AI
Add your answer

Q1. Explain the architecture of transformer models.
Add your answer
Q2. What's the role of attention in transformers? Additionally, which one of the two networks has a faster training process - RNNs or transformers?
Add your answer

Duration was 1 hour. First asked verbal technical questions based on deep learning concepts, then asked me to code an easy leet code problem.

This round was with the hiring manager. It was mostly like a technical discussion, but he started by discussing the projects that I had worked on from my resume. Then it eventually turned into a system design type of a round.

Q1. What information do you have about the company?
Ans. 
The company is a leading technology firm specializing in software development and IT solutions.
• Founded in 2005

• Headquartered in Silicon Valley

• Offers a wide range of services including web development, mobile app development, and cloud computing

• Clients include Fortune 500 companies and startups
Answered by AI
Add your answer
Q2. How can you identify a client?
Ans. 
Clients can be identified through various methods such as networking, referrals, market research, and online presence.
• Networking events and conferences

• Referrals from existing clients or business partners

• Market research to identify potential clients in target industries

• Online presence through social media, website, and online directories
Answered by AI
Add your answer