DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Benefits of Data warehousing are:1. Data warehouses are designed to perform well with aggregate queries running on large amounts of data.2. The structure of data warehouses is easier for end users to navigate, understand and query against unlike the relational databases primarily designed to handle lots of transactions.3. Data warehouses enable queries that cut across different segments of a company’s operation. E.g. production data could be compared against inventory data even if they were originally stored in different databases with different structures.4. Queries that would be complex in very normalized databases could be easier to build and maintain in data warehouses, decreasing the workload on transaction systems.5. Data warehousing is an efficient way to manage and report on data that is from a variety of sources, non uniform and scattered throughout a company.6. Data warehousing is an efficient way to manage demand for lots of information from lots of users.
|
|
1, 2, 4, 6
|
|
|
1, 3, 2, 5
|
|
|
1, 2, 3, 4
|
|
|
1, 2, 3, 4, 5, 6
|
Explanation:
Detailed explanation-1: -A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.
Detailed explanation-2: -A system that is used to run the business in real time and is based on historical data.
Detailed explanation-3: -A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools. All of these components are engineered for speed so that you can get results quickly and analyze data on the fly.
There is 1 question to complete.