Problem Scenario 17:  As you have been given below table.
HADOOPEXAM_STOCK (exchange string, stock_symbol string,  closing_date timestamp, closing_price decimal(8,2))


1. Write a query , which generate report as below.

exchange, stock_symbol , closing_date , closing_price , yesterday_closing , diff_yesterday_price (Price difference between Yesterdays price and todays price)

2. Write a query , which generate report as below.

exchange, stock_symbol , closing_date , closing_price , yesterday_closing , diff_last7days_price (Price difference between last 7days price and todays price)

3. Write a query which will print, whether following day price is higher ,  lower . Output should be like this.

exchange,stock_symbol, closing_date, closing_price, position  
 
Content 
Certification Content 
  1. Hadoop BigData Professional HandsOn Training
  2. Spark HandsOn Developer Training
  3. HBase HandsOn Training

http://www.hadoopexam.com/Cloudera_Certification/CCPDE575/CCP_DE575_Hadoop_Cloudera_Data_Enginer_Questions_Dumps_Practice_Test.html

ApacheSpark Interview Questions

·         Apache Spark InterviewQuestions-1

·         Apache Spark Interview Questions-2

·         Apache Spark Interview Questions-3

·         Apache Spark Interview Questions-4

·         Apache Spark Interview Questions-5

·         Apache Spark Interview Questions-6 

          Apache Spark Interview Questions-7


http://www.hadoopexam.com/cloudera_certification/cca175/cca_175_hadoop_cloudera_spark_certification_questions_dumps_practice_test.html