I want to know whether there there will be problems involving both spark using python or scala and spark SQL using hivecontext or sqlcontext or do we have a choice to choose from any one of this?
Copy from Cloudera website: https://www.cloudera.com/more/training/certification/cca-spark.html
Exam Question Format
Each CCA question requires you to solve a particular scenario. In some cases, a tool such as Impala or Hive may be used. In other cases, coding is required. In order to speed up development time of Spark questions, a template is often provided that contains a skeleton of the solution, asking the candidate to fill in the missing lines with functional code. This template is written in either Scala or Python.
You are not required to use the template and may solve the scenario using a language you prefer. Be aware, however, that coding every problem from scratch may take more time than is allocated for the exam.