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 3)

Questions 11–15

1. 11foundation · easy

   In a data integration project, one source stores phone numbers as '(555) 123-4567' and another as '5551234567'. To enable reliable matching and integration, which process should be applied?

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

   Which activity is an example of data transformation?

   • AConverting all phone numbers to a common format.
   • BCorrecting misspelled customer names.
   • CMerging duplicate customer records.
   • DAggregating daily sales transactions into monthly totals before loading into a reporting system.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company integrates account data from two different business units into a single Salesforce org. The same account may have been entered in both systems with different names and addresses. The integration must ensure that no duplicate accounts are created in Salesforce. Which technique should be applied?

   • AData cleaning to correct the account names.
   • BData transformation to map the account fields.
   • CData standardization to format the addresses consistently.
   • DData deduplication using matching rules on name and address.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   When analyzing an integration point, which factor should be considered to determine whether data cleaning is necessary?

   • AThe cost of the integration tool.
   • BThe number of fields in the target object.
   • CThe speed of the network connection.
   • DThe quality of the source data, such as the presence of inaccuracies or inconsistencies.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A company integrates customer data from a legacy system into Salesforce. The legacy data has many duplicate records and some records with missing phone numbers. The integration must run monthly and the team has a limited budget. The business requires that all customers have a phone number for the sales team to contact them. Which approach is most cost-effective?

   • ALoad the data as-is and let the sales team manually update phone numbers.
   • BDeduplicate the records and load the data without cleaning phone numbers.
   • CDeduplicate the records first, then clean the data to fill missing phone numbers using an external data service.
   • DClean the data first to fill missing phone numbers, then deduplicate.
   Reveal Solution Discussion Select an answer first