Data Integration involves -----------------------------
Sourcing data from disparate sources and integrating to be central repository
A process to change data from a detailed level to a summary level
A process to change data from a summary level to a detailed level
Separating data from one source into various sources of data
______________ is the best OLAP architecture approach for small data and complex model
MOLAP
ROLAP
HOLAP
None of the above
ODS (Operational Data Store) provides
Detailed decision making
Operational reporting
Drill through analysis
All of the above
This diagram represents a
A Hyper Star
A Relational schema
A Hyper schema
A Star schema
Data security includes
Protecting data from accidental loss, corruption
Standardizing data formats
Eliminating irrelevant data
Correcting anomalies
___________________________ is recommended for small and medium data volumes, good data quality and off peak loads
ETL
ELT
ELTL
EII
__________ architectural style of MDM provides real time central reference
Consolidation
Registry
Coexistence
Transaction
Confidentiality, Integrity, Availability are the goals of__________
Data Profiling
Data Security
Data Governance
Master Data Management
ELT uses ------------------------- for processing
ETL Tool processing engine
Target database engine
Source database engine
Source and Target database engine
The cube structure in OLAP achieves the __________functionality.
Shared
Information
Collection
Multidimensional