A telecommunications company has a custom object 'Call_Detail_Record__c' with 100 million records. A developer wrote a synchronous Apex trigger that queries all related call detail records for an account and performs complex calculations. The trigger frequently fails with a CPU time limit exceeded error. What is the most appropriate architectural change?

Optimize the SOQL query in the trigger to use a more selective filter.

Use a Queueable Apex job to perform the calculation in a single asynchronous execution.

Move the calculation logic to a Batch Apex job that processes the call detail records asynchronously.

Increase the CPU time limit for the trigger in the org settings.

Which data modeling choice can help mitigate the impact of data skew?

Using a lookup relationship instead of a master-detail relationship

Using a master-detail relationship for the skewed object

Adding more fields to the parent object

SalesforceCertified Technical Architect

Domain 3Objective 1

Given a Scenario, Describe the Platform Architecture Considerations, Platform Impact and Optimization Methods Used When Working with Large Data Volumes. TECHNICAL-ARCHITECT Practice Questions (Page 3)

Part of the DATA domain, which makes up ~8% of our current practice bank.

22questions here

5free pages

10concepts

10 Concepts in This Objective

Platform Architecture for LDV
Data Storage and Indexing
Query Optimization Techniques
Data Skew and Distribution
Architectural Patterns for LDV
Performance Monitoring and Tuning
Impact on Limits and Governor Limits
Asynchronous Processing and Batch
Data Modeling for Scalability
Optimization Methods for LDV

Questions 11–15

11foundation · easy
What is the heap size limit for Apex in a synchronous transaction?
Select an answer first
12application · medium
A telecommunications company has a custom object 'Call_Detail_Record__c' with 100 million records. A developer wrote a synchronous Apex trigger that queries all related call detail records for an account and performs complex calculations. The trigger frequently fails with a CPU time limit exceeded error. What is the most appropriate architectural change?
Select an answer first
13foundation · easy
Which governor limit is most likely to be exceeded when processing a large number of records in a single transaction?
Select an answer first
14foundation · easy
Which data modeling choice can help mitigate the impact of data skew?
Select an answer first
15foundation · easy
Which architectural pattern involves moving older or inactive records out of the primary object to improve performance?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to TECHNICAL-ARCHITECT

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “TECHNICAL-ARCHITECT” is a trademark of its owner, used for identification only.

Given a Scenario, Describe the Platform Architecture Considerations, Platform Impact and Optimization Methods Used When Working with Large Data Volumes. TECHNICAL-ARCHITECT Practice Questions (Page 3)

Questions 11–15

What is the heap size limit for Apex in a synchronous transaction?

Which governor limit is most likely to be exceeded when processing a large number of records in a single transaction?

Which data modeling choice can help mitigate the impact of data skew?

Which architectural pattern involves moving older or inactive records out of the primary object to improve performance?

Keep studying — DATA