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:

Social Loafing

The occurrence when people put in less effort towards achieving an objective while working in a group compared to when they are working solo.

Door-In-The-Face

A persuasion technique where a large, unreasonable request is made first and, when refused, is followed by a smaller, more reasonable request.

Compliance

The act of conforming to or following rules, guidelines, or instructions, often in a healthcare or legal context.

Foot-In-The-Door

A persuasive technique involving making a small request in order to gain compliance with a larger request later.