CS614 Quiz No. 1 Solution and Discussion

zaasmi

Change Data Capture (CDC) can be challenging task because:

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

De-normalization is the process of selectively transforming normalized relations into un-normalized physical record specifications, with the aim to:

Well structure the data
Well model the data
Reduce query processing time
none

An OLTP system is always good at ___________

Evolving data
Keeping static data

_______ can be used when some columns are rarely accessed rather than other columns or when the table has wide rows or header or both.

Horizontal Splitting
Pre-joining
Vertical

In a fully normalized form:

To many Joins are required
Relationship lose their significance
no joins are required

_____________ facilitates a mobile computing paradigm.

DOLAP
HOLAP
ROLAP
MOLAP

Enrichment is one of the basic tasks in data ___________.

Extraction

*** Transformation**

Loading
Summarization

The online high performance transaction processing was evolved in _________

1980
1975
1977
1965

The process of converting entity relationship model in to dimensional model comprises of ___ steps:

Two
Three
Four
Five

Suppose the size of the attribute “Computerized National Identity Card (CNIC) no” is changed in NADRA database. This transformation refers to:

Format revision
Field splitting
Field decoding
Calculation of derived value

moaaz

Today Quiz Shared by someone (Thanks)
History is excellent predictor of the __________. CS614

• History is excellent predictor of the future.

In Extract, Load, Transform (ELT) process, data transformation _____ CS614

The relation R will be in 2nd Normal Form if CS614

Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as CS614

Distributed Systems Architecture
Legacy Systems Architecture
Online Systems Architecture
Intranet Systems Architecture

As dimensions get less detailed (e.g., year vs. day) cubes get ____ CS614

Suppose the size of the attribute “Computerized National Identity Card (CNIC) no” is changed in NADRA database. This transformation refers to: CS614

Format revision
Field splitting
Field decoding
Calculation of derived value

OLAP is: CS614

_________ provides a combination of “relational database access” and “cube” data structures within a single framework. CS614

HOLAP (Page No. 78)
DOLAP
MOLAP
ROLAP

HOLAP provides a combination of relational database access and “cube” data structures
within a single framework. The goal is to get the best of both MOLAP and ROLAP:
scalability (via relational structures) and high performance (via pre-built cubes).

The data has to be checked, cleansed and transformed into a ________ format to allow easy and fast access CS614

The data has to be checked, cleansed and transformed into a unified format to allow easy and fast access.

unified
predefi

Robotic libraries are needed for ___________ CS614

Cubes
Data marts
Data warehouse
Aggregates