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

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

# 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

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 1037

.

+ 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:

## Latest Activity

Maham Raza. replied to Maham Raza.'s discussion VIP Kon.......???
11 minutes ago
Maham Raza. posted a discussion

### Jo Meri Mano,,Hisaab Choro..!!!!

15 minutes ago
50 minutes ago
BC20*74 added a discussion to the group MTH101 Calculus And Analytical Geometry

### MTH101 Calculus And Analytical Geometry Quiz # 1 2020 - Ending June 12 2020

55 minutes ago
BC20*74 joined +M.Tariq Malik's group

### MTH101 Calculus And Analytical Geometry

59 minutes ago
1 hour ago
Maham Raza. commented on Ayesha's blog post Golden Words
1 hour ago
Maham Raza. liked Ayesha's blog post Golden Words
1 hour ago
1 hour ago
Maham Raza. liked + ! ! ! ! ! ! !pคຖ໓คค ! !'s discussion ﺣﻘﯿﻘﺖ ﮐﭽﮫ ﺍﻭﺭ ہو۔
1 hour ago
Maham Raza. liked + ! ! ! ! ! ! !pคຖ໓คค ! !'s discussion ﺣﻘﯿﻘﺖ ﮐﭽﮫ ﺍﻭﺭ ہو۔
1 hour ago
1 hour ago

1

2

3