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