I cleared CCA 175 with 100% score today.
The questions are relatively simple.
Sqoop -2, Spark - 7.
You need to know -
2. File formats - parquet, avro, etc and their compression types.
3. Basic Spark
4. Data frames/ Hive Context
No format is provided. You need to do all coding yourself, but its easy.
Good luck folks!