Skip to contentSkip to footer

Consultant Interview Questions

Salaries
Interviews

188,320 consultant interview questions shared by candidates

Spark : 1. Difference between map and flatmap. 2. Difference between groupbykey and reducebykey 3. Which file format spark saves file ? Answer should be ".orc" files only. (It took me multiple attempts to understand the question. and ".txt", ".csv" "xml" "anyflat-file-format" is not the correct answer. LOL ) 4. Difference between coalesce and repartition. 5. some more questions on RDD Hive 1 Difference between orderby and sortby 2. Select * from . How many mapper will be created. 3. Analytical function/ What is RANK ? hdfs 1. Difference between block and split SQL 1. What is indexing on single column ? (stopped in between of my answer ) and followed by what is sorting type in index key ascending or descending. (How does it matter its primary key not composite key) 2. Can you have two primary key . (I do not thing there will need of two primary as one it self does the job.) No tell the implementation is it possible, can you define two primary key ? (No) One of the panel member got irritated and fired a few questions after saying bye and answering my question related to profile and position . (Literally like Panel one : okay bye thanks for you ... Panel: No I will ask one last question . which file format spark saves files. )
avatar

Big Data Consultant

Interviewed at Prowareness

3.8★
Mar 3, 2017

Spark : 1. Difference between map and flatmap. 2. Difference between groupbykey and reducebykey 3. Which file format spark saves file ? Answer should be ".orc" files only. (It took me multiple attempts to understand the question. and ".txt", ".csv" "xml" "anyflat-file-format" is not the correct answer. LOL ) 4. Difference between coalesce and repartition. 5. some more questions on RDD Hive 1 Difference between orderby and sortby 2. Select * from . How many mapper will be created. 3. Analytical function/ What is RANK ? hdfs 1. Difference between block and split SQL 1. What is indexing on single column ? (stopped in between of my answer ) and followed by what is sorting type in index key ascending or descending. (How does it matter its primary key not composite key) 2. Can you have two primary key . (I do not thing there will need of two primary as one it self does the job.) No tell the implementation is it possible, can you define two primary key ? (No) One of the panel member got irritated and fired a few questions after saying bye and answering my question related to profile and position . (Literally like Panel one : okay bye thanks for you ... Panel: No I will ask one last question . which file format spark saves files. )

A few things I couldn't understand in the past with KAnand. 1. I had two interviews with Apple and I've got a written offer from KAnand starting from April 12. KAnand and I both signed the documents legally. 2. After the offer, I had to do another interview with Apple thru Cognizant/KAnand with his different JD which was nothing to do with my current offer with my JD, and which I was confused at that time since I've already got the offer, and Cognizant/KAnand also said my offer got confirmed already, so told me not to worry. 3. For some reason, the starting date was delayed one week, so I waited more than a week, but still I didn't know the starting date. 4. I contacted KAnand for many times, but I couldn't get responses about what's going on clearly. I didn't look for my job since my offer. 5. All of sudden, KAnand has cancelled my offer without any clear reason today on April 24. 6. I asked compensation, but Cognizant and KAnand didn't want to compensate.
avatar

Senior Consultant

Interviewed at KAnand

3.6★
Apr 25, 2017

A few things I couldn't understand in the past with KAnand. 1. I had two interviews with Apple and I've got a written offer from KAnand starting from April 12. KAnand and I both signed the documents legally. 2. After the offer, I had to do another interview with Apple thru Cognizant/KAnand with his different JD which was nothing to do with my current offer with my JD, and which I was confused at that time since I've already got the offer, and Cognizant/KAnand also said my offer got confirmed already, so told me not to worry. 3. For some reason, the starting date was delayed one week, so I waited more than a week, but still I didn't know the starting date. 4. I contacted KAnand for many times, but I couldn't get responses about what's going on clearly. I didn't look for my job since my offer. 5. All of sudden, KAnand has cancelled my offer without any clear reason today on April 24. 6. I asked compensation, but Cognizant and KAnand didn't want to compensate.

Viewing 1621 - 1630 interview questions

Glassdoor has 188,320 interview questions and reports from Consultant interviews. Prepare for your interview. Get hired. Love your job.