DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A process to reject data from the data warehouse and to create the necessary indexes
|
|
|
A process to load the data in the data warehouse and to create the necessary indexes
|
|
|
A process to upgrade the quality of data after it is moved into a data warehouse
|
|
|
A process to upgrade the quality of data before it is moved into a data warehouse
|
Detailed explanation-1: -Data scrubling is a process to upgrade the quality of data, before it is moved into Data warehouse. Data scrubling is a process of rejecting data from data warehouse to create indexes.
Detailed explanation-2: -Techopedia defines data scrubbing as “…the procedure of modifying or removing incomplete, incorrect, inaccurately formatted, or repeated data in a database.” The procedure improves the data’s consistency, accuracy, and reliability.
Detailed explanation-3: -(D) A process to reject data from the data warehouse and to create necessary indexes. Explanation: Data scrubbing, also called data cleansing, is the process of amending or removing data in a database that is incorrect, incomplete, improperly formatted, or duplicated.
Detailed explanation-4: -Data scrubbing improves data quality by removing duplicate, incorrect, incomplete, or poorly formatted data.
Detailed explanation-5: -Data scrubbing refers to the procedure of modifying or removing incomplete, incorrect, inaccurately formatted, or repeated data in a database.