Practice Cloudera CCA175 Exam Questions

Problem Scenario 1:
You have been given MySQL DB with following details. user=retail_dba
password=cloudera database=retail_db table=retail_db.categories
jdbc URL = jdbc:mysql://quickstart:3306/retail_db
Please accomplish following activities.
1. Connect MySQL DB and check the content of the tables.
2. Copy "retaildb.categories" table to hdfs, without specifying directory name.
3. Copy "retaildb.categories" table to hdfs, in a directory name "categories_target".
4. Copy "retaildb.categories" table to hdfs, in a warehouse directory name "categories_warehouse".

Problem Scenario 2 :
There is a parent organization called "ABC Group Inc", which has two child companies named Tech Inc and MPTech.
Both companies employee information is given in two separate text file as below. Please do the following activity for employee details.
Tech Inc.txt
1,Alok,Hyderabad
2,Krish,Hongkong
3,Jyoti,Mumbai
4,Atul,Banglore
5,Ishan,Gurgaon
MPTech.txt
6,John,Newyork
7,alp2004,California
8,tellme,Mumbai
9,Gagan21,Pune
10,Mukesh,Chennai
1. Which command will you use to check all the available command line options on HDFS and How will you get the Help for individual command.
2. Create a new Empty Directory named Employee using Command line. And also create an empty file named in it Techinc.txt
3. Load both companies Employee data in Employee directory (How to override existing file in HDFS).
4.  Merge both the Employees data in a Single tile called MergedEmployee.txt, merged tiles should have new line character at the end of each file content.
5.  Upload merged file on HDFS and change the file permission on HDFS merged file,so that owner and group member can read and write, other user can read the file.
6. Write a command to export the individual file as well as entire directory from HDFS to local file System.

Problem Scenario 3: You have been given MySQL DB with following details. user=retail_dba
password=cloudera database=retail_db table=retail_db.categories
jdbc URL = jdbc:mysql://quickstart:3306/retail_db
Please accomplish following activities.
1.   Import data from categories table, where category=22 (Data should be stored in categories subset)
2.       Import   data   from   categories   table,   where   category>22   (Data   should   be   stored   in categories_subset_2)
3.  Import data from categories table, where category between 1 and 22 (Data should be stored in categories_subset_3)
4.  While  importing  catagories  data  change  the  delimiter  to  '|'  (Data  should  be  stored  in categories_subset_S)
5.  Importing data from catagories table and restrict the  import to category_name,category   id columns only with delimiter as '|'
6.  Add  null  values  in  the  table  using  below  SQL  statement  ALTER  TABLE  categories  modify category_department_id int(11); INSERT INTO categories values (eO.NULL.'TESTING');
7.  Importing data from catagories table (In categories_subset_17 directory) using '|' delimiter and categoryjd between 1 and 61 and encode null values for both string and non string columns.
8. Import entire schema retail_db in a directory categories_subset_all_tables

Problem Scenario 4: You have been given MySQL DB with following details. user=retail_dba
password=cloudera database=retail_db table=retail_db.categories
jdbc URL = jdbc:mysql://quickstart:3306/retail_db
Please accomplish following activities.
Import Single table categories(Subset data} to hive managed table , where category_id between 1 and 22

Problem Scenario 5 : You have been given following mysql database details. user=retail_dba
password=cloudera database=retail_db
jdbc URL = jdbc:mysql://quickstart:3306/retail_db
Please accomplish following activities.
1. List all the tables using sqoop command from retail_db
2. Write simple sqoop eval command to check whether you have permission to read database tables or not.
3. Import all the tables as avro files in /user/hive/warehouse/retail cca174.db
4. Import departments table as a text file in /user/cloudera/departments.