DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Can be updated by end users.
|
|
|
Contains numerous naming conventions and formats.
|
|
|
Organized around important subject areas.
|
|
|
Contains only current data.
|
Detailed explanation-1: -A data warehouse is Organized around important subject areas. A data warehouse commonly referred to as an enterprise data warehouse (EDW), is a tool for reporting and data analysis and is regarded as a key part of business intelligence. DWs serve as the central repository for combined data from a variety of sources.
Detailed explanation-2: -A data warehouse may contain multiple databases. Within each database, data is organized into tables and columns. Within each column, you can define a description of the data, such as integer, data field, or string. Tables can be organized inside of schemas, which you can think of as folders.
Detailed explanation-3: -CORRECT ANSWER : is organized around important subject areas. A data warehouse is organized around important subject areas. A data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.
Detailed explanation-4: -The Data Staging Area is located in between the Data Source(s) and the Data Target(s), which are typically Data Warehouses, Data Marts, or other Data Repositories.
Detailed explanation-5: -A data warehouse, or enterprise data warehouse (EDW), is a system that aggregates data from different sources into a single, central, consistent data store to support data analysis, data mining, artificial intelligence (AI), and machine learning.