Bare International Data Quality Executive Interview Questions and Answers

Q1. Given a non-decreasing array, how can I determine the indices of an element X within it? If the element is not present, the output should be [-1, -1]. For example, for the array [1,2,3,3,5,5,7,8] and X=5, ...read more
Add your answer
Q2. From the employee table, how can I return the employee_name, department, age, and salary of the employee who is older than 35 and has the highest salary within each department?
Add your answer

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer

Basic Leetcode Questions

Q1. Basic NLP Questions
Add your answer
Q2. What is IF-IDF and why used?
Ans. 
IF-IDF stands for Inverse Document Frequency - Term Frequency. It is used in information retrieval to measure the importance of a term in a document.
• IF-IDF is a numerical statistic that reflects how important a word is to a document in a collection or corpus.

• It is calculated by multiplying the term frequency (TF) by the inverse document frequency (IDF) of the term.

• IF-IDF helps in identifying the most relevant words in ...read more
Answered by AI
Add your answer
Q3. Word Embedding?
Add your answer

Q1. API and production level questions
Add your answer

Aptitude test was divided into 3 parts and was not a typical quant, logical question it was more of an application based questions

Q1. What do you understand about the company?
Add your answer

Q1. Mostly behavioural and situation based questions.
Add your answer

Q1. Just basic questions. Checking our rnglish communication.
Add your answer

Q1. Ask about my skills and learn me to study extra skills for the next round
Add your answer

Q1. Asked about advanced excel questions. And sql and datas in my resume.
Add your answer

Q1. Sql, Python programming Questions
Add your answer

Q1. Retail, CPG based case study questions like offer allocation method for loyal customers
Add your answer