SF-Data-Arch Hard Questions — 25 Difficult Questions

Question 1

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 2

An enterprise architect is evaluating data storage strategies for a telecommunications client experiencing rapid data growth of fifty million call detail records annually. Which TWO strategies should the architect implement to maintain database query performance and platform data limits? Choose 2 answers.

Accepted Answer

Utilize Salesforce Big Objects to store historical call records asynchronously and index primary lookup keys.. When dealing with massive data volumes exceeding standard transactional limits, traditional custom objects will quickly degrade platform performance and storage capacity. Offloading historical analytical data to Salesforce Big Objects or external systems via Salesforce Connect preserves core transactional limits. Additionally, implementing strict data archiving strategies prevents data skew and maintains query optimization.

Answer

Store the call detail records in standard custom objects with indexes applied to all foreign keys.

Answer

Create hierarchical custom object structures linking every call record directly to the Account master object.

Answer

Rely on standard Salesforce report archives to automatically move historical records out of reporting tables.

Question 3

You are auditing a Salesforce environment and discover a custom object with 20 million records. Users report that searching for records by a custom field 'External_ID__c' is extremely slow. What is the most appropriate action to take?

Accepted Answer

Mark the field as an External ID to trigger an automatic index.. When an object has large data volumes, non-indexed fields cause full table scans, which are highly inefficient and slow. By marking the 'External_ID__c' field as an External ID or unique field, Salesforce automatically creates a database index. This allows the query engine to perform a targeted lookup rather than scanning all 20 million records, providing an immediate and significant performance improvement for queries and searches involving that specific field.

Answer

Create a custom report type to better filter the data.

Answer

Increase the batch size of the user's list view.

Answer

Convert the custom object into a Big Object.

Question 4

A firm is implementing a data stewardship program. Which TWO activities are primary responsibilities of a Data Steward? (Choose Two)

Accepted Answer

Identify and document data quality issues.. Data stewards bridge the gap between technical IT teams and business users. They are responsible for the daily management, quality, and definition of data assets. By ensuring metadata is documented and data quality issues are remediated, they maintain the integrity of the data assets, which is critical for trustworthy analytics and regulatory reporting within the Salesforce ecosystem.

Answer

Define the overarching corporate data strategy.

Answer

Design the technical Salesforce architecture.

Answer

Approve all system-level security access.

Question 5

Universal Containers is implementing a data retention strategy for a custom object called Invoice__c that stores 120 million records. They need to archive records older than seven years to an external system while keeping the most recent records immediately accessible in Salesforce. Compliance requires that archived records remain queryable for audit purposes without impacting Salesforce performance. Which two Salesforce features should the architect recommend to meet these requirements? (Choose two.)

Accepted Answer

Big Objects with a custom index and asynchronous SOQL queries. Big Objects provide native, scalable storage for massive data volumes and support asynchronous queries, making them ideal for long-term archival within Salesforce. Salesforce Connect allows real-time access to external data without replication, so archived records remain queryable for audits. Together, they satisfy retention, performance, and compliance requirements without overloading the transactional object.

Answer

Standard Salesforce Recycle Bin retention policies

Answer

Field Audit Trail and Data Retention policies for standard objects

Answer

Salesforce Data Loader with a scheduled export to a local database

Question 6

A Data Architect is designing a data governance strategy for a Salesforce org that integrates with multiple external systems. The architect needs to ensure data quality and consistency across systems. Which two practices should be implemented? (Choose two.)

Accepted Answer

Define a master data management (MDM) strategy to establish a single source of truth.. The two correct practices are defining an MDM strategy and implementing validation and duplicate rules. MDM establishes a single source of truth, while validation and duplicate rules enforce data quality at the point of entry. Together, they ensure data consistency and accuracy across integrated systems, which is essential for effective data governance.

Answer

Schedule nightly full data exports to a data warehouse for backup purposes.

Answer

Configure field-level security to restrict access to sensitive fields.

Answer

Use Salesforce Data Loader to manually reconcile data discrepancies on a weekly basis.

Question 7

A data architect is designing a data retention strategy for a Salesforce org that stores millions of historical records. The architect must ensure compliance with regulations that require certain data to be retained for seven years and then permanently deleted. The org has a mix of standard and custom objects. (Choose two.)

Accepted Answer

Implement a batch Apex job that runs periodically to delete records older than seven years based on a custom date field.. Batch Apex and scheduled Flows are both viable options for automating the deletion of records after a retention period. Batch Apex is more scalable for millions of records, while Flows offer a declarative approach for smaller volumes. Both can be scheduled to run periodically and enforce a seven-year retention policy, ensuring compliance with regulations.

Answer

Use the Recycle Bin to manually purge records after seven years.

Answer

Use Salesforce's Data Retention policies to define retention periods for standard and custom objects.

Answer

Configure field history tracking to automatically delete old field history after seven years.

Question 8

Universal Containers has a custom object Shipment__c with a lookup to Account. They need to ensure that when an Account is deleted, the Shipment__c records are also deleted. However, they also need to preserve the Shipment__c records for auditing if the deletion is due to a merge of Accounts. What should the data architect do?

Accepted Answer

Use a Flow on Account deletion to check if it's a merge, and if so, prevent cascade deletion and reassign Shipment__c records to a new 'Audit' Account.. The requirement is to cascade delete on normal Account deletion but preserve Shipment__c records when the Account is merged. A Record-Triggered Flow on Account deletion can inspect the merge context: during a merge, the losing record is deleted with a master record ID. The flow can then prevent the cascade delete by reassigning the child records to a new parent, thus preserving them. This is a declarative solution that meets both needs.

Answer

Create a before delete trigger on Account that recreates Shipment__c records after deletion.

Answer

Set the lookup relationship to 'Cascade Delete' and enable 'Prevent deletion of parent' on the Account.

Answer

Configure the lookup to 'Clear the value of this field' on deletion, and create a scheduled batch to delete orphaned Shipment__c records later.

Question 9

A data architect is troubleshooting a performance issue on a custom object Transaction__c with 20 million records. A nightly batch job runs a SOQL query that filters on Transaction_Date__c (a date field) and Status__c (a picklist with 3 values). The query returns approximately 500,000 records. The architect creates a custom index on Transaction_Date__c, but the query still times out. What is the most likely explanation?

Accepted Answer

The index on Transaction_Date__c is not selective because the date range spans more than 30% of the first million records.. The query optimizer determines selectivity by examining the first million records. For a date filter, if the date range covers more than 30% of those records, the index is considered non-selective and may not be used. Even though the query returns only 500,000 records out of 20 million, the date range might still be too broad for the first million. Thus, the index is ignored, and the query performs a full scan, causing a timeout.

Answer

Custom indexes are not supported on date fields; only standard indexes can be used.

Answer

The index on Transaction_Date__c is not being used because the filter on Status__c is not indexed.

Answer

The query returns more than 30% of the records, making the filter non-selective despite the index.

Question 10

A data architect is designing a nightly batch process that updates 2 million Account records. The process runs in a single transaction and frequently fails with UNABLE_TO_LOCK_ROW errors. The updates are performed by a single integration user. What should the architect do to resolve the locking errors?

Accepted Answer

Use a smaller batch size and sort records by a field that distributes updates across different parents.. Lock contention on parent records occurs when multiple transactions try to update child records that reference the same parent. By reducing batch size and ordering updates so that records referencing different parents are processed together, the integration minimizes the chance of simultaneous lock requests on the same parent. This reduces UNABLE_TO_LOCK_ROW errors while maintaining data integrity.

Answer

Reduce the batch size and sort the records by parent ID to group updates on the same parent.

Answer

Increase the batch size to process all records in a single transaction to avoid multiple lock requests.

Answer

Disable record locking on the Account object by enabling the 'Bypass Locking' setting.

Question 11

A Salesforce org has a custom object Shipment__c with 12 million records. Users frequently run a SOQL query that filters on Status__c and Order_Date__c, and sorts by CreatedDate. The query is timing out. The org has an index on Status__c and a custom index on Order_Date__c. What is the most likely reason the query is still slow?

Accepted Answer

The query is non-selective because the combination of filters does not reduce the result set below the selectivity threshold, and sorting by CreatedDate requires additional processing.. For a 12-million-record object, selectivity is the critical factor. Salesforce uses a threshold based on object size to decide whether to use an index. Even with indexes on Status__c and Order_Date__c, if the filters return too many rows, the optimizer performs a full scan. Sorting by CreatedDate adds overhead. The correct diagnosis is that the query is non-selective and the sort compounds the cost.

Answer

The query is slow because it sorts by CreatedDate, which is not indexed, and Salesforce cannot sort large result sets without an index on the sort field.

Answer

The custom index on Order_Date__c is not used because Salesforce does not support custom indexes on date fields.

Answer

The query is slow because Status__c is a picklist field, and picklist fields cannot be indexed.

Question 12

A Salesforce org has a custom object Log__c with 15 million records. Users report that list views and reports on Log__c are slow, and the object has many fields (over 200). You are asked to improve performance. Which two actions should you recommend? (Choose two.)

Accepted Answer

Reduce the number of fields on Log__c by moving less frequently used fields to a related custom object.. For a wide object with 15 million records, a skinny table that includes only the fields used in list views and reports can dramatically reduce query time because it stores a narrow copy of the data. Reducing the number of fields on the object by moving rarely used fields to a related object also improves performance by decreasing row width. Together, these actions address the root cause: the volume of data scanned per query.

Answer

Enable Divisions on Log__c to partition the data and improve query performance.

Answer

Add custom indexes to all fields that are used in list view filters.

Answer

Set the Log__c object to be a Big Object to improve query performance for list views.

Question 13

A large enterprise uses Salesforce to manage customer data. The data governance team wants to track the lineage of a critical field 'Customer_Health_Score__c' on the Account object, which is calculated by an external system and loaded into Salesforce via a nightly integration. The team needs to know which integration job, user, and timestamp last modified this field for audit purposes. Which Salesforce feature should the architect implement to meet this requirement?

Accepted Answer

Field History Tracking on the Account object for the Customer_Health_Score__c field. Field History Tracking on the Account object for the Customer_Health_Score__c field captures the old and new values, the user who made the change, and the timestamp. This provides the necessary audit trail for data lineage. Setup Audit Trail, Event Monitoring, and Data Loader logs do not provide the same level of detail for record-level field changes. Field History Tracking is the appropriate Salesforce feature for tracking field-level data changes.

Answer

Data Loader logs

Answer

Event Monitoring

Answer

Setup Audit Trail

Question 14

A global insurer is preparing for a data privacy audit. The architect must demonstrate that the Salesforce org can identify where personal data lives and prove who accessed it. Which two capabilities should the architect include in the governance solution? (Choose two.)

Accepted Answer

Data Classification metadata on fields, using the Data Classification feature to tag fields as personal or sensitive.. The audit asks two distinct questions: where personal data resides and who accessed it. Data Classification metadata answers the first by tagging fields with sensitivity categories, and Event Monitoring answers the second by retaining access and API logs for analysis. Field history, bulk exports, and platform encryption do not provide classification inventory or access evidence.

Answer

A nightly Data Loader job that exports all records for offline retention.

Answer

Field History Tracking enabled on every field in the org to record old and new values.

Answer

Enabling Shield Platform Encryption on all text fields to mask values at rest.

Question 15

A global financial services company uses Salesforce as its CRM and has multiple business units that each maintain their own customer data. The data architect needs to implement a master data management strategy that provides a single view of the customer while respecting data residency requirements that prohibit certain customer data from leaving the EU. Which Salesforce feature should be used to meet these requirements?

Accepted Answer

Salesforce Hyperforce with a data residency policy that pins data storage to the EU region.. Hyperforce allows organizations to select the region where their Salesforce data is stored and processed. By choosing an EU region and configuring data residency, the company ensures that customer data never leaves the EU. This satisfies regulatory requirements while still enabling a single view of the customer across business units within that region.

Answer

Salesforce Shield Platform Encryption with a tenant secret stored in a Hardware Security Module (HSM) in the EU region.

Answer

Salesforce Multi-Org strategy with separate orgs for each business unit and a master org for consolidation.

Answer

Salesforce Connect to external data sources hosted in the EU, using cross-org adapters to unify customer records.

Question 16

A data architect is designing a master data management solution where customer records from Salesforce and a legacy system must be merged into a single golden record. The legacy system uses a customer ID that is a 10-digit number, while Salesforce uses a 15-character ID. The architect needs to create a unique cross-system identifier. Which approach best ensures uniqueness and traceability?

Accepted Answer

Use a composite key consisting of the source system code and the native ID, stored in an external ID field. A composite key of source system code and native ID provides a globally unique identifier that also indicates the record's origin. This is essential for master data management, as it allows the organization to trace data back to its source and perform accurate merges. It also supports upsert operations in Salesforce via an external ID field.

Answer

Use Salesforce's 15-character ID as the single identifier for all systems

Answer

Use the customer's email address as the unique identifier

Answer

Generate a random UUID for each customer and store it in a custom field

Question 17

A Salesforce data architect is designing an MDM solution that must support real-time access to golden records for a customer service application. The source systems include Salesforce, a legacy mainframe, and a cloud ERP. The architect must choose an integration pattern that ensures low latency and data consistency. Which pattern is most appropriate?

Accepted Answer

Virtual MDM with real-time data federation from source systems.. Virtual MDM with real-time data federation queries source systems on demand, providing the lowest latency and ensuring data consistency by always reflecting current source values. Batch ETL and manual entry introduce delays, while physical replication can have lag. For real-time customer service access, federation is the most appropriate pattern.

Answer

Physical MDM hub with real-time replication from all source systems.

Answer

Manual data entry into a single Salesforce org as the master.

Answer

Batch ETL to a physical MDM hub, with nightly synchronization to Salesforce.

Question 18

A data architect is implementing a master data management solution for customer data. The company wants to ensure that when a customer record is updated in the master system (Salesforce), the change is propagated to downstream systems (ERP, marketing automation) within 5 minutes. The downstream systems can consume REST APIs but cannot be called by Salesforce. Which integration pattern should the architect use?

Accepted Answer

Use Change Data Capture; a middleware subscribes to the change event stream and updates downstream systems via their REST APIs. Change Data Capture with a middleware subscriber is the best fit. It provides near real-time events, and the middleware can use the downstream systems' REST APIs to push updates. This avoids direct Salesforce-to-downstream calls and meets the tight time window. Other patterns either require unsupported protocols, introduce latency, or add unnecessary complexity.

Answer

Schedule a batch job in Salesforce that exports changed records to a file; downstream systems poll the file every 10 minutes

Answer

Salesforce calls a middleware REST endpoint on customer update; middleware then updates downstream systems

Answer

Salesforce publishes a Platform Event on customer update; downstream systems subscribe via CometD

Question 19

A data architect is planning to migrate 5 million Contact records from a legacy system into Salesforce Sales Cloud. The legacy data contains duplicate Contacts based on Email address, and the business wants to prevent duplicates in Salesforce. The architect must also ensure that the migration does not trigger existing Apex triggers and validation rules. Which two actions should the architect take before loading the data? (Choose two.)

Accepted Answer

Enable Duplicate Rules and Matching Rules for Contacts to block duplicates during load.. To prevent duplicates based on Email, the architect must activate Duplicate Rules and Matching Rules for Contacts. To avoid triggering Apex and validation rules, these should be temporarily disabled during the load. These two actions directly address the stated requirements. Other options like batch size, External ID, or scheduling are helpful but not essential for meeting the specific constraints.

Answer

Use the Data Loader in Batch mode with a batch size of 200.

Answer

Schedule the migration during off-peak hours to reduce impact on users.

Answer

Create a custom External ID field on Contact for the legacy system ID.

Question 20

A healthcare provider is migrating 8 million Patient__c records from a legacy system into Salesforce. The legacy data contains 300,000 records with missing or invalid values in the required field MRN__c (Medical Record Number). The business wants to load all valid records immediately and quarantine the invalid ones for later correction without failing the entire job. The architect will use Bulk API 2.0 with a CSV source. Which approach best meets the requirement?

Accepted Answer

Split the source into two files: one containing only records with valid MRN__c values, and another containing the invalid records. Load the valid file normally; store the invalid file for later correction.. Pre-splitting the source into valid and invalid subsets is the most controlled approach. It ensures valid records are loaded without interruption while invalid records are isolated for remediation. This avoids the overhead of parsing error logs and prevents partial failures from affecting the overall migration timeline.

Answer

Load all records and rely on Salesforce validation rules to reject invalid MRN__c values; then query the error log to reprocess failures.

Answer

Use Data Loader with the 'Allow Field Truncation' option and set MRN__c to a default placeholder value for missing entries.

Answer

Enable AllOrNone and load all records in a single batch so that invalid records cause a full rollback.