Diverse Lynx ETL Test Engineer Interview Questions and Answers for Experienced

Q1. C++ concept, oops, file handling, exception handling
Add your answer

Q1. Types of Triggers in ADF
Ans. 
Types of triggers in Azure Data Factory include schedule, tumbling window, event-based, and manual.
• Schedule trigger allows you to run pipelines on a specified schedule

• Tumbling window trigger runs pipelines at specified time intervals

• Event-based trigger runs pipelines based on events like file arrival or HTTP request

• Manual trigger allows you to manually trigger pipeline runs
Answered by AI
Add your answer

Q1. Define hooks and its use cases
Ans. 
Hooks are functions that allow developers to use state and other React features in functional components.
• Hooks are introduced in React 16.8 to allow state and other React features in functional components.

• Use cases include managing state, using lifecycle methods, and accessing context in functional components.

• Examples of hooks include useState, useEffect, useContext, and custom hooks created by developers.
Answered by AI
Add your answer
Q2. Difference between null and undefined
Ans. 
Null is a value that represents the absence of a value, while undefined means a variable has been declared but not assigned a value.
• Null is a value that can be assigned to a variable to indicate that it has no value.

• Undefined is a type that is automatically assigned to variables that have been declared but not initialized.

• Null is a deliberate assignment by the programmer, while undefined is a default value assigned by ...read more
Answered by AI
Add your answer

2 coding questions 10 aptitude and other 15 technical questions

Q1. DSA related question
Add your answer

Q1. DSA related question
Add your answer

There were 13 MCQ questions on DSA, 17 MCQ aptitude questions, and 2 coding questions.

Q1. There's a string s1,s2 and s3. s1 and s2 are divided into n and m parts respectively. check if, after interleaving strings s1 and s2, we get s3 as one of the answers.
Ans. 
Check if after interleaving strings s1 and s2, we get s3 as one of the answers.
• Create a recursive function to check all possible interleavings of s1 and s2

• Check if the current interleaving matches s3

• Return true if a valid interleaving is found, false otherwise
Answered by AI
Add your answer
Q2. Difference between cluster and non-cluster indexing. Do you know about database indexing?
Ans. 
Cluster indexing physically reorders the data on disk to match the index, while non-cluster indexing does not.
• Cluster indexing physically reorders the data on disk to match the index structure, leading to faster retrieval of data.

• Non-cluster indexing creates a separate data structure that points to the actual data, which may result in slower retrieval times.

• Cluster indexing is typically used in primary keys, while non-...read more
Answered by AI
Add your answer
Q3. Difference between stack and heap memory.
Ans. 
Stack memory is used for static memory allocation and follows a Last In First Out (LIFO) structure, while heap memory is used for dynamic memory allocation and has a more flexible structure.
• Stack memory is limited in size and is typically faster to access compared to heap memory.

• Variables stored in stack memory have a fixed size determined at compile time, while variables in heap memory can have a size determined at ru...read more
Answered by AI
Add your answer
Q4. What is a stable sort?
Ans. 
A stable sort is a sorting algorithm that preserves the relative order of equal elements in the sorted output.
• Stable sorts are useful when the original order of equal elements needs to be maintained.

• Examples of stable sorting algorithms include Merge Sort, Bubble Sort, and Insertion Sort.

• In a stable sort, if two elements have the same key value, their relative order in the original array is preserved in the sorted arra
Answered by AI
Add your answer
Q5. What's the time complexity of insertion in a hashmap?
Ans. 
Time complexity of insertion in a hashmap is O(1).
• Insertion in a hashmap has a constant time complexity of O(1) on average.

• This is because hashmaps use a hashing function to determine the index where the key-value pair should be stored.

• Even in the worst-case scenario, where there are collisions, the time complexity is still O(1) due to techniques like chaining or open addressing.

• Example: Inserting a key-value pair into...read more
Answered by AI
Add your answer
Q6. What is hashing?
Ans. 
Hashing is a process of converting input data into a fixed-size string of bytes using a hash function.
• Hashing is used to securely store passwords by converting them into a hash value.

• Hashing is used in data structures like hash tables to quickly retrieve data based on a key.

• Common hash functions include MD5, SHA-1, and SHA-256.
Answered by AI
Add your answer

2 Greedy Algo problems

Leetcode practice should be sufficient to tackle this round.

Q1. Trapping Rain Water problem.
Ans. 
Trapping Rain Water problem involves calculating the amount of water that can be trapped between buildings given their heights.
• Calculate the maximum height of buildings to the left and right of each building

• Find the minimum of the two heights

• Subtract the height of the current building to get the amount of water that can be trapped at that building
Answered by AI
Add your answer

3 questions, medium hard

Q1. Greedy Algorithm, simple jumps question, easily approachable by greedy algorithm
Add your answer
Q2. Binary Search, simple array based
Add your answer

Q1. DBMS, Projects, SQL Queries
Add your answer
Q2. 2 coding questions
Add your answer