Data transformation includes which of the following? – McqOptions

MCQOPTIONS

1.	Data transformation includes which of the following?
A.	A process to change data from a detailed level to a summary level
B.	A process to change data from a summary level to a detailed level
C.	Joining data from one source into various sources of data
D.	Separating data from one source into various sources of data
Answer» B. A process to change data from a summary level to a detailed level

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.