QuestionQ10
Data IngestionA company gathers data through a web form on its website. It wants to combine the form data and deduplicate it against current customer data:
Company existing profile data:
- companyEmail: [email protected]
- fName: Celeste
- lName: Brown-Smith
- officePhone: 555-555-7787
- mobilePhone: 555-555-1212
- companyName: Blue Widget Company
- companyPosition: Manager
Data submitted from the web form:
- companyEmail: [email protected]
- fName: Celeste
- lName: Brown-Smith
- officePhone: 555-555-7700
- mobilePhone: 555-555-1212
- companyName: Blue Widget Company
- companyPosition: Director
Assume deduplication uses the composite key companyEmail + lName + mobilePhone, and that the new web-form data overrides the current data.
Which entry will the export file contain?
- A companyEmail, mobilePhone, lname, fname, companyName, companyPosition, officePhone [email protected], 555-555-1212, Brown-Smith, Celeste, Blue Widget Company, Director, 555-555-7700 [email protected], 555-555-1212, Brown-Smith, Celeste, Blue Widget Company, Manager, 555-555-7787
- B companyEmail, mobilePhone, lname, fname, companyName, companyPosition, officePhone [email protected], 555-555-1212, Brown-Smith, Celeste, Blue Widget Company, Director, 555-555-7700
- C companyEmail, mobilePhone, lname, fname, companyName, companyPosition, officePhone [email protected], 555-555-1212, Brown-Smith, Celeste, Blue Widget Company, Manager, 555-555-7787
Community Discussion