Problem Scenario 13:  Create a table as below.

Table Name :  HADOOPEXAM_STOCK
Columns : (exchange string, stock_symbol string,  closing_date timestamp, closing_price decimal(8,2));

Please insert below values.


- Write a Query to compute moving averages of the closing price, with 3-day span.
- Write a query to compute a cumulative moving average, from the earliest data up to the value for each day.

 



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