CS614 Quiz No. 1 Solution and Discussion
-
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
-
-
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 valueOLAP is: CS614
_________ provides a combination of “relational database access” and “cube” data structures within a single framework. CS614
HOLAP (Page No. 78)
DOLAP
MOLAP
ROLAPHOLAP 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
predefiRobotic libraries are needed for ___________ CS614
Cubes
Data marts
Data warehouse
Aggregates



100% Off on Your FEE Join US! Ask Me How?


