Fractal Analytics Interview Questions, Process, and Tips

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

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

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.

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

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

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

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