Julian, a Database Administrator, Prepares Data to Be Loaded to a Data

Multiple Choice

Julian, a database administrator, prepares data to be loaded to a data warehouse. He checks the zip code field against a reference database of zip codes to ensure that it conforms to standards. The zip codes that aren't in the standard format are reformatted. This process is called ________.

A) extraction
B) transformation
C) loading
D) normalization