# Junior data analyst Interview Questions in Canada

# 1K

Junior Data Analyst interview questions shared by candidates### For a given array count combination of pairs of (x,y) whose sum is N.

4 Answers↳

int[] list = {7,6,2,3,4,5}; int N=9; int count=0; for(int i=0;i

↳

Three solutions I gave. 1. Sort the array in O(nlogn). Min and Max as two indices. Count=0 Loop if A[Min]+A[Max]N Decrement (Max) else Increment(Count) End 2. Using extra space and count sort if the minima and maxima of array sets are in a given range. Max absolute negative number subtracted to keep numbers in positive number space. Loop if Memory[N- A[i]- Min] Increment(Count) End 3. Create a Hashset/Hashtable. Look for N-A[i] and increment count if found. Loop if Get(N- A[i]) Increment (Count) else Push(A[i]) End Less

↳

the complexity of ur solution is not so good you can do better

### If a jar has X red balls and Y blue balls, what is the minimum number of draws that is necessary to ensure that you have one ball of each color?

3 Answers↳

It is max, the first reply was correct. I you have 5 blue balls and 2 red balls : - If it was min : you take 3 balls, it is still possible to have picked 3 blue balls. - with max : you take 6 balls, the worst case is that you have picked 5 blue and 1 red balls. Less

↳

max(X, Y)+1

↳

min(X,Y) + 1 is correct, not max()

### How would you query an SQL database with Tera of data?

2 Answers↳

Not sure of the answer but would try to partition my query.

↳

I would probably batch my data

### A frog falls down a well of 50ft. Each day he climbs up 3 and each night falls down 2. How many days does it take him to get out?

2 Answers↳

48 actually

↳

47

### Find out whether an array/string contains non-repeated characters.

2 Answers↳

Two solutions I gave 1. Make a bucket of ASCII (256),/ Eng Alphabet(26)characters.Look for count of A[i] . If 1 return false else return true in the end Loop if (!Memory[A[i]]) ) Increment (Count) else return false End return true 2. Create a Hashset/Hashtable. Look for A[i] . If found return false else return true in the end Loop if ! Get(A[i]) Push (A[i]) else return false End return true Less

↳

the complxity of your solution will be O(n) runtime and O(n) memory you can do better Less

### If the coefficient of an independent variable in linear regression has an opposite sign than it should be, what might be the reason

1 Answers↳

multicollinearity

### Introductory questions. Describing yourself. Your skills. Your past experiences. Presentation of a Case Study that was provided a few days before the interview.

1 Answers↳

I answered honestly. I sounded genuine and friendly. Smiling all the time. Presented the Case Study and answered the questions that followed. Less