COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
a data warehouse can include
|
|
flat-files
|
|
|
database table
|
|
|
online data
|
|
|
all
|
Explanation:
Detailed explanation-1: -A typical data warehouse often includes the following elements: A relational database to store and manage data. An extraction, loading, and transformation (ELT) solution for preparing the data for analysis. Statistical analysis, reporting, and data mining capabilities.
Detailed explanation-2: -A system that is used to run the business in real time and is based on historical data.
Detailed explanation-3: -ETL. Metadata. SQL Query Processing. Data layer. Governance/security.
Detailed explanation-4: -Historical data. Derived data. Metadata.
There is 1 question to complete.