Mindfire Solutions Interview Questions and Answers

Q1. How to avoid running trigger on holidays on ADF
Ans. 
Use ADF's scheduling features and custom logic to prevent triggers from running on holidays.
• Utilize Azure Functions to check against a holiday calendar before executing the pipeline.

• Create a lookup table in Azure SQL Database containing holiday dates and query it in ADF.

• Implement a conditional trigger that only activates on non-holiday dates.

• Use a combination of ADF's pipeline parameters and expressions to skip executi...read more
Answered by AI
Add your answer
Q2. What is the total running inventory
Ans. 
Total running inventory refers to the current stock levels of items available for sale or use.
• It includes all items in stock, whether on shelves or in storage.

• For example, a retail store's total running inventory includes all products ready for sale.

• In a warehouse, it encompasses all goods stored, regardless of their status (available, reserved, etc.).

• Calculating total running inventory helps businesses manage stock le...read more
Answered by AI
Add your answer
Q3. What is spark architecture
Ans. 
Apache Spark architecture enables distributed data processing with a master-slave model for efficient computation and storage.
• Spark consists of a driver program that coordinates the execution of tasks across worker nodes.

• The cluster manager (like YARN or Mesos) allocates resources to Spark applications.

• Data is processed in parallel using Resilient Distributed Datasets (RDDs) for fault tolerance.

• Spark supports various d...read more
Answered by AI
Add your answer

DSA, SQL, Problem Solving, Technical, Data Structures and Algorithms

Q1. Write an SQL Query for retrieving something
Ans. 
SQL query to retrieve data from a database
• Use SELECT statement to specify the columns to retrieve

• Use FROM clause to specify the table to retrieve data from

• Use WHERE clause to filter the results based on conditions
Answered by AI
Add your answer
Q2. Write a program to achieve something
Ans. 
Program to sort an array of integers in ascending order
• Use a sorting algorithm like bubble sort, selection sort, or insertion sort

• Iterate through the array and compare adjacent elements to swap if necessary

• Repeat the process until the array is sorted
Answered by AI
Add your answer

Q1. What are delegates in programming?
Ans. 
Delegates are type-safe function pointers in .NET, allowing methods to be passed as parameters and enabling event handling.
• Delegates are reference types that encapsulate methods with a specific signature.

• They can point to one or more methods, allowing for multicast delegates.

• Example: `public delegate void MyDelegate(string message);`

• Delegates are commonly used for implementing event handling in .NET applications.

• They e...read more
Answered by AI
Add your answer
Q2. What is the program to demonstrate an API workflow?
Ans. 
A simple API workflow program demonstrates how to create, read, update, and delete data using a RESTful API.
• 1. Set up a web server using ASP.NET Core.

• 2. Create a model class, e.g., 'Product', with properties like Id, Name, and Price.

• 3. Implement a DbContext class for database operations.

• 4. Create a controller with actions for CRUD operations: Get, Post, Put, Delete.

• 5. Use HTTP methods: GET for retrieving data, POST for...read more
Answered by AI
Add your answer

First round was coding test conducted by their IDE where you can program in any language like on hackerrank IDE . 5 question were asked from easy to hard

Q1. They ask me about my though on social media
Add your answer
Q2. They give me a situation to handle the work load
Add your answer

Q1. Difference between stack and heap ?
Ans. 
Stack is used for static memory allocation and stores local variables, while heap is used for dynamic memory allocation and stores objects.
• Stack memory is allocated in a contiguous block and is faster to access compared to heap memory.

• Variables stored on the stack have limited scope and lifetime, while objects on the heap can persist beyond the scope of the function.

• Stack memory is managed by the compiler, while heap m...read more
Answered by AI
Add your answer
Q2. Difference between complier and interpreter ?
Ans. 
Compiler translates entire code into machine code before execution, while interpreter translates code line by line during execution.
• Compiler translates entire code into machine code before execution

• Interpreter translates code line by line during execution

• Compiler generates error messages after scanning entire code

• Interpreter stops at first error encountered

• Examples: C, C++ use compilers; Python, Ruby use interpreters
Answered by AI
Add your answer

Q1. My introduction
Add your answer
Q2. I can i mange to work proficiency
Ans. 
I manage work proficiency by prioritizing tasks, utilizing tools, and maintaining effective communication with my team.
• Prioritize tasks using the Eisenhower Matrix to distinguish between urgent and important tasks.

• Utilize project management tools like Trello or Jira to track progress and deadlines.

• Maintain open communication with team members to ensure alignment and address any blockers.

• Set specific, measurable goals f...read more
Answered by AI
Add your answer