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
