Possible to login to MYSQL in CCA175?

cca-175
mysql

#1

While taking the CCA175 test, is it possible to login to mysql database to get a clarity of the data?

I am asking this because, if a problem statement is given for which you need to view data first to act on it, is it possible to login? Or the only option is to run “sqoop eval” command to find it.

Someone who cleared CCA175 , please let me know.


#2

Yes, you can login to MYSQL database in CCA175 exam


#3

may I know if you were able to login? Because when I tried, the user “cert” (the default user when you login to CDH in the exam) has no access privilege to connect to mysql. No other users were specified in the problem statement. So in such scenario how do we connect to mysql?


#4

were you able to connect to mysql with the username/password provided in sqoop problems?


#5

I face same issue during my exam. They have not provided link to connect and cert user dont have access for mysql. I could not solve 2 question because of this issue.


#6

yes we can connect mysql in exam to validate the no of records for import and export.


#7

Hello,
Thanks for the above. Could you please verify whether the below approach would work ?

In the exam, lets assume we have logged into a VM of CDH named host1 as cert user.
MySQL database is hosted on a different VM namely host2 with credentials & as given in the problem statement, cant we access mysql as below ?

[cert@host1 ~]# mysql -u -h host2 -p

PS: I am preparing for the exam, hence any feedback on above would be very useful.


#8

You will pick these details from the problem statement for sqoop. Sqoop questions will mention username , host and password. Use those details to logon to MySQL.

Also, if you are unable to logon to MySQL then use sqoop eval.