Analyze and Determine When and Where to Use Data Cleaning, Standardization, Deduplication, and Data Transformation as Part of Data Integration. INTEGRATION-ARCHITECT Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   During a data integration, the same customer record appears multiple times in the source system with slightly different spellings (e.g., 'Jon Smith' vs 'John Smith'). Which process is specifically designed to address this issue?

   • AData cleaning
   • BData standardization
   • CData transformation
   • DData deduplication
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which scenario best illustrates the need for data cleaning in an integration?

   • AThe target system requires a different date format than the source.
   • BA field contains 'N/A' in some records and NULL in others, representing missing values.
   • CTwo systems store customer names in different column orders.
   • DThe same customer appears twice in the source system.
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A company integrates customer data from two sources: a CRM and a billing system. The same customer may exist in both with different email addresses (one personal, one work). The integration must create a single customer record in Salesforce, but the team is unsure which email to keep. Which approach is most appropriate?

   • AStandardize the email addresses to a common format and then load both records.
   • BLoad both records as separate customers to avoid data loss.
   • CClean the data by removing one of the email addresses.
   • DDeduplicate the records and merge them, keeping the email from the CRM as the primary.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   During a data integration project, a source system contains records with misspelled city names (e.g., 'New Yrok') and inconsistent date formats (e.g., '01/02/2023' vs '2023-01-02'). Which activity directly addresses these issues?

   • AData transformation
   • BData deduplication
   • CData standardization
   • DData cleaning
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A company integrates customer data from a legacy system into Salesforce. The legacy data has many records with outdated phone numbers and inconsistent state abbreviations (e.g., 'CA' vs 'Calif.'). The integration team must decide whether to clean and standardize the data before loading or load as-is and rely on Salesforce features. The company has strict data quality requirements for reporting. Which approach is most appropriate?

   • AClean the data to update phone numbers and standardize state abbreviations before loading.
   • BStandardize state abbreviations only, and load the data without cleaning phone numbers.
   • CLoad the data as-is and use Salesforce validation rules to enforce data quality.
   • DDeduplicate the records and load the data without cleaning or standardizing.
   Reveal Solution Discussion Select an answer first