Briskstar Technologies Interview Questions and Answers

Q1. Tell me about yourself, and project architecture. What are your day-to-day responsibilities?
Ans. 
I am a Data Engineer with experience in designing and implementing project architectures. My day-to-day responsibilities include data processing, ETL tasks, and ensuring data quality.
• Designing and implementing project architectures for data processing

• Performing ETL tasks to extract, transform, and load data into the system

• Ensuring data quality and integrity through data validation and cleansing

• Collaborating with cross-...read more
Answered by AI
Add your answer
Q2. SQL: To calculate the difference in marks for each student ID and marks across different years?
Ans. 
Use SQL to calculate the difference in marks for each student ID across different years.
• Use a self join on the table to compare marks for the same student ID across different years.

• Calculate the difference in marks by subtracting the marks from different years.

• Group the results by student ID to get the difference in marks for each student.
Answered by AI
Add your answer
Q3. SQL: Statewise which gender purchase is the most?
Ans. 
The answer to the question is that in which state which gender makes the most purchases.
• Aggregate the data by state and gender to calculate the total purchases made by each gender in each state.

• Identify the gender with the highest total purchases in each state.

• Present the results in a table or chart for easy visualization.
Answered by AI
Add your answer
Q4. What is ADF ??
Ans. 
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• ADF is used for building, scheduling, and monitoring data pipelines to move and transform data from various sources to destinations.

• It supports data integration between various data stores such as Azure SQL Database, Azure Blob Storage, and on-premises data sources.

• ADF provides a visu...read more
Answered by AI
Add your answer
Q5. Pysaprk Coding Question?
Add your answer
Q6. What is DAG ??
Ans. 
DAG stands for Directed Acyclic Graph, a data structure used to represent dependencies between tasks in a workflow.
• DAG is a collection of nodes connected by edges, where each edge has a direction and there are no cycles.

• It is commonly used in data engineering for representing data pipelines and workflows.

• DAGs help in visualizing and optimizing the order of tasks to be executed in a workflow.

• Popular tools like Apache Ai...read more
Answered by AI
Add your answer
Q7. What is Lineage ??
Ans. 
Lineage refers to the history and origin of data, including its source, transformations, and dependencies.
• Lineage helps in understanding how data is generated, processed, and transformed throughout its lifecycle.

• It tracks the flow of data from its source to its destination, including any intermediate steps or transformations.

• Lineage is important for data governance, data quality, and troubleshooting data issues.

• Example...read more
Answered by AI
Add your answer
Q8. How does Spark handle fault tolerance?
Ans. 
Spark handles fault tolerance through resilient distributed datasets (RDDs) and lineage tracking.
• Spark achieves fault tolerance through RDDs, which are immutable distributed collections of objects that can be rebuilt if a partition is lost.

• RDDs track the lineage of transformations applied to the data, allowing lost partitions to be recomputed based on the original data and transformations.

• Spark also replicates data par...read more
Answered by AI
Add your answer
Q9. There are four cores and four worker nodes in Spark. How many jobs will run in parallel?
Ans. 
Only one job will run in parallel in Spark with four cores and four worker nodes.
• In Spark, each core can only run one task at a time, so with four cores, only four tasks can run concurrently.

• Since there are four worker nodes, each with four cores, a total of four tasks can run in parallel.

• Therefore, only one job will run in parallel in this scenario.
Answered by AI
Add your answer
Q10. What are the optimisation techniques you have used in your project ?
Ans. 
I have used techniques like indexing, query optimization, and parallel processing in my projects.
• Indexing: Used to improve the speed of data retrieval by creating indexes on columns frequently used in queries.

• Query optimization: Rewriting queries to improve efficiency and reduce execution time.

• Parallel processing: Distributing tasks across multiple processors to speed up data processing.

• Caching: Storing frequently acce...read more
Answered by AI
Add your answer

Q1. Multi module maven project
Add your answer
Q2. Selenium project structure
Ans. 
Selenium project structure includes organizing test cases, page objects, utilities, and configuration files.
• Test cases should be organized in a separate folder

• Page objects should be stored in a separate package

• Utilities like helper classes, constants, and drivers should be in a separate package

• Configuration files like properties files should be stored in a separate folder

• Follow a modular approach for easy maintenance a
Answered by AI
Add your answer

Q1. How will you create a test plan ?
Ans. 
A test plan is created by defining objectives, scope, resources, schedule, and approach for testing.
• Define objectives and scope of testing

• Identify resources needed for testing

• Establish a schedule for testing activities

• Outline the approach and methodologies for testing

• Include risk assessment and mitigation strategies

• Document test scenarios, test cases, and test data

• Define roles and responsibilities of team members
Answered by AI
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Questions on basic PixiJs stuff and stuff about OOP.
Add your answer
Q2. What is the use of Loader?
Ans. 
Loader is used to load external assets such as images, sounds, and data into a game or application.
• Load images, sounds, and data from external sources into the game or application

• Improve loading times by preloading assets before they are needed

• Handle loading errors and provide feedback to the user

• Examples: loading character sprites, background music, level data
Answered by AI
Add your answer
Q3. What is the use of Interface in TypeScript?
Ans. 
Interfaces in TypeScript are used to define the structure of objects. They provide a way to enforce a certain shape on objects.
• Interfaces allow us to define the structure of an object by specifying the properties and their types.

• Interfaces can be used to enforce a certain shape on objects, ensuring that they have the required properties.

• Interfaces can also be used for type checking and to provide better documentation f...read more
Answered by AI
Add your answer
Q4. What is object pooling?
Ans. 
Object pooling is a design pattern where a set of objects are created and reused instead of creating new instances.
• Improves performance by reducing memory allocation and deallocation overhead

• Objects are kept in a pool and reused when needed

• Commonly used in game development for frequently created and destroyed objects
Answered by AI
Add your answer

Asked about previous projects and given a task to make a simple circle and change its color to a random color on click using pixiJS .

Q1. HR round was basic discussion on my prvs work and what I know about gammastack and stuff.
Add your answer