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

Question 1

Which THREE factors should a Data Architect consider when determining whether to use the Bulk API 2.0 versus the standard SOAP API for a large data integration?

Accepted Answer

The total volume of records being processed in a single transaction.. The choice between Bulk API 2.0 and SOAP API hinges on the volume of data and the specific integration constraints. Bulk API 2.0 is highly optimized for millions of records by handling batching automatically, while SOAP API is better for real-time, lower-volume transactions where immediate confirmation is needed. Evaluating governor limits, total record counts, and the requirement for real-time error handling is essential for choosing the correct architectural pattern for the integration.

Answer

The complexity of the record-level security model applied to the user.

Answer

The requirement to execute Apex triggers and validation rules.

Question 2

A Data Architect is asked to improve the performance of a dashboard that aggregates data from a custom object with 10 million records. Which approach is most appropriate?

Accepted Answer

Implement a summary object that stores daily aggregates of the data.. For high-volume dashboards, pre-aggregating data is the most efficient way to ensure fast rendering. By using a 'summary' object or a reporting snapshot that stores computed aggregates, the dashboard queries a much smaller number of records rather than performing calculations on the fly. This significantly reduces query execution time and prevents the dashboard from timing out, providing a reliable and responsive user experience even with massive underlying datasets.

Answer

Create a formula field to calculate the totals on every record.

Answer

Use a Dynamic Dashboard to force data refresh every hour.

Answer

Enable 'Parallel Report Processing' in the Org settings.

Question 3

Universal Containers needs to migrate 50 million legacy records into a custom object while maintaining original system IDs and audit timestamps. Which data loading approach best satisfies these architectural requirements?

Accepted Answer

Contact Salesforce Support to enable 'Create Audit Fields' feature, then use Bulk API 2.0 with CSV files.. Using Salesforce Bulk API 2.0 with custom date/time fields handles large data volumes efficiently while avoiding platform limitations. Native CreatedDate and SystemModstamp are system-managed fields that cannot be populated directly during standard imports without special enablement, making custom fields necessary for historical tracking. This approach guarantees optimal performance and preserves system integrity during massive data migration initiatives.

Answer

Use the SOAP API with standard field mapping to preserve original system timestamps and IDs directly.

Answer

Deploy a custom Apex batch process to insert records synchronously in chunks of 2,000 to manage governor limits.

Answer

Utilize Salesforce Data Loader with the serial execution mode to guarantee sequential record processing and prevent locks.

Question 4

Universal Containers experiences frequent 'UNABLE_TO_LOCK_ROW' errors during a nightly data load that updates Account and Opportunity records concurrently. Which TWO architectural strategies should a Data Architect implement to mitigate record locking? (Choose TWO)

Accepted Answer

Modify custom roll-up summary fields and triggers to execute asynchronously or utilize delayed calculation patterns.. Record locking in Salesforce typically occurs when multiple threads attempt to update parent or sibling records simultaneously, such as rolling up values to a parent Account. Reordering the load to process child objects before parents or disabling unnecessary Master-Detail relationships temporarily can significantly reduce contention. Furthermore, optimizing custom triggers and utilizing optimized batch sizes helps maintain transactional isolation and prevents database deadlocks during high-volume operations.

Answer

Sort the CSV input file by parent Account ID so child opportunities referencing the same account are processed in sequential batches.

Answer

Restructure asynchronous processing to utilize serial mode for all high-volume data loads affecting shared parent records.

Answer

Increase the batch size in Data Loader to the maximum allowable limit of 10,000 records to minimize transaction overhead.

Answer

Enable Parallel Processing mode in Bulk API to ensure threads process independent parent hierarchies simultaneously without cross-thread conflicts.

Question 5

Refer to the exhibit. A developer is running a large batch Apex job that updates Account records and their associated Contacts simultaneously. The job frequently fails with the provided error. What is the most effective data management strategy to resolve this locking issue?

Accepted Answer

Implement a retry mechanism using the Database.SaveResult object.. The UNABLE_TO_LOCK_ROW error occurs due to row-level contention, often caused by parent-child record updates happening in parallel threads. By sorting records in the batch scope by ParentId before processing, the architect ensures that all children for a specific account are processed together in the same thread. This minimizes the frequency of multiple threads requesting an exclusive lock on the same parent record simultaneously, thereby significantly reducing contention.

Answer

Increase the batch size to process more records per transaction.

Answer

Convert the batch Apex to a synchronous process to avoid contention.

Answer

Disable all Validation Rules and Triggers during the batch process.

Question 6

A large enterprise is migrating millions of records into Salesforce. To optimize performance and ensure data integrity, the architect must consider best practices for bulk data loading. Which THREE actions should the architect recommend? (Choose three.)

Accepted Answer

Disable Triggers, Validation Rules, and Workflow Rules for the migration duration.. Optimizing data loads requires minimizing the overhead of system processes that trigger during DML operations. By turning off unnecessary automation, using efficient tools like the Bulk API 2.0 with serial mode, and minimizing API call counts, the architect ensures faster processing. These steps prevent record locking, reduce trigger execution time, and keep the migration within governor limits, which is vital for high-volume data operations in production environments.

Answer

Ensure that the integration user has the 'Modify All Data' permission.

Answer

Use the REST API for all records to ensure real-time status updates.

Question 7

Universal Containers maintains 120 million historical order records in an external Oracle database. Executives need to view aggregated order totals per Account inside Salesforce without ingesting the raw rows. The external system can expose a REST endpoint that supports filtering and aggregation. Which Salesforce feature should the Data Architect use to surface these totals on the Account record page with minimal data duplication?

Accepted Answer

Salesforce Connect using an Open Data Protocol (OData) adapter. Salesforce Connect with an OData adapter lets Salesforce display external Oracle data as external objects, so aggregated order totals appear on Account pages without copying 120 million rows into the org. Because filtering and aggregation execute at the external source through the REST endpoint, the design meets the real-time visibility and minimal-duplication requirements while avoiding large storage and sync costs.

Answer

Big Objects with an async SOAP ingestion job

Answer

Standard External Data Source with a Salesforce-to-Salesforce (S2S) connector

Answer

Scheduled Apex callouts writing summary records into a custom object nightly

Question 8

Universal Containers operates a Salesforce org with over 30 million records in a custom object. Users report that list views and reports frequently time out. The Data Architect needs to improve query performance without changing the data model. Which solution should the architect implement?

Accepted Answer

Create a skinny table for the custom object to optimize read performance.. The correct solution is to create a skinny table, which is a custom table that contains a subset of fields from the object, optimized for read-only operations. This reduces the number of joins and improves query performance for reports and list views, especially for objects with millions of records. Skinny tables are a Salesforce-specific feature designed for large data volumes and do not require changing the data model.

Answer

Enable custom indexes on all frequently filtered fields to speed up queries.

Answer

Increase the data storage limit by purchasing additional storage add-ons.

Answer

Configure a delegable permission set to allow users to bypass sharing rules for faster access.

Question 9

Universal Containers has a Salesforce org with 10 million Account records. A data architect needs to ensure that users can search for accounts by a custom text field, Tax_ID__c, which is unique. What is the most efficient way to enable this?

Accepted Answer

Create a custom index on Tax_ID__c.. For a unique custom text field used for lookups on a large object, creating a custom index is the most efficient way to enable fast searches and filters. External ID and 'Allow Search' settings do not provide the same database-level optimization. Formula fields cannot be indexed. Therefore, a custom index directly addresses the performance requirement.

Answer

Mark Tax_ID__c as an external ID and unique.

Answer

Create a formula field that concatenates Tax_ID__c with Account Name and index the formula.

Answer

Enable 'Allow Search' on the field and rely on Salesforce's search engine.

Question 10

Universal Containers has a custom object with a field that contains sensitive data. The Data Architect needs to ensure that the field is encrypted at rest and that only users with the 'View Encrypted Data' permission can see the actual value. Which Salesforce feature should be used?

Accepted Answer

Shield Platform Encryption. Shield Platform Encryption is the correct solution because it provides encryption at rest for data and integrates with the 'View Encrypted Data' permission, allowing only authorized users to see the actual values. It supports both standard and custom fields and is designed for compliance with data privacy regulations.

Answer

Classic Encryption

Answer

Data Masking in Sandboxes

Answer

Field-Level Security

Question 11

Universal Containers is preparing to load 10 million records into a custom object using the Bulk API. The data architect must ensure the load completes successfully and efficiently. Which TWO considerations are most important? (Choose two.)

Accepted Answer

Enable parallel mode to increase throughput.. For large Bulk API loads, choosing the right processing mode is critical. Parallel mode increases throughput but risks lock contention, while serial mode avoids contention and ensures data integrity. The architect must balance these based on data relationships and concurrency. Batch size and disabling logic are less critical, and Bulk API 2.0 is an alternative but not a key consideration for success.

Answer

Use the Bulk API 2.0 for automatic batch sizing.

Answer

Set the batch size to the maximum allowed (10,000 records).

Answer

Disable all validation rules and triggers during the load.

Question 12

A Data Architect needs to ensure that users can access a dashboard that aggregates data from multiple objects, but the data must be filtered based on the running user's role hierarchy. Which dashboard setting should be configured?

Accepted Answer

Enable the 'Filter by Role Hierarchy' option in the dashboard settings.. The 'Filter by Role Hierarchy' option in dashboard settings automatically filters the dashboard data based on the viewing user's position in the role hierarchy. This ensures that users see only the data they are allowed to see according to the organization's sharing model, making it the correct choice for role-based data visibility.

Answer

Set the dashboard to run as the logged-in user.

Answer

Set the dashboard to run as a specified user with the appropriate role.

Answer

Use a dynamic dashboard filter based on a custom field.

Question 13

A data architect at Northern Trail Outfitters needs to ensure that when a Contact is deleted, the related Case records are also deleted to maintain data integrity. The relationship between Contact and Case is a lookup. What should the architect configure to automatically delete child Cases when a Contact is deleted?

Accepted Answer

Change the relationship to a master-detail relationship.. Converting the lookup to a master-detail relationship enables automatic cascading deletion of child Cases when the parent Contact is deleted. This is a declarative, native feature that ensures data integrity without custom code. It is the most straightforward solution, though it may require adjustments to sharing and ownership models.

Answer

Set the lookup relationship to 'Clear the value of this field' on delete.

Answer

Create a before-delete trigger on Contact that deletes related Cases.

Answer

Use a Flow that is triggered on Contact deletion to delete related Cases.

Question 14

Universal Containers is designing a data retention policy for a custom object that stores transactional records. The compliance team requires that records older than 7 years be permanently deleted, and that the deletion process does not impact Salesforce performance. The object currently holds 50 million records, with 10 million older than 7 years. Which solution should a data architect recommend?

Accepted Answer

Configure a scheduled batch job using the Bulk API to delete records older than 7 years.. The scheduled batch job with Bulk API is the most scalable and automated solution for deleting large volumes of records based on a retention policy. It processes records asynchronously, reducing performance impact, and can be scheduled to meet compliance requirements. Other options either lack automation, are error-prone, or cannot handle the volume efficiently.

Answer

Use a before-delete trigger to hard delete records older than 7 years.

Answer

Implement a report-based mass delete using the Recycle Bin.

Answer

Use Data Loader to export and then delete the records in batches.

Question 15

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.