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

Questions 6–10

1. 6foundation · easy

   An integration architect is designing a data flow between two systems. The source data has duplicate records and inconsistent formats, and the target requires a different structure. Which combination of processes is most appropriate?

   • AStandardization and transformation only
   • BDeduplication, standardization, and transformation
   • CCleaning and transformation only
   • DCleaning and deduplication only
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A company integrates order data from an external e-commerce platform into Salesforce. The external system stores order amounts in USD, but Salesforce must store amounts in EUR. The integration must convert the currency and also combine the product name and product code into a single description field. Which integration step is required?

   • AData deduplication to prevent duplicate orders.
   • BData cleaning to remove invalid product codes.
   • CData standardization to format the product name consistently.
   • DData transformation to convert currency and concatenate fields.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A company integrates lead data from a website form into Salesforce. The form allows free-text entry for email addresses, and many entries contain typos (e.g., 'gmial.com' instead of 'gmail.com'). The integration must ensure that only valid email addresses are loaded. Which technique should be applied?

   • AData transformation to map the email field to Salesforce.
   • BData cleaning to validate and correct email addresses.
   • CData standardization to format email addresses consistently.
   • DData deduplication to remove duplicate email addresses.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company merges two Salesforce orgs after an acquisition. The same customer may exist in both orgs with slightly different names (e.g., 'Acme Corp' vs 'Acme Corporation') and different addresses. The integration team must ensure that each customer appears only once in the target org. Which approach should the team use?

   • ASkip deduplication because the source orgs are separate.
   • BUse exact-match on the customer name field only.
   • CRun a fuzzy-match deduplication process on name and address fields before loading.
   • DLoad all records and then manually review every potential duplicate.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which situation most clearly requires data standardization before integration?

   • AThe same customer appears in both sources.
   • BThe target system uses a different field name for the same attribute.
   • COne source uses 'M' and 'F' for gender, another uses 'Male' and 'Female'.
   • DA source contains records with missing email addresses.
   Reveal Solution Discussion Select an answer first