Salesforce Certified Data Cloud Consultant — Question 87

Cumulus Financial uses Service Cloud as its CRM and stores mobile phone, home phone, and work phone as three separate fields for its customers on the Contact record. The company plans to use Data Cloud and ingest the Contact object via the CRM Connector.
What is the most efficient approach that a consultant should take when ingesting this data to ensure all the different phone numbers are properly mapped and available for use in activation?

Answer options

• A. Ingest the Contact object and map the Work Phone, Mobile Phone, and Home Phone to the Contact Point Phone data map object from the Contact data stream by adding custom fields for Work and Home Phone.
• B. Ingest the Contact object and use streaming transforms to normalize the phone numbers from the Contact data stream into a separate Phone data lake object (DLO) that contains three rows, and then map this new DLO to the Contact Point Phone data map object.
• C. Ingest the Contact object and create formula fields in the Contact data stream on the phone numbers, and then map to the Contact Point Phone data map object.
• D. Ingest the Contact object and then create a calculated insight to normalize the phone numbers, and then map to the Contact Point Phone data map object.

Correct answer: B

Explanation

Option B is the most efficient approach as it allows for the normalization of phone numbers into a dedicated Phone data lake object (DLO) with multiple entries, ensuring all variations are captured accurately. The other options either complicate the mapping process or do not effectively consolidate the phone number data required for activation.