A basic SQL query
Data Consultant Interview Questions
1,901 data consultant interview questions shared by candidates
What is Curtosis ?
What did you do in your previous role?
They ask u questions about process flows,some algorithm qs-tell u to write pseudocode on white board. They also judge you on creativity. A lot of behavioral qs. I interviewed with hiring manager twice and he asked almost same qs.
Do you know how to summarize a table?
What is a challenge the data industry faces?
What was your thesis about. Why data management.
Je gaat 5 km naar het zuiden, 5 km naar het westen en 5 km naar het noorden. Je bent op dezelfde plek, waar ben je?
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. )
Goed doorgaan op ervaring/toolingkennis
Viewing 1 - 10 interview questions