Following systems can be source for business intelligence
Be-spoke applications
Document Management systems
Enterprise applications
All of the above
Data in BI architecture flows as follows
Dispersed data -> Collected Data -> Integrated Data -> Information -> Knowledge
Collected Data -> Dispersed data -> Integrated Data -> Information -> Knowledge
Dispersed data -> Collected Data -> Integrated Data -> Knowledge-> Information
Collected Data -> Dispersed data -> Integrated Data -> Knowledge -> Informatio
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
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