Salesforce Certified Marketing Cloud Engagement Consultant Practice Questions

Salesforce Certified Marketing Cloud Engagement Consultant exam preparation

Salesforce Certified Marketing Cloud Engagement Consultant practice questions in English: 180 questions with explanations. The mock exam has 60 questions and 105 minutes.

Salesforce Certified Marketing Cloud Engagement Consultant free question 9 / 10 · Domain 5: Data Modeling and Management

A file to be imported has phone numbers written as (555)-555-5555 and 1-555-555-5555. They are loaded into a column that uses the Phone data type. What does the Data Extension Data Types article say happens?

  1. The nondigit characters are removed, and the Phone data type accepts up to 15 digits
  2. The numbers are cut to 10 digits, as longer values are not accepted
  3. The rows are rejected, as parentheses and dashes are not allowed in a Phone column
  4. The numbers are stored as typed, with the parentheses and the dashes kept in the value
Show the answer and explanation

Answer: A

Why this is correct
The Phone data type accepts 15-digit strings, and during an import or API insertion nondigit characters are removed. The article lists acceptable examples including 555-555-5555, 1-555-555-5555, 1-(555)-555-5555, and (555)-555-5555. Both formatted numbers in the file are therefore accepted, and they are stored as digits.

Why the other options are wrong
"The rows are rejected, as parentheses and dashes are not allowed in a Phone column" … The article lists forms such as (555)-555-5555 and 1-555-555-5555 as acceptable examples for a Phone column.
"The numbers are stored as typed, with the parentheses and the dashes kept in the value" … Nondigit characters are removed during an import or API insertion, so the punctuation is not kept.
"The numbers are cut to 10 digits, as longer values are not accepted" … The data type accepts 15-digit strings, so an 11-digit number such as 1-555-555-5555 is not cut to 10 digits.

Key point
Phone columns keep digits only, up to 15.

Go to the Salesforce Certified Marketing Cloud Engagement Consultant practice app (10 free questions; purchase unlocks all questions)

See the full practice set