_ 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

Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.%!
Periodic data are data that are physically altered once added to the store.%!
Independent data marts are often created because an organization focuses on a series of short-term business objectives.%!
Every key used to join the fact table with a dimensional table should be a surrogate key.%!
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.%!
Most operational systems are based on the use of transient data.%!
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.%!
Data in the data warehouse are loaded and refreshed from operational systems.%!
Data in operational systems are typically fragmented and inconsistent.%!
Static extract is used for ongoing warehouse maintenance.%!