Cloudera has released a new certification exam for Data Analysts - CCA159. This is an entry level CCA certification, similar to CCA175. Instead of a focus on Spark and development, the focus is on using Impala/Hive to access the metastore and create SQL queries to generate reports from information in tables.
See all of the required skills for the exam at: http://www.cloudera.com/training/certification/cca-data-analyst.html
This exam follows all of the same learning objectives as the Cloudera Data Analyst course, if you need additional practice with the required skills: http://www.cloudera.com/training/courses/data-analyst-training.html?course=data-analyst&loc=online