Today-Mid-cs614- paper
Assalam o Alaikum!
About half MCQs from previous mid and final files (see only up to page 193 from final MVQs files). Half th4e MCQs were new and I did about 5 correct (sure) , So paper was OK for me.
Here r MCQs which I did wrong, I wrote on paper only the answers , I attempted and now have checked and most of these are wrong. Very tricky MCQs.
One MCQ The data is extracted completely from the source system. Since this extraction reflects all
the data currently available in the source system, there's no need to keep track of changes
to the data _______ since the last successful extraction. if u do full extraction then no need to record changes in ________. Source, destination, DWH. Page=133, I attempted DWH and it is wrong correct is Source
One MCQ about data in flight (page 152), I had no idea if data can also fly so attempted wrong.
One MCQ was if grains r increased then what increases. In Solved MCQs it was details but in Lecture 14 at 54:05 minutes and in hand out page 118 , it is dimension , so I did dimension.
Question 21- Four basic tasks of data transfer
22- Describe four non-primary key problems when you get data from a source.
23- Describe three costs of data duplication
24- About Dimensions and their hierarchy
25 Which technique will you use for 1 to many and for many to many values? (See 2nd assignment)
26- You have singe MOLAP table. You partition it and use joins. Enquiries require joins among portioned tables. Will you prefer it for performance?
About half MCQs from previous mid and final files (see only up to page 193 from final MVQs files). Half th4e MCQs were new and I did about 5 correct (sure) , So paper was OK for me.
Here r MCQs which I did wrong, I wrote on paper only the answers , I attempted and now have checked and most of these are wrong. Very tricky MCQs.
One MCQ The data is extracted completely from the source system. Since this extraction reflects all
the data currently available in the source system, there's no need to keep track of changes
to the data _______ since the last successful extraction. if u do full extraction then no need to record changes in ________. Source, destination, DWH. Page=133, I attempted DWH and it is wrong correct is Source
One MCQ about data in flight (page 152), I had no idea if data can also fly so attempted wrong.
One MCQ was if grains r increased then what increases. In Solved MCQs it was details but in Lecture 14 at 54:05 minutes and in hand out page 118 , it is dimension , so I did dimension.
Question 21- Four basic tasks of data transfer
22- Describe four non-primary key problems when you get data from a source.
23- Describe three costs of data duplication
24- About Dimensions and their hierarchy
25 Which technique will you use for 1 to many and for many to many values? (See 2nd assignment)
26- You have singe MOLAP table. You partition it and use joins. Enquiries require joins among portioned tables. Will you prefer it for performance?
Comments
Post a Comment
Please give us your feedback & help us to improve this site.