SAA Application Performance & Scalability

Question 1

What is the maximum number of SOQL queries allowed per Apex transaction in Salesforce?

Accepted Answer

100

Answer

Salesforce enforces a governor limit of 100 SOQL queries per synchronous Apex transaction.

Question 2

Which Salesforce feature creates a separate, leaner copy of a large object table to improve query performance?

Accepted Answer

Skinny Tables

Answer

Skinny tables are Salesforce-maintained copies of standard or custom object tables that include only frequently queried fields, significantly improving read performance on large data volumes.

Question 3

An Apex transaction needs to process 500,000 records nightly. Which Apex pattern is most appropriate?

Accepted Answer

Batch Apex

Answer

Batch Apex is designed for processing large volumes of records by breaking them into manageable chunks, each with its own governor limit context.

Question 4

What is the recommended optimal batch size when using Batch Apex to avoid SOQL row limit errors while maximizing throughput?

Accepted Answer

200

Answer

A batch size of 200 is the default and generally optimal, balancing governor limits (such as 50,000 SOQL rows) against processing efficiency.

Question 5

Which Salesforce feature allows caching of frequently accessed data at the org, session, or partition level to reduce repeated database queries?

Accepted Answer

Platform Cache

Answer

Platform Cache provides a dedicated caching layer in Salesforce at org or session scope, reducing redundant SOQL queries and improving application performance.

(SAA) Salesforce Application Architect Certification Practice Test

(SAA) Salesforce Application Architect Certification Practice Test

SAA Application Performance & Scalability