exam questions

Exam Certified Data Cloud Consultant All Questions

View all questions & answers for the Certified Data Cloud Consultant exam

Exam Certified Data Cloud Consultant topic 1 question 87 discussion

Actual exam question from Salesforce's Certified Data Cloud Consultant
Question #: 87
Topic #: 1
[All Certified Data Cloud Consultant Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
lucaluca1982
1 month, 2 weeks ago
Selected Answer: D
By assigning the PhoneNumber field type during data stream creation: Phone numbers are automatically validated and standardized during ingestion. It reduces the need for additional transformations or post-processing logic. It ensures consistency and correctness upfront, making the data immediately usable for SMS campaigns.
upvoted 2 times
...
edit_certs
2 months ago
Selected Answer: A
Stores phone numbers. Data Cloud doesn’t validate the format of the phone number. The phone data type is modeled on the text data type. Any valid text value is accepted for field. C can also work but not the most efficient.
upvoted 3 times
...
kb_monk
3 months, 1 week ago
Should be "A". The phone data type is modeled on the text data type. Any valid text value is accepted for ingestion into a phone data type field.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago