Axim Automation Technologies Data Engineer Intern Interview Questions and Answers

If everyone is cheating you should also do it?

Q1. Everyhting about project..
Add your answer
Q2. Linear vs logistic regression
Ans. 
Linear regression is used for continuous variables, while logistic regression is used for binary outcomes.
• Linear regression is used to predict a continuous outcome based on one or more input variables.

• Logistic regression is used to predict the probability of a binary outcome based on one or more input variables.

• Linear regression assumes a linear relationship between the independent and dependent variables, while logist...read more
Answered by AI
Add your answer
Q3. Normalization in dbms
Ans. 
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables and establishing relationships between them.

• It helps in reducing data redundancy, minimizing data anomalies, and improving data consistency.

• There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with spec...read more
Answered by AI
Add your answer
Q4. List array difference etc
Ans. 
Array difference is finding the elements that are present in one array but not in another.
• Use set operations like difference to find elements in one array but not in another.

• Example: arr1 = ['a', 'b', 'c'], arr2 = ['b', 'c', 'd'], arr_diff = set(arr1) - set(arr2) = ['a']
Answered by AI
Add your answer

Easy to answer ,asked mostly on sql and other ml topics

Q1. Differencde between sql and nosql
Ans. 
SQL is a relational database management system, while NoSQL is a non-relational database management system.
• SQL databases are table-based and have a predefined schema, while NoSQL databases are document-based, key-value pairs, graph databases, or wide-column stores.

• SQL databases are good for complex queries and transactions, while NoSQL databases are better for hierarchical data storage and real-time web applications.

• Ex...read more
Answered by AI
Add your answer
Q2. What are the regularization in ml
Ans. 
Regularization in machine learning is a technique used to prevent overfitting by adding a penalty term to the model's loss function.
• Regularization helps in reducing the complexity of the model by penalizing large coefficients.

• Common types of regularization include L1 (Lasso) and L2 (Ridge) regularization.

• L1 regularization adds the absolute value of the coefficients to the loss function, promoting sparsity.

• L2 regulariza...read more
Answered by AI
Add your answer

Q1. Questions were based on DSA and C
Add your answer
Q2. It was basically a coding round with simple logic
Add your answer

Q1. Why do you apply for this position
Ans. 
I am passionate about leveraging data to drive insights and make informed decisions.
• Passionate about working with data and analytics

• Excited about the opportunity to contribute to data-driven decision making

• Interested in the challenges and opportunities in the field of data engineering
Answered by AI
Add your answer
Q2. What is your current salay
Ans. 
I am currently earning a competitive salary based on my experience and skills.
• My current salary is in line with industry standards for data engineers.

• I have received raises and bonuses based on my performance.

• I am open to discussing salary expectations for this role.
Answered by AI
Add your answer

Q1. How to clean the raw data
Ans. 
Raw data can be cleaned by removing duplicates, handling missing values, standardizing formats, and correcting errors.
• Remove duplicates by identifying unique identifiers and filtering out redundant entries.

• Handle missing values by imputing with mean, median, or mode values or removing rows with missing data.

• Standardize formats by converting data into a consistent format (e.g. date formats, units of measurement).

• Correct...read more
Answered by AI
Add your answer
Q2. How to give relationship for two tables.
Ans. 
To establish a relationship between two tables, use a common key or field that links the records in both tables.
• Use primary and foreign keys to establish relationships between tables.

• Primary key in one table should match the foreign key in another table.

• Types of relationships include one-to-one, one-to-many, and many-to-many.

• Examples: CustomerID in a Customers table can be linked to CustomerID in Orders table.
Answered by AI
Add your answer

Q1. Why don't you take experienced people
Ans. 
We are open to hiring both experienced and inexperienced individuals to bring a diverse range of skills and perspectives to our team.
• We believe in providing opportunities for growth and development to individuals at all stages of their career.

• Fresh perspectives and new ideas from inexperienced individuals can bring innovation to the team.

• Experienced individuals may have set ways of doing things that could benefit from ...read more
Answered by AI
Add your answer
Q2. 2 years experience SAP & ERP
Add your answer

Q1. Internal external tables
Add your answer
Q2. MySQL questions
Add your answer