Courseiva
Master Data Management →hardMultiple Select

SF-Data-Arch Master Data Management Practice Question

A data architect at a global manufacturer is designing a master data management solution in Salesforce for customer accounts sourced from Salesforce, a legacy mainframe, and a partner portal. The business requires that the golden record reflect the most trusted source per attribute and that conflicts be resolved deterministically. Which two capabilities should the architect implement to meet these requirements? (Choose two.)

⚠ Common exam trap

The trap here is equating duplicate prevention or manual stewardship with attribute-level survivorship, when deterministic golden records actually require source ranking plus a global identifier and cross-reference mapping.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Define source ranking and attribute-level survivorship rules so that the highest-ranked source wins per field, with documented tie-breakers.

Deterministic, attribute-level golden records require two foundations: a consistent identity across sources and explicit trust ranking with survivorship rules. A global identifier and cross-reference table group all source records for the same entity, while source ranking with field-level survivorship and documented tie-breakers decides which value wins. Together they deliver the required trust and determinism; duplicate management, manual review, and external read-only access do not.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Use Salesforce Duplicate Management with matching rules and duplicate rules to identify and block duplicate accounts at entry.

    Why it's wrong here

    Duplicate Management prevents and flags duplicate records during creation and update, which improves data quality but does not define which source is trusted per attribute or how to merge conflicting values into a golden record. It is a complementary control, not the mechanism for attribute-level survivorship, so it does not meet the stated requirements on its own.

  • ✓

    Define source ranking and attribute-level survivorship rules so that the highest-ranked source wins per field, with documented tie-breakers.

    Why this is correct

    Source ranking with attribute-level survivorship lets the architect specify which system is authoritative for each field, such as mainframe for legal name and Salesforce for billing address. Deterministic tie-breakers ensure conflicts resolve consistently. This directly satisfies the requirement that the golden record reflect the most trusted source per attribute and that conflicts be resolved without ambiguity, making it a correct choice.

  • ✗

    Configure an external object via Salesforce Connect to read mainframe customer data in real time without replication.

    Why it's wrong here

    External objects provide read-only access to remote data and do not participate in survivorship or golden record creation within Salesforce. They cannot be updated by Salesforce processes, so they cannot contribute to a merged master record. This approach addresses access, not conflict resolution, and therefore does not satisfy the attribute-level trust and deterministic resolution requirements.

  • ✗

    Implement a data steward approval workflow that routes every field-level conflict to a human for manual selection before the golden record is written.

    Why it's wrong here

    Manual conflict resolution does not scale for high-volume master data and does not provide deterministic resolution as required. It also introduces latency and inconsistency because different stewards may choose differently. While stewardship is valuable for exceptions, relying on it for all conflicts contradicts the need for deterministic, rule-based survivorship, so it is not a correct capability here.

  • ✓

    Establish a unique global identifier and cross-reference table that maps each source system key to the Salesforce master record.

    Why this is correct

    A global identifier with a cross-reference table enables reliable linking of the same entity across Salesforce, the mainframe, and the partner portal. Without consistent identity, survivorship rules cannot be applied to the correct records, so this is essential. It supports deterministic merging by ensuring all source records for an entity are grouped before attribute-level rules execute, making it a correct choice.

Visual reference

Client Recursive Resolver Root DNS (13 root servers) TLD DNS (.com, .org, …) Authoritative example.com query IP addr answer

About these practice questions

Courseiva writes every SF-Data-Arch question from scratch — 222 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed September 2026 · checked against the official Salesforce exam blueprint

This SF-Data-Arch practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Data-Arch exam.