Answer will be same after convert.
84e0807a-616d-4c42-84a2-4f63289e5a4a-image.png
4476461b-9e74-4125-ad00-78dac6fb19df-image.png
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:
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 ___________.
*** Transformation**
Loading
Summarization
The online high performance transaction processing was evolved in _________
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 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