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

question 101

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

---

Definitions:

First World War

A global conflict that took place from 1914 to 1918, primarily involving European nations, and is known for introducing widespread military conscription and trench warfare.

American Labor Force

The total number of workers, including both the employed and the unemployed, within the United States.

1920s

A transformative decade known for economic prosperity, cultural blossoming, and significant social changes in the United States, often referred to as the "Roaring Twenties."

Women

Referring to adult human females, often discussed in the context of social, political, and economic rights and roles in society.