What is the purpose of cross-reference lookups in data imports?

• A. To speed up the import
• B. To encrypt data during import
• C. To verify external references against known datasets
• D. To generate random IDs

Answer: (C)

Cross-reference lookups during data imports are used to verify that the external identifiers in the incoming data match entities already known in the system, and to map those external references to internal keys. This ensures referential integrity by confirming references exist (and by translating them to the system’s internal IDs), which prevents orphaned records and data inconsistencies. For example, if a record cites a supplier by an external code, the lookup checks that code against the master supplier list and provides the internal supplier ID to store. If a reference isn’t found, you can flag it for review instead of importing invalid data. This process is about validation and correct mapping, not speeding up the import, encrypting data, or generating random IDs.