Fractal Analytics Interview Questions, Process, and Tips

Q1. What are the types of transformation?
Ans. 
Types of transformations include filtering, sorting, aggregating, joining, and pivoting.
• Filtering: Selecting a subset of rows based on certain criteria.

• Sorting: Arranging rows in a specific order based on one or more columns.

• Aggregating: Combining multiple rows into a single result, such as summing or averaging values.

• Joining: Combining data from multiple sources based on a common key.

• Pivoting: Restructuring data from
Answered by AI
Add your answer
Q2. Why is spark a lazy execution
Ans. 
Spark is lazy execution to optimize performance by delaying computation until necessary.
• Spark delays execution until an action is called to optimize performance.

• This allows Spark to optimize the execution plan and minimize unnecessary computations.

• Lazy evaluation helps in reducing unnecessary data shuffling and processing.

• Example: Transformations like map, filter, and reduce are not executed until an action like collec
Answered by AI
Add your answer
Q3. What is SCD and there types?
Ans. 
SCD stands for Slowly Changing Dimension. There are three types: Type 1, Type 2, and Type 3.
• SCD is used in data warehousing to track changes in dimension data over time.

• Type 1 SCD overwrites old data with new data, losing historical information.

• Type 2 SCD creates new records for each change, preserving historical data.

• Type 3 SCD keeps both old and new data in the same record, with separate columns for each version.
Answered by AI
Add your answer
Q4. What is linked service
Ans. 
A linked service is a connection to an external data source or destination in Azure Data Factory.
• Linked services define the connection information needed to connect to external data sources or destinations.

• They can be used in pipelines to read from or write to the linked data source.

• Examples of linked services include Azure Blob Storage, Azure SQL Database, and Salesforce.

• Linked services can store connection strings, a...read more
Answered by AI
Add your answer
Q5. What is dataset
Ans. 
A dataset is a collection of data that is organized in a structured format for easy access and analysis.
• A dataset can consist of tables, files, or other types of data sources.

• It is used for storing and managing data for analysis and reporting purposes.

• Examples of datasets include customer information, sales data, and sensor readings.

• Datasets can be structured, semi-structured, or unstructured depending on the type of d
Answered by AI
Add your answer

Q1. Project related
Add your answer
Q2. How you solve questions
Add your answer

Q1. What are the scopes of GA3
Ans. 
GA3 is a plant hormone that regulates various growth processes in plants.
• Regulates seed germination

• Promotes stem elongation

• Influences flowering and fruit development

• Used in agriculture to increase crop yield

• Can be applied externally to plants to induce growth responses
Answered by AI
Add your answer
Q2. What is a data layer
Ans. 
A data layer is a software component that separates the data access logic from the business logic in an application.
• It acts as an intermediary between the database and the application's business logic

• Helps in managing data access, storage, and retrieval

• Improves scalability and maintainability of the application

• Examples include ORM frameworks like Hibernate in Java or Entity Framework in .NET
Answered by AI
Add your answer

Q1. Salary negotiation
Add your answer
Q2. What is your notice period
Add your answer

Q1. Basic python question and oops
Add your answer

Q1. It's very easy and basic python libraries and SQL queries questions just theoretically and logical question and self introduction
Add your answer
Q2. Python libraries
Add your answer
Q3. Machine evaluation metrics
Add your answer
Q4. SQL basic concepts
Add your answer

Python and SQL based questions were given. Difficulty level was easy to medium.

Q1. - Formal introduction - Was asked to solve an easy python question as given - Describe your project - Challenges faced in the project and how you resolved them - Describe the lifecycle of a NLP based pr...read more
Add your answer

Q1. It was more of a techno-managerial round where the hiring manager asked questions about the project more in depth. Also some questions related to my interest and motivation to join the firm was asked.
Add your answer

Q1. It's very generic round where HR wants to get into your head and tries to understand your expectations from the firm.
Add your answer