SF-Data-Arch Data Governance Practice Test 2 — 15 Questions

Question 1

What is the primary role of a Data Dictionary in a Data Governance program?

Accepted Answer

Establishing a standard metadata definition.. A Data Dictionary acts as a central repository for technical and business metadata. It provides a common language for stakeholders, ensuring that everyone understands what a field represents, its data type, and its business rules. By centralizing this information, the dictionary prevents ambiguity and errors in reporting, which is a fundamental requirement for building a reliable, governed data environment.

Answer

Enforcing record-level security.

Answer

Automating data cleaning processes.

Answer

Managing integration authentication tokens.

Question 2

An architect is designing a governance framework for Master Data Management (MDM). Which approach is best for ensuring 'Golden Record' consistency in Salesforce?

Accepted Answer

Implementing an external MDM hub.. A Master Data Management strategy requires a 'Source of Truth' identification. By defining which system holds the primary record and using integration middleware to synchronize these records, the architect creates a consistent 'Golden Record'. This prevents data fragmentation where different systems maintain conflicting versions of the same customer, which is the core challenge MDM aims to solve.

Answer

Using Duplicate Rules to merge records.

Answer

Creating custom formula fields.

Answer

Enabling Person Accounts for all users.

Question 3

Which governance component ensures that Salesforce Orgs are prepared for major feature updates and potential breaking changes?

Accepted Answer

Change Management Process.. The Change Management process is critical for handling major updates. It includes impact analysis, sandbox testing, and regression testing. By governing this process, architects ensure that features are validated in a safe environment before production deployment. This minimizes the risk of system outages, ensures business continuity, and keeps the Salesforce environment stable during the rapid release cadence of the platform.

Answer

Data Classification Policy.

Answer

Data Dictionary.

Answer

Master Data Management (MDM).

Question 4

Refer to the exhibit. As a Data Architect, what is the governance concern if this 'VAL-099' rule remains inactive in production?

Accepted Answer

Degradation of data quality over time.. The primary concern is the uncontrolled entry of corrupt data. If a governance rule is defined but not active, the system lacks the technical enforcement to maintain quality standards. This leads to 'data rot' where the system collects invalid entries, which will eventually break downstream integrations, analytics reporting, and business processes, causing significant effort for data cleansing at a later date.

Answer

Increased system storage limits.

Answer

Inability to run system reports.

Answer

Increased Apex trigger execution time.

Question 5

Which document is essential to provide to a regulator to prove that the Data Governance program is active and effective?

Accepted Answer

Data Governance Charter.. The Data Governance Charter is the foundational document that outlines the authority, scope, and objectives of the program. It provides the official mandate, showing that the organization has formally recognized the importance of data governance. For regulators, this is the first proof that the organization has a structured approach to managing data quality, security, and compliance in its systems.

Answer

List of user profiles.

Answer

Salesforce Developer Guide.

Answer

Individual user training materials.

Question 6

Universal Containers needs to establish a formalized Data Governance framework to manage customer data across multiple Salesforce orgs and external systems. Which foundational element must the Data Governance board define first to ensure enterprise-wide alignment and accountability?

Accepted Answer

Define data owners, stewards, and organizational policies for critical data domains.. Establishing data ownership and stewardship is the critical first step in any Data Governance framework. Without clearly defined owners responsible for data quality, definitions, and lifecycle policies across disparate systems, subsequent technical implementations like Master Data Management or deduplication rules lack institutional direction and authoritative accountability.

Answer

Implement exact-match duplicate rules across all Salesforce objects.

Answer

Configure Platform Encryption for all Personally Identifiable Information fields.

Answer

Establish an automated archiving job for records older than seven years.

Question 7

A financial services firm is implementing Salesforce and must ensure PII data is managed according to strict regional privacy regulations. Which data governance framework component is most essential for tracking data lifecycle stages from collection to deletion?

Accepted Answer

Establishment of a Data Lifecycle Management policy.. A comprehensive Data Lifecycle Management (DLM) policy is critical for regulatory compliance. It provides the structured approach necessary to define how data is acquired, stored, processed, and eventually purged. By enforcing these stages, the organization ensures it does not retain PII longer than legally permitted, mitigating risk and satisfying audit requirements. This governance component is the foundation for operationalizing privacy by design within the Salesforce ecosystem.

Answer

Implementation of Einstein Data Insights for automated trend analysis.

Answer

Data Stewardship assignment to the IT department only.

Answer

Deployment of a Data Warehouse for all Salesforce logs.

Question 8

A large enterprise is struggling with inconsistent data quality across multiple business units. They want to establish a Data Governance Council. Who should lead this council to ensure the initiative receives adequate executive sponsorship and alignment with corporate strategy?

Accepted Answer

The Chief Data Officer or a senior business executive.. Executive sponsorship is the single most important factor for the success of a Data Governance initiative. By appointing a Chief Data Officer or a senior business leader, the organization signals that data is a strategic asset rather than just an IT concern. This alignment ensures that funding, resources, and cross-departmental cooperation are prioritized, effectively breaking down silos that often impede data quality projects.

Answer

The Lead Salesforce Administrator.

Answer

The Vice President of IT Infrastructure.

Answer

The external Salesforce Implementation Partner.

Question 9

A company is defining its Data Stewardship model. Which THREE responsibilities are typically assigned to a Data Steward within a Salesforce-centric data governance framework? (Choose three.)

Accepted Answer

Managing daily data quality issues and resolving duplicates.. Data Stewards act as the bridge between technical implementation and business utility. Their roles involve maintaining data accuracy, defining standards, and acting as the subject matter experts for specific data domains. By focusing on these areas, they ensure that the data stored in Salesforce remains reliable, compliant, and useful for stakeholders. These actions prevent the degradation of data quality over time and support ongoing compliance with organizational data policies.

Answer

Configuring Salesforce Org-wide defaults and sharing rules.

Answer

Writing APEX triggers to automate data cleanup.

Question 10

A global Salesforce org maintains an Account record that is simultaneously updated by an inbound ERP integration, a nightly Data Loader batch, and a sales rep via the Lightning UI. During a data quality audit, the governance board finds that conflicting values for the 'Annual Revenue' field have overwritten each other, and no one can determine which source was authoritative at any point in time. The board wants to ensure that future conflicts are detected, attributed to a source system, and resolved according to a documented priority order before the record is committed. Which governance mechanism should the Data Architect recommend to satisfy this requirement?

Accepted Answer

Implement a Master Data Management (MDM) system of record with survivorship rules that encode the source priority order and write the golden record back to Salesforce.. The requirement is a governed, deterministic conflict-resolution process that records which source system was authoritative. An MDM system of record with survivorship rules encodes the source priority order as governed metadata, applies it automatically when sources disagree, and preserves lineage for audit. Field history, manual review queues, and permission-based write exclusion either act too late, rely on human latency, or block legitimate writes without resolving the underlying conflict.

Answer

Create a validation rule that blocks updates to Annual Revenue unless the running user has the 'Data Governance' permission set, and grant that permission set only to the ERP integration user.

Answer

Implement a Data Steward review queue using a custom object and a scheduled Flow that asks the data steward to manually approve each conflicting value.

Answer

Enable Field History Tracking on Annual Revenue and create a report that shows all changes, then distribute the report to the governance board weekly.

Question 11

A multinational manufacturer runs a single Salesforce org for sales and service. Its governance team wants to enforce that all new custom objects created in production carry a business owner, a retention classification, and a data sensitivity label. Administrators frequently create objects ad hoc, and the team wants an automated check rather than a manual review. Which approach should the data architect recommend?

Accepted Answer

Use Metadata API and Apex Metadata API to scan object definitions against a governance checklist and block deployment when required attributes are missing.. Metadata-level governance requires inspecting object definitions, which only metadata-aware tooling can do. A programmatic check using Metadata API and Apex Metadata API lets the team compare each object against required attributes such as owner, retention classification, and sensitivity label, and it can fail the deployment automatically. Manual workflows and record-level rules cannot assert anything about the object definition itself.

Answer

Enable Field Audit Trail and Field History Tracking on all custom objects to capture who created each object.

Answer

Build a custom validation rule on each custom object that checks the owner field is populated on records.

Answer

Require every administrator to submit a change request through a ServiceNow workflow before creating a custom object.

Question 12

A financial services company must retain Salesforce records for seven years to satisfy a regulator. Records older than two years are rarely accessed but must remain retrievable within 48 hours if requested. The org's data volume is growing 40 percent per year, and the architect wants to minimize storage cost while preserving the ability to restore records with their original Salesforce IDs and relationships. Which approach best meets these requirements?

Accepted Answer

Use Salesforce Big Objects to archive records and query them with Async SOQL when a regulatory request arrives.. Archiving to Big Objects keeps data on-platform, preserves identifiers and relationships, and costs far less than keeping everything in standard storage. Async SOQL supports bulk retrieval so records can be produced within the 48-hour window. Deleting records, exporting to CSV, or simply buying more storage each fail at least one of the three requirements: retention, retrievability, or cost.

Answer

Increase the org's data storage allocation by purchasing additional storage blocks and keep all records online indefinitely.

Answer

Enable Data Storage Management by deleting records older than two years and relying on Salesforce Recycle Bin for recovery.

Answer

Export older records to a CSV file stored in an on-premises file share and delete them from Salesforce.

Question 13

Universal Containers is building a Data Governance program for its Salesforce org. The governance lead wants a single authoritative reference that defines every custom object and field, its business definition, data owner, allowed values, and system of record. Which artifact should the architect recommend as the foundation?

Accepted Answer

A Data Dictionary maintained as a versioned document and published to all stakeholders. The requirement is one authoritative reference covering field definitions, ownership, allowed values, and system of record. A Data Dictionary is precisely that artifact and is the standard foundation for a Data Governance program. ERDs, audit retention policies, and migration mappings each serve narrower technical purposes and cannot substitute for a maintained catalog of business and technical metadata.

Answer

A Data Loader field-mapping spreadsheet used for the most recent migration

Answer

An Entity Relationship Diagram showing all object relationships and cardinalities

Answer

A Field Audit Trail retention policy configured on all custom objects

Question 14

An enterprise Salesforce org has multiple business units that each maintain their own picklist values for the Industry field on Account. This has caused inconsistent reporting and integration failures. The Data Governance Council mandates a single, standardized Industry picklist across all business units. Which approach best enforces this standardization while allowing controlled local extensions?

Accepted Answer

Use a global picklist value set for the Industry field and allow each business unit to add values only through a formal governance request process that updates the global set.. The governance council needs one standardized Industry picklist while still permitting controlled local additions. A global picklist value set provides the single source of truth, and a formal request process ensures any new values are reviewed and added centrally. This prevents uncontrolled divergence, keeps integrations and reporting consistent, and gives business units a governed path to request extensions.

Answer

Leave each business unit with its own custom picklist and create a formula field that maps local values to a standardized set for reporting.

Answer

Replace the Industry field with a text field and rely on a validation rule that checks values against a custom setting maintained by each business unit.

Answer

Create a single global picklist value set and assign it to the Industry field on Account for all business units, with no ability for local additions.

Question 15

Northern Trail Outfitters is preparing for a GDPR-driven data subject deletion request affecting a Contact and its related Cases, Email Messages, and custom child records. The architect must ensure the deletion is complete and evidenced. Which approach best satisfies the governance requirement?

Accepted Answer

Use the native Data Subject Request (DSR) tooling to locate, and then erase the individual's data across related objects, capturing the action for evidence. A GDPR erasure request spans every object holding the individual's data, and governance requires proof the action occurred. The native Data Subject Request tooling locates data across related objects, supports erasure, and records the activity, satisfying both completeness and evidence. Manual deletes, field nulling, and off-platform exports each leave residual data or create ungoverned copies.

Answer

Export the individual's data to a CSV, delete the Contact, and archive the CSV in a shared drive

Answer

Overwrite the Contact fields with null values using Data Loader and leave related records intact

Answer

Delete the Contact record and rely on the recycle bin to remove related records