DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
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: -Subject areas within a data warehouse or data mart are physical tables that are grouped together in a dimensional model or star schema that reflect general data or functional categories.
Detailed explanation-4: -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-5: -Once in the data warehouse, the data is ingested, transformed, processed, and made accessible for use in decision-making. The three main types of data warehouses are enterprise data warehouse (EDW), operational data store (ODS), and data mart.