Which step involves deciding how data should be normalized in the data modeling process?

• A. Create an inventory of all data streams
• B. Assess how data should be normalized
• C. Map to the data model
• D. Configure the DMO relationships on the data model

Answer: (B)

Normalization strategy in data modeling is about deciding how data should be organized to minimize redundancy and preserve integrity. This step involves assessing the appropriate level of normalization for the model—determining how granular the data should be, which tables are needed, and how keys and relationships should be defined. Making this assessment early guides how the data model is designed and implemented, balancing data integrity with performance considerations. The other steps focus on discovering data sources, translating the design into the model, or configuring how entities relate in the implementation, rather than deciding how the data should be normalized.