Project Related Questions

Project Related Questions

These questions you must practice before your interview.

• Explain end to end project flow?
• What is the size of your cluster?
• What is the size of your team?
• Tell me about your client?
• Tell me about your current project?
• What is the amount of data you receive on daily basis?
• From how many input sources you are getting data?
• Tell me file naming scheme?
• What are technical challenges you have faced?
• Can you suggest some sample tables used?
• What is your biggest accomplishment?
• What are the minimum file size and maximum file size you have handled?
• Tell me the number of tables you have handled?
• Tell me the number of columns you have handled?
• Is WINSCP is capable of transferring 4GB data at a time?
• Can you give some client requirements in your Project?
• What are your roles and responsibilities?
• What are your key achievements?
• Tell me 15 table names?
• What are the key challenges you faced and how did you resolve
• Explain your involvement in the projects.
• Which technologies your strength and rate yourself?
• In Hadoop, how we get a data from the client from which channel, the data are on the server, if yes the name of server how we can access the data?
• On what servers Hadoop is installed?
• Were you involved in performance tuning? How did you do that?
• Issues & how did you resolve them? 
• Can you explain compression techniques in Hadoop/Which technique did you use?
• How does ORC implement compression, what encoding techniques does it use?
• What is Indexing?
• How did you choose the columns for partitioning?
• Partitioned data is divided into how many buckets.
• On which column you have applied Partitioning and Bucketing?
• How did you conclude on the optimal bucket size?
• How can you implement Updates in Hive?
• What is bloom filter, how is it different from distributed cache, how do you implement it in MR?
• How to increase hive performance?
• Advantages of Columnar data stores over Row-oriented data stores.
• Can we change the default location of Managed tables?
• What are the factors that we consider while creating a hive table?
• What are the compression techniques and how do you decide which one to use?
• What are the key challenges you faced while importing data in Sqoop?
• Which Hadoop distribution have you used in your recent project?
• How you can contact your client everyday ?