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

Question

Quizplus · Accepted Answer

The process of checking and reformatting the zip code field to conform to standards is a part of the data transformation process in ETL (Extract, Transform, Load) process. Therefore, the correct answer is B) transformation. Extraction is the process of extracting data from various sources, Loading is the process of loading transformed data into a data warehouse, and Normalization is the process of organizing data into tables to reduce redundancy and improve data integrity.

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