Salesforce Certified Platform Data Architect Practice Questions

Salesforce Certified Platform Data Architect exam preparation

Salesforce Certified Platform Data Architect practice questions in English: 177 questions with explanations. The mock exam has 60 questions and 105 minutes.

Salesforce Certified Platform Data Architect free question 4 / 10 · Domain 2: Master Data Management

A matching rule compares the billing street with the Fuzzy: Street matching method. Two accounts have the billing streets "500 Pine Street, Suite 20" and "500 Pine Avenue, Suite 20". Only the street suffix (Street versus Avenue) differs. Which result matches the Help description of the matching method?

  1. The four sections are averaged with equal weight to 75, which is below the threshold of 80, so it is not a match
  2. Name, number, and suite number agree, so the field scores 85, above the threshold of 80, and it is a match
  3. The strings differ because of the suffix, so the field scores 0 and the pair is not treated as a match
  4. Street name and number are counted but the suite number is not, so the field scores 70, below the threshold of 80
Show the answer and explanation

Answer: B

Why this is correct
Fuzzy: Street is a weighted-average method with a threshold of 80. It breaks the address into sections and compares each one: street name (Edit Distance, 50% of the field's score), street number (exact, 20%), street suffix (exact, 15%), and suite number (exact, 15%). Here only the suffix differs, so the field scores 50 + 20 + 15 = 85. That exceeds the threshold of 80, so the streets are treated as a match.

Why the other options are wrong
"The strings differ because of the suffix, so the field scores 0 and the pair is not treated as a match" … The Help page says the address is broken into sections, each section has its own matching method and score, and the section scores are weighted into one score. The field is not scored 0 or 100 on whether the whole string is identical.
"Street name and number are counted but the suite number is not, so the field scores 70, below the threshold of 80" … The suite number is a section too, worth 15% of the field's score. Both addresses have Suite 20, so it adds to the score and the total is 85, not 70.
"The four sections are averaged with equal weight to 75, which is below the threshold of 80, so it is not a match" … The sections are not weighted equally. Street name carries 50%, street number 20%, and suffix and suite number 15% each, so the pair scores 85.

Key points
A weighted-average method lets the weights express which parts of the value matter most, and you can work out which difference drops a pair below the threshold. The Help page notes that this process works best with North American data.

Go to the Salesforce Certified Platform Data Architect practice app (10 free questions; purchase unlocks all questions)

See the full practice set