The load and index is which of the following? – McqOptions

MCQOPTIONS

1.	The load and index is which of the following?
A.	A process to reject data from the data warehouse and to create the necessary indexes
B.	A process to load the data in the data warehouse and to create the necessary indexes
C.	A process to upgrade the quality of data after it is moved into a data warehouse
D.	A process to upgrade the quality of data before it is moved into a data warehouse
Answer» C. A process to upgrade the quality of data after it is moved into a data warehouse

Discussion

No Comment Found

Related MCQs

An enormous collection of data on various topics from a variety of internal and external sources, compiled by a firm for its own use or for use by its clients, is called :
An Enterprise Resource Planning application is an example of a(n) ______.
_________ is an intermediate storage area used for data processing during the extract, transform and load process of data warehousing .
Most NoSQL databases support automatic _____ meaning that you get high availability and disaster recovery.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Static extract is used for ongoing warehouse maintenance.
Every key used to join the fact table with a dimensional table should be a surrogate key.
Periodic data are data that are physically altered once added to the store.
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.