What kind of data analysis skill expected for CCA 175?

According to the objectives of Data Analysis section in CCA 175.

Do we need to know select queries(DML) as well for exam or not?
Example…: What products do customers like to buy? or What are top 10 revenue generating products?

It is primarily DDL and DML. Hive QL is not very important from certification perspective.