Data analysis new syllabus

Data Analysis
Use Spark SQL to interact with the metastore programmatically in your applications. Generate reports by using queries against loaded data.
• Use metastore tables as an input source or an output sink for Spark applications - use Hive Context to access Hive tables and do analytics(filter,sort, rank etc ) on these Hive table?
• Understand the fundamentals of querying datasets in Spark
• Filter data using Spark
• Write queries that calculate aggregate statistics
• Join disparate datasets using Spark
• Produce ranked or sorted data

Kindly let me know if we have to use Spark SQL or Hive for the Data analysis part, Thanks