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

Questions 16–20

1. 16application · medium

   A company integrates order data from multiple regional systems into Salesforce. Each system uses a different currency symbol (e.g., '$', '€', '£') in the amount field. The target Salesforce field must store a numeric amount. Which step is required?

   • AStandardize the amount field to a numeric format without currency symbols.
   • BClean the data by removing orders with currency symbols.
   • CTransform the data by converting all amounts to a single currency.
   • DDeduplicate the orders based on the amount field.
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A company integrates sales data from a data warehouse into Salesforce. The warehouse stores sales amounts in a single 'total_amount' field, but Salesforce requires separate 'subtotal' and 'tax' fields. The warehouse also stores dates in a 'YYYYMMDD' format, while Salesforce uses 'MM/DD/YYYY'. The integration must be completed within a limited time window. Which approach is most efficient?

   • APerform data cleaning to correct the date format and then load.
   • BPerform data standardization to convert the date format and then load.
   • CLoad the data as-is and use Salesforce formulas to split the amount and format the date.
   • DPerform data transformation to split the total amount and convert the date format.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which scenario best indicates the need for data deduplication?

   • AThe same customer record exists in both the CRM and the ERP system.
   • BThe target system requires a different field structure.
   • CA field contains inconsistent date formats.
   • DA record has a misspelled city name.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A company integrates address data from multiple sources into Salesforce. One source stores zip codes as 5-digit numbers, another as 9-digit numbers with a hyphen (e.g., '12345-6789'). The target Salesforce field must store the 5-digit zip code. Which step is necessary?

   • AStandardize the zip codes to a 5-digit format.
   • BDeduplicate the addresses based on zip code.
   • CTransform the data by mapping the zip code field to Salesforce.
   • DClean the data by removing records with 9-digit zip codes.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company integrates customer records from a legacy on-premises CRM and a newer cloud CRM into a single Salesforce org. The legacy system stores phone numbers with dashes and parentheses, while the cloud CRM stores them as 10-digit strings. The integration must produce a single, consistent phone number format in Salesforce. Which step is most essential to include in the integration process?

   • AApply data standardization to convert phone numbers to a common format before loading.
   • BPerform data deduplication to remove duplicate phone records from the legacy CRM.
   • CApply data transformation to map the legacy CRM fields to the Salesforce fields.
   • DUse data cleaning to correct invalid area codes in the phone numbers.
   Reveal Solution Discussion Select an answer first