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?

Question

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?

Mounir Mrabet · Accepted Answer

Assign the PhoneNumber field type when creating the data stream.

Mounir Mrabet · Answer

Create a formula field to standardize the format.

Mounir Mrabet · Answer

Edit and update the data in the source system prior to sending to Data Cloud.

Mounir Mrabet · Answer

Create a calculated insight after ingestion.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 96 - Certified Data Cloud Consultant discussion

Suggested answer: C

0 comments