SF-Data-Arch Large Data Volume Considerations — 10 Questions

Question 1

Refer to the exhibit. A batch process updating 50,000 records frequently fails with the error shown. Which design change resolves this contention?

Accepted Answer

Group records by parent ID before processing.. The UNABLE_TO_LOCK_ROW error occurs when multiple threads attempt to update the same record or its parents simultaneously. By reordering the records to group them by parent ID before processing, you ensure that all children belonging to the same parent are updated in the same transaction or sequence, minimizing the duration and frequency of cross-thread lock contention on parent records.

Answer

Implement a retry mechanism using a custom setting.

Answer

Change the batch size to 1.

Answer

Disable all sharing rules on the object.

Question 2

An organization faces performance issues querying a large custom object. Which condition makes a SOQL query non-selective, forcing a full table scan?

Accepted Answer

The filter condition includes a leading wildcard on a text field.. A query is non-selective if the filter criteria do not use an indexed field, or if the filter is too broad, hitting more than the threshold of records (typically 300,000). Full table scans occur when the query engine cannot utilize indexes to narrow the search, leading to extreme latency. Proper indexing and selective filters are essential for maintaining performance on objects with millions of rows.

Answer

Using a filter on a custom indexed field.

Answer

The query returns fewer than 100,000 records.

Answer

The object has fewer than 100,000 records total.

Question 3

Which THREE factors influence the performance of a Salesforce object containing 50 million records?

Accepted Answer

The number of active indexes on the object.. Large Data Volume performance is influenced by indexing strategies, the complexity of triggers/automations, and the selectivity of SOQL queries. Efficient indexing speeds up retrieval, while optimized automation prevents excessive resource usage per DML operation. Finally, selective queries prevent full table scans, ensuring that the database engine can efficiently locate records without scanning the entire dataset, which is crucial for maintaining responsiveness at scale.

Answer

The total number of fields on the object.

Answer

The color scheme of the Lightning app.

Question 4

A company needs to archive 10 million records annually. What is the recommended best practice for archiving to maintain Salesforce performance?

Accepted Answer

Use the Bulk API to delete records once a year.. Archiving records to an external data store (like Heroku Postgres or AWS) removes them from the Salesforce production environment, which keeps the active dataset lean. This maintains query performance and ensures that the production org stays well within performance guidelines. Periodically exporting and deleting data is a standard lifecycle management task for high-volume Salesforce organizations to ensure sustained operational efficiency.

Answer

Move records to a custom Archive object within Salesforce.

Answer

Change the record ownership to a generic user.

Answer

Use Salesforce Data Masking to hide the records.

Question 5

A company is experiencing slow performance when performing bulk updates on the Opportunity object, which contains 10 million records. The updates trigger complex Apex logic and multiple flows. What is the most effective architectural strategy to optimize this process?

Accepted Answer

Offload processing logic to an asynchronous execution framework like Platform Events.. Decoupling logic using an asynchronous pattern is essential for high-volume data operations. By moving processing to a platform event or a queueable Apex job, you reduce the immediate transaction load and avoid hitting governor limits. This approach improves system responsiveness and allows the platform to process records in smaller, manageable batches, which is critical for maintaining performance integrity when dealing with massive datasets in the Salesforce multi-tenant environment.

Answer

Increase the batch size in the Data Loader settings to the maximum of 10,000.

Answer

Implement a custom indexing strategy on all fields used in filter criteria.

Answer

Disable all Validation Rules and Apex Triggers before the update process.

Question 6

An organization is planning to migrate 50 million records into Salesforce. Which TWO practices should be prioritized to ensure optimal data load performance?

Accepted Answer

Enable 'Parallel Processing' in Data Loader settings.. Efficient data loading requires minimizing the overhead of platform automation and maximizing the effectiveness of Salesforce APIs. By disabling unnecessary features that trigger upon record creation and utilizing parallel processing, the system can commit records faster and with fewer interruptions. These steps ensure that the data migration process adheres to platform resource constraints while achieving the throughput required for such large volumes.

Answer

Keep all Triggers and Flows active to ensure data quality.

Answer

Perform the load during peak business hours for real-time monitoring.

Answer

Insert all records in a single batch to minimize transaction count.

Question 7

Which THREE factors should be considered when implementing a 'Skinny Table' to improve performance?

Accepted Answer

Skinny tables eliminate the need for joins in complex queries.. Skinny tables are a specialized performance tool designed to reduce the need for joins between tables. Because they are not updated automatically by standard operations like other tables, they require careful maintenance. Their implementation is specifically targeted at read-heavy environments where query performance is critical for large objects, and they must be requested via Salesforce support to ensure they are architected correctly for the specific object and field set.

Answer

Skinny tables are maintained automatically by Salesforce.

Answer

They are ideal for frequently updated, transactional objects.

Question 8

Refer to the exhibit. The query above is performing poorly on an object with 50 million records. What is the most likely cause of the performance issue?

Accepted Answer

The index on OwnerId is not selective enough for the query.. The query filters on two fields, 'CreatedDate' and 'OwnerId', but the query optimizer may not be selecting the most selective index. In Salesforce, if an index is not sufficiently selective (i.e., it returns too many records), the system will ignore it and perform a full table scan. With 50 million records, the selectivity threshold is crucial. Ensuring that the filters target indexed fields and that those indexes are selective is vital.

Answer

The query is selecting too many fields.

Answer

The query lacks a ORDER BY clause.

Answer

The query is missing a LIMIT clause.

Question 9

Refer to the exhibit. A developer is receiving this error in a synchronous Apex controller when querying an object with 10 million records. What is the correct architectural change?

Accepted Answer

Use Batch Apex to process the records in smaller chunks.. The error occurs because synchronous Apex has a governor limit of 50,000 records that can be queried in a single transaction. For objects with millions of records, querying them all at once is not feasible. The architecture must be updated to use batch processing or paginated result sets, allowing the application to process data in chunks that fit within the platform's execution constraints, ensuring reliability at scale.

Answer

Increase the limit in the Organization-Wide settings.

Answer

Wrap the query in a try-catch block to ignore the error.

Answer

Disable the governor limit for the specific user.

Question 10

When designing an integration to sync data from an external ERP into Salesforce, which strategy best handles a sudden spike of 1 million records?

Accepted Answer

Use the Bulk API 2.0 to load the data in batches.. For high-volume spikes, the integration should use an asynchronous, queue-based approach rather than direct, synchronous API calls. By pushing the data into a staging object or a message queue, the system can process the records incrementally. This prevents the integration from overwhelming the Salesforce API or hitting governor limits, ensuring that the data is eventually consistent without degrading real-time system performance for end-users.

Answer

Use the REST API to send records one by one.

Answer

Directly update the Salesforce database using a JDBC driver.

Answer

Trigger a custom Apex class to perform a callout to the ERP.