We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>


Looking For Something at vustudents.ning.com? Click Here to Search

CS 614 online quiz no 02 solution and discussion due date Dec 12, 2014 11:59 PM

CS 614 online quiz no 02 solution and discussion Start Date Dec 11, 2014 12:00 AM End date Dec 12, 2014 11:59 PM

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 975

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Replies to This Discussion

Reminder Quiz#02

Dear Students,

It is to remind that quiz 02 of CS614 (Data Warehousing) will be opened on 11th December, 2014 and last date to attempt quiz will be 12th December, 2014 including lectures from 10 to 18.

Instructor CS614

Question # 1 of 10 ( Start time: 10:24:13 PM ) Total Marks: 1
In context of Change Data Capture (CDC), some times a ____ object can be used to store the recently modified data:
Select correct option:

Buffer table
Change table  
Checkmark table
Change control table


Question # 2 of 10 ( Start time: 10:24:31 PM ) Total Marks: 1
In case of multiple sources for the same data element, we need to prioritize the source systems per element bases, the process is called:
Select correct option:

Ranking  

Prioritization
Element Selection
Measurement Selection


Question # 3 of 10 ( Start time: 10:24:49 PM ) Total Marks: 1
If one or more records in a relational table do not satisfy one or more integrity constraint, then the data:
Select correct option:

Is syntactically dirty
Is semantically dirty  
Has Coverage anomaly
Has extraction issue


Question # 4 of 10 ( Start time: 10:25:17 PM ) Total Marks: 1
If actual data structure does not conform to documented formats then it is called:
Select correct option:

Syntactically dirty data
Semantically dirty data  
Coverage anomaly
Extraction issue


Question # 5 of 10 ( Start time: 10:25:57 PM ) Total Marks: 1
Change Data Capture (CDC) can be challenging task because:
Select correct option:

Aggregates don’t change in real time
Transformation of extracted data is difficult
Identifying the recently modified data may be difficult  
Source systems may not support extraction of changed aggregates


Question # 6 of 10 ( Start time: 10:26:25 PM ) Total Marks: 1
Which of the following is not a task of Data Transformation?
Select correct option:

Conversion
Summarization
Enrichment
Full Data Refresh 


Question # 7 of 10 ( Start time: 10:26:48 PM ) Total Marks: 1
One feature of Change Data Capture (CDC) is that:
Select correct option:

It pre-calculates changed aggregates
It loads the transformed data in real time
It only processes the data that has been changed
It can automate the transformation of extracted data 


Question # 8 of 10 ( Start time: 10:27:21 PM ) Total Marks: 1
Suppose the size of the attribute “Computerized National Identity Card (CNIC) no” is changed in NADRA database. This transformation refers to:
Select correct option:

Format revision  
Field splitting
Field decoding
Calculation of derived value


Question # 9 of 10 ( Start time: 10:27:38 PM ) Total Marks: 1
In context of data warehouse, normally it becomes difficult to extract data from different sources because these sources are normally:
Select correct option:

Heterogeneous  
Homogeneous
Centralized
Baselined


Question # 10 of 10 ( Start time: 10:28:01 PM ) Total Marks: 1
Which Logical Data Extraction has significant performance impacts on the data warehouse server?
Select correct option:

Incremental Extraction  
Full Extraction
Partial Extraction
Offline Extraction

Old Quiz 

Attachments:

Old Quiz 

Attachments:

CS614

Attachments:

Old Quiz 

Attachments:

Please all students related this subject Share your online Quizzes here to help each other.thanks

 

Please share the question and their answers of this quiz if anyone has done.
Thanks. 

MY QUIZ

Attachments:

RSS

Latest Activity

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service