I went through many posts her and heard many thoughts from here which helped me a lot before I took the exam on June 9,2018,so I would like to contribute my part here. I am happy to share that I successfully cleared the same scoring 8 out of 9 questions.I am not sure why 1 went wrong and it was specified as ‘INCORRECT FILE FORMAT’ in my score card. Not sure if I copy pasted something wrong or I overlooked the question. I would like you to keep the below points in mind for your success.
TIME - I nearly completed my last question in the LAST SECOND of the exam and I clicked enter on my last command and proctor locked the screen to stop me from further typing any. Luckily, I got it correct and got it executed at backend. So, please don’t waste time any where. Execute the command and don’t keep watching it(especially SQOOP questions), start going through next question.
VALIDATE RESULTS- Don’t just execute the command and run after the next question(although you can get ready by reading the problem description of next one). Validate your result before you jump into next else you will miss the credit if you missed any output requirement. I couldn’t get time to validate the results for few questions due to lack of time, for which I lost one credit. I don’t want you to fall in that pit again.
NETWORK - Please make sure you have very good network and system with good H/W specifications for your exam. I lost Power once and the WiFi signal got disconnected many times for me. My Bad…!! Although the proctor says he is pausing the exam every time you got disconnected, why to take risk, lose time and get tensed in between the exam, huh.
SKIP TOUGHER and LENGTHY ones - If you feel and find the questions are lengthy to solve(although they are not that lengthy), skip the ones and go the next one, who know if the last question is just a walk in the park.In my case, my last 2 questions are easy and luckily I skipped the Problem7 and completed the last 2 questions and came back to this again.
I am hearing posts and reading questions related to SQOOP and MYSQL connectivity issues. There are NO issues anywhere and I got them connected. There are NO questions on FLUME,KAFKA or SPARK STREAMING. All the questions are pretty straight forward i.e., Sqoop -2, Spark–7(mostly reading from some file format -> applying some transformation-> write to HDFS in some file format)
All the best…!!