Mcqs were from this video ....short questions...1: two statements were given related to anaylis stage...we have to pridict which activity is performed in each statement related to analysis...2: a table was given related to data profiling in which we have to tell unique values...3: write key steps of requirement def in DWH development lifecycle4: a table was given we have to perform bitmap indexing in that table. Long questions: question no.1 : two table was given we have to write an Sql query related to that question ... questions no.2: write 5 steps of DWH development lifecycle.. almost all the mcqs were from YouTube vedio https://www.youtube.com/watch?v=WvEBOUUY5qI