In Today’s IT world Hadoop big data Technology has been playing a very good vital role in IT market.Every multi national companies are having their own standers for conducting a interview for the candidates.Now here i would like to share my interview experience with Accenture company.Here is the list of Accenture hadoop interview questions and answers for experienced .
Usually Accenture company conducting interviews for candidates based on two terms
- Job Portal
- Employee Referral
In first term Accenture company pays some money to online job portals like Naukari,Timesjob,Shine etc for best related Hadoop resumes.In second term Accenture company conducting Employee Referral that means who is presently working in Accenture company that employee can refer the outside person who is having good and suitable skills for that job to the company.
I applied through an employee referral. I interviewed at Accenture. Here is the complete details about Accenture hadoop interview questions and answers for experienced .
Accenture hadoop interview questions for Technical Round
In First round first 15 mins is all about our personal details,previous company details,Working Experience details, our technical skills and other things,after 15 mins the interview is all about your hadoop skills.Here is some Accenture hadoop interview questions and answers for experienced .
1)What is BigData?
2)What is Hadoop?
3)How should hadoop solving the big data problems?
4) What is SSH ?
A) Secure Shell also called as Secure Socket Shell
5) What is the Use of SSH in Hadoop ?
A) We should use SSH in Hadoop because SSH is a built-in username and password schema that can be used for secure access to a remote host; it is a more secure alternative to rlogin and telnet .
6) How will format the HDFS ?
A) $hadoop namenode -format
7)What is MapReduce?
8)What are different types of filesystem?
9)What is HDFS?
10) What are the most commonly used Input Formats in Hadoop ?
11) Which one is default InputFormat in Hadoop ?
12)What is the default block size in hdfs?
13) What is Hadoop Custom partitioner ?
14) Write a Mapreduce Program for Character Count ?
15) What is Hive ?
A) Hive is a data warehouse software which is used for facilitates querying and managing large data sets residing in distributed storage.
16) What is Hive Metastore ?
A) Hive Meta store is a database that stores metadata of your hive tables like table name,column name,data types,table location,number of buckets in the table etc.
17) What is Hive Present Version ?
18) What is the stable version of Hive ?
19) Which company initially developed Hive ?
20) Difference between SQL and HiveQL ?
21) Can i access Hive Without Hadoop ?
A) Yes,We can access Hive without hadoop with the help of other data storage systems like Amazon S3, GPFS (IBM) and MapR file system .
22) Explain about Hive Metadata lost ?
23) Explain about Hive Buckets with Example ?
24) what is pig?
25) what is differnce between pig and sql?
26) How Pig differs from MapReduce ?
27)what are relational operations in pig latin?
28) Write a Pig UDF Example ?
29) What is Hadoop sqoop ?
30) What are the basic available commands in Hadoop sqoop ?
31) What is HBase?
32) Is there any difference between HBase datamodel and RDBMS datamodel?
33) How many filters are available in HBase?
Accenture hadoop interview questions for Project Round
The most important round for candidates are second round.Here is the details of Accenture hadoop interview questions and answers for experienced.
Suppose I have a data which is more than 3 tera bytes in my local file system (not in HDFS) and now can i load the 3TB data into hive table by suing the data load command
Load data local inapth ‘\urdatapath’ into table tablename;
A) yes you can load 3tb of data from your local file system but it will take too much time that all are depends on your local systems configurations like Ram,processor.hive meta store only save the metadata of 3tb table and the actual data will stored in hdfs only.
The hive databases like derby,mysql,oracle and other supported databases for hive is only used for store the metadata but not for store the actual data.
2) Explain about Your previous hadoop project flow ?
3) What is Your Cluster size ?
4) What is Team size ?
5) What is Your Role in your Team ?
6) How you can contact your client everyday ?
If you are qualify for the technical round and Project round then you will get a call for Accenture HR Round.
Accenture HR Interview Questions
In this round mostly you and HR will talk about your previous company details,current salary,expected salary and notice period and other related things . So this is the Accenture hadoop interview questions and answers for experienced . Please do subscribe for more updates from us and please share comment your opinion about this post