Salesforce Certified Data Cloud Consultant — Question 37

A consultant is planning the ingestion of a data stream that has profile information including a mobile phone number.

To ensure that the phone number can be used for future SMS campaigns, they need to confirm the phone number field is in the proper E164 Phone Number format. However, the phone numbers in the file appear to be in varying formats.

What is the most efficient way to guarantee that the various phone number formats are standardized?

Answer options

• A. Create a formula field to standardize the format.
• B. Create a calculated insight after ingestion.
• C. Edit and update the data in the source system prior to sending to Data Cloud.
• D. Assign the PhoneNumber field type when creating the data stream.

Correct answer: D

Explanation

The correct answer is D because assigning the PhoneNumber field type ensures that the data is validated and formatted correctly into E164 format during the ingestion process. Options A and B do not address the issue at the point of data ingestion, and option C would require additional work before the data is sent, which is less efficient.