TransOrg Analytics Interview Questions, Process, and Tips

Q1. Machine learning
Add your answer
Q2. Python questions
Add your answer

Q1. Advance ML Question
Add your answer
Q2. Adavance SQL and Python Question
Add your answer

Scenario Base Data Science Question and business understanding

Q1. Introduce your self and Explain your project?
Add your answer
Q2. What is Normalization is sql and explain 1NF 2NF 3NF?
Ans. 
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
• 1NF (First Normal Form) - Each column in a table must contain atomic values, and there should be no repeating groups.

• 2NF (Second Normal Form) - Table should be in 1NF and all non-key attributes are fully functional dependent on the primary key.

• 3NF (Third Normal Form) - Table should be in 2NF and there sh...read more
Answered by AI
Add your answer
Q3. What is difference between alter and update ?
Ans. 
Alter is used to modify the structure of a table, while update is used to modify the data in a table.
• Alter is used to add, remove, or modify columns in a table.

• Update is used to change the values of existing records in a table.

• Alter can change the structure of a table, such as adding a new column or changing the data type of a column.

• Update is used to modify the data in a table, such as changing the value of a specific
Answered by AI
Add your answer
Q4. Assume We had a PAN india Retail store because of which i have customer table in backend one is customer profile table and other is customer transaction table both will linked with customer id so what will...read more
Ans. 
Use left join for computationally efficient way to find customer names from customer profile and transaction tables.
• Use left join to combine customer profile and transaction tables based on customer id

• Left join will include all customers from profile table even if they don't have transactions

• Subquery may be less efficient as it has to be executed for each row in the result set
Answered by AI
Add your answer
Q5. How subquery is work on backend on the above question?
Add your answer
Q6. Design a business case to use self join? Condition : not use hirachical usecase like teacher student employee manager father and grandfather
Ans. 
Using self join to analyze customer behavior in an e-commerce platform.
• Identifying patterns in customer purchase history

• Analyzing customer preferences based on past purchases

• Segmenting customers based on their buying behavior
Answered by AI
Add your answer
Q7. What if you have to find out second highest transacting member in each city?
Ans. 
Use SQL query with window function to rank members by transaction amount in each city.
• Use SQL query with PARTITION BY clause to group members by city

• Use ORDER BY clause to rank members by transaction amount

• Select the second highest member for each city
Answered by AI
Add your answer
Q8. What is Common Expression Query (CTE)?How CTE is different from Stored Procedure?
Ans. 
CTE is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. It is different from a Stored Procedure as it is only available for the duration of the query.
• CTE stands for Common Table Expression and is defined using the WITH keyword.

• CTEs are mainly used for recursive queries, complex joins, and simplifying complex queries.

• CTEs are not stored in the database like Stored Proce...read more
Answered by AI
Add your answer
Q9. What is List Comprehension?
Ans. 
List comprehension is a concise way to create lists in Python by applying an expression to each item in an iterable.
• Syntax: [expression for item in iterable]

• Can include conditionals: [expression for item in iterable if condition]

• Example: squares = [x**2 for x in range(10)]
Answered by AI
Add your answer
Q10. Have you work on Lambda Function Explain it?
Ans. 
Lambda function is a serverless computing service that runs code in response to events and automatically manages the computing resources required.
• Lambda functions are event-driven and can be triggered by various AWS services such as S3, DynamoDB, API Gateway, etc.

• They are written in languages like Python, Node.js, Java, etc.

• Lambda functions are scalable and cost-effective as you only pay for the compute time you consum...read more
Answered by AI
Add your answer
Q11. What is generator function?
Ans. 
A generator function is a function that can pause and resume its execution, allowing it to yield multiple values over time.
• Generator functions are defined using the 'function*' syntax in JavaScript.

• They use the 'yield' keyword to return values one at a time.

• Generators can be iterated over using a 'for...of' loop.

• They are useful for generating sequences of values lazily, improving memory efficiency.
Answered by AI
Add your answer
Q12. What is the Difference between Transformation and Actions in pyspark? And Give Example
Ans. 
Transformation in pyspark is lazy evaluation while Actions trigger execution of transformations.
• Transformations are operations that are not executed immediately but create a plan for execution.

• Actions are operations that trigger the execution of transformations and return results.

• Examples of transformations include map, filter, and reduceByKey.

• Examples of actions include collect, count, and saveAsTextFile.
Answered by AI
Add your answer
Q13. Difference between map and Flatmap?
Ans. 
Map applies a function to each element in a collection and returns a new collection. Flatmap applies a function that returns a collection to each element and flattens the result.
• Map transforms each element in a collection using a function and returns a new collection.

• Flatmap applies a function that returns a collection to each element and flattens the result into a single collection.

• Map does not flatten nested collecti...read more
Answered by AI
Add your answer
Q14. What is Broadcast Variables?
Ans. 
Broadcast Variables are read-only shared variables that are cached on each machine in a cluster for efficient data distribution.
• Broadcast Variables are used to efficiently distribute large read-only datasets to all nodes in a Spark cluster.

• They are useful for tasks like joining a small lookup table with a large dataset.

• Broadcast variables are cached in memory on each machine to avoid unnecessary data shuffling during c
Answered by AI
Add your answer
Q15. Give the Case Study How you develop Dream 11 like cricket App as a team of Data Engineer ,Data Analyst ,Data Scientest ,Data Architecture and ETL Developer ?what kind of tables you have to you use for s...read more
Add your answer

Q1. Machine learning questions
Add your answer

Q1. Python list comprehension Sql basics Python basics
Add your answer

Sql queries and python related code

Q1. Machine learning concepts
Add your answer

Q1. Scenario based ML questions
Add your answer

Basic Apri quest for campus recruitment

Q1. Related to resume and basic analytics
Add your answer

Q1. Guesstimate, puzzle and Resume based projects
Add your answer

It consists of arithmetic, logical reasoning, verbal, data interpretation questions

Q1. Basics of python , Some queries of SQL , Puzzles
Add your answer
Q2. What is Normalisation and it's types
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a table into smaller tables and defining relationships between them.

• There are different levels of normalization, including first normal form (1NF), second normal form (2NF), and third normal form (3NF).

• 1NF involves eliminating duplicate columns and creating a primary key.

• 2NF...read more
Answered by AI
Add your answer