SF-Data-Arch Salesforce Data Management Practice Test 3 — 15 Questions

Question 1

Universal Containers has a custom object with 10 million records. They need to ensure that data is not lost if a user accidentally deletes a record. The architect must implement a solution that allows recovery of deleted records for up to 90 days. Which feature should be used?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Salesforce Data Recovery. Salesforce Data Recovery is the only native feature that provides a 90-day retention for deleted records and allows point-in-time restoration. The Recycle Bin only retains records for 15 days, and Field Audit Trail tracks changes rather than deletions. Scheduled Data Export is for backup but not for easy restoration of individual records. Therefore, Data Recovery is the correct choice.

Answer

Field Audit Trail

Answer

Scheduled Data Export

Answer

Salesforce Recycle Bin

Question 2

Universal Containers has a custom object with 10 million records. They need to ensure that data is not lost if a user accidentally deletes a record. The architect must implement a solution that allows recovery of deleted records for up to 90 days. Which feature should be used?

Choose an answer to begin — your selection is scored in the full session.

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 3

Universal Containers is integrating Salesforce with an external ERP system. The ERP system will send real-time updates to Salesforce for Account records. The integration must handle up to 1,000 updates per second and ensure that updates are processed in the order they are received. Which Salesforce API should the data architect recommend?

Accepted Answer

Streaming API. Streaming API is built for real-time event processing and guarantees ordered delivery within a channel. It can handle high throughput and is ideal for integrations requiring immediate, ordered updates. Other APIs either lack ordering guarantees or are not optimized for real-time high-volume scenarios.

Answer

Bulk API

Answer

SOAP API

Answer

REST API

Question 4

A company is migrating 50 million records into Salesforce. They need to ensure data integrity while minimizing API consumption. Which strategy is most efficient for a one-time bulk data load?

Accepted Answer

Use the Bulk API 2.0 with CSV files.. Bulk API 2.0 is the recommended approach for large datasets as it optimizes throughput by automatically breaking large jobs into smaller batches. It significantly reduces the number of API calls required compared to standard REST or SOAP APIs. Properly architecting for data loads involves choosing tools that leverage Bulk API 2.0 to maintain governor limits and ensure successful processing of high-volume data without impacting real-time integrations.

Answer

Use the standard REST API with single-record inserts.

Answer

Utilize the SOAP API with synchronous processing.

Answer

Perform a manual data import via the UI.

Question 5

Refer to the exhibit. An architect is reviewing an error log from a high-volume data load. Which pattern should be implemented to resolve this limit violation?

Accepted Answer

Implement the Bulk DML Pattern using collections.. The error indicates that DML operations are occurring inside a loop, exceeding the Salesforce governor limit of 150 DML statements per transaction. To resolve this, developers must use the Bulk Pattern, which involves collecting records in a collection (List or Map) and performing a single DML operation outside of the loop. This ensures efficient resource usage and prevents transactions from failing during high-volume data processing scenarios.

Answer

Increase the batch size in the data loader settings.

Answer

Convert the trigger to an asynchronous future method.

Answer

Increase the Apex CPU time limit in the Setup menu.

Question 6

When designing a master data management (MDM) strategy for Salesforce, which THREE factors are critical to preventing duplicate data across the enterprise? (Select THREE)

Accepted Answer

Implementing standard and custom Matching Rules.. Effective MDM strategies require a combination of automated matching rules, robust integration standards, and consistent data governance. These factors ensure that data entered through various channels is normalized and deduped at the point of entry. By implementing these controls, organizations maintain a single source of truth, improve data quality, and reduce the operational costs associated with manual data cleansing and conflicting records within their Salesforce environment.

Answer

Enforcing data entry through API-only integrations.

Answer

Regularly increasing the Data Storage capacity.

Question 7

Which tool should an architect select to perform a one-time migration of complex, relational data while maintaining parent-child relationships?

Accepted Answer

Salesforce Data Loader.. Salesforce Data Loader is the standard tool for managing complex data migrations. Its ability to map CSV files to objects and maintain relationships via External IDs or record IDs makes it the primary choice for data architects. Using a mature, supported tool minimizes errors during migration and ensures that data integrity is preserved across relational structures, which is critical for successful implementation projects and long-term data reliability.

Answer

Data Import Wizard.

Answer

Salesforce Inspector Chrome extension.

Answer

Change Sets.

Question 8

Refer to the exhibit. What is the primary benefit of configuring a field with these settings for data integration?

Accepted Answer

It enables efficient Upsert operations.. The configuration allows the field to serve as a key for 'Upsert' operations. By marking the field as an External ID and unique, Salesforce can automatically match records from an external system to existing Salesforce records. This prevents duplicates and allows for automated, incremental data updates without needing to know the internal Salesforce record ID, which is critical for robust, scalable integration architectures.

Answer

It enables faster reporting on the Account object.

Answer

It allows for deduplication in the UI.

Answer

It increases the maximum number of records.

Question 9

A bank requires a full audit trail of all record changes for compliance. What is the most effective way to track changes to sensitive fields?

Accepted Answer

Use Field Audit Trail (Shield).. Field Audit Trail is the most reliable way to meet regulatory compliance requirements for tracking data history. Unlike standard Field History Tracking, which is limited in retention and volume, Field Audit Trail allows for long-term retention and higher storage limits. This is essential for highly regulated industries like banking, where historical data accuracy and a permanent audit trail are mandatory for legal and security compliance.

Answer

Enable standard Field History Tracking.

Answer

Create a custom 'Audit' object with triggers.

Answer

Schedule daily exports of all records.

Question 10

Which security feature should an architect use to restrict access to sensitive fields based on a user's role?

Accepted Answer

Field-Level Security (FLS).. Field-Level Security (FLS) is the correct mechanism for controlling field access by profile or permission set. It ensures that users only see and interact with data relevant to their role. By applying FLS, architects can enforce strict data access policies, which is essential for compliance and maintaining the 'need-to-know' principle in complex, multi-departmental Salesforce environments where data privacy is paramount.

Answer

Organization-Wide Defaults (OWD).

Answer

Sharing Rules.

Answer

Role Hierarchy.

Question 11

An organization needs to integrate Salesforce with a legacy system that does not support modern authentication. What is the most secure architectural approach?

Accepted Answer

Use a Middleware/Integration layer.. Using an intermediate middleware or Integration Hub allows the architect to encapsulate the modern authentication requirements of Salesforce while providing a secure proxy for the legacy system. This prevents the need to downgrade security settings within Salesforce and keeps sensitive credentials secure. It is the professional standard for bridging modern cloud platforms with older on-premises systems while maintaining strict security and compliance standards.

Answer

Hardcode credentials in the Apex integration code.

Answer

Disable TLS 1.2 in Salesforce settings.

Answer

Send data via unencrypted email attachments.

Question 12

A company requires real-time reporting on millions of records. Which architecture enables this while minimizing impact on production database performance?

Accepted Answer

Use Salesforce Connect for virtualized access.. Salesforce Connect with External Objects is the ideal solution for large-scale data that shouldn't live directly inside Salesforce. It fetches data in real-time from external sources without consuming Salesforce storage or affecting local database performance. This pattern is critical for architects managing massive datasets, as it keeps the core Salesforce CRM instance light and performant while still providing users with seamless access to historical or external financial data.

Answer

Import all data into custom Salesforce objects.

Answer

Copy all data into the Salesforce Big Object.

Answer

Use platform events to stream data records.

Question 13

An enterprise organization is experiencing frequent data skew issues on the Account object, leading to severe record locking and performance degradation during parallel batch updates. What is the primary architectural cause of Account data skew in Salesforce?

Accepted Answer

Associating over 10,000 child records, such as Contacts or Cases, with a single parent Account record in the database.. Data skew occurs when an exceptionally high volume of child records are associated with a single parent record. During DML operations, Salesforce locks the parent record to maintain referential integrity, blocking concurrent threads attempting to update related children and causing transaction timeouts.

Answer

Having more than 10,000 custom fields defined across multiple page layouts within the Account object schema.

Answer

Assigning more than 50 active workflow rules that evaluate every record modification synchronously.

Answer

Utilizing person accounts alongside standard business accounts in a high-volume multi-region Salesforce implementation.

Question 14

Universal Containers is importing 5 million child records into a custom object using the Bulk API in parallel mode. The load frequently fails due to UNABLE_TO_LOCK_ROW errors because many child records share the same parent account. Which strategy should the architect recommend to resolve this failure?

Accepted Answer

Sort the CSV file by ParentId and process the data load in serial mode.. Bulk API parallel processing often triggers lock contention when multiple batches attempt to update different child records that roll up to the same parent record simultaneously. By organizing the CSV file such that records with the same parent are grouped together and then processing the load in serial mode, the system ensures that only one batch accesses a parent at a time.

Answer

Disable all triggers and validation rules on the child object during the import.

Answer

Increase the batch size to 10,000 records per batch in the Bulk API settings.

Answer

Enable PK Chunking to split the data load into smaller, manageable pieces.

Question 15

A financial services firm needs to load 20 million records into an object with a complex sharing model involving many Sharing Rules and Role Hierarchy levels. To minimize the time taken for the data load and avoid performance degradation, which feature should the architect utilize?

Accepted Answer

Utilizing 'Deferred Sharing Maintenance' to pause sharing rule recalculations.. Loading massive datasets into objects with complex sharing logic triggers significant overhead as Salesforce recalculates sharing access for every record. Deferring sharing calculations allows the data load to proceed without immediate recalculation, which is then performed in a single, optimized background process once the load is complete, saving hours of processing time.

Answer

Granting 'Ignore Hierarchy' permissions to the integration user profile.

Answer

Utilizing the 'Granular Locking' feature to allow concurrent sharing updates.

Answer

Setting the Organization-Wide Defaults (OWD) to Public Read/Write for the load.