SAA Application Performance & Scalability

Question 1

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

Accepted Answer

100

Answer

50

Answer

150

Answer

200

Question 2

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

Accepted Answer

Skinny Tables

Answer

External Objects

Answer

Custom Indexes

Answer

Platform Cache

Question 3

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

Accepted Answer

Batch Apex

Answer

Queueable Apex

Answer

Future Methods

Answer

Scheduled Apex alone

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

50

Answer

2000

Answer

10000

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

Custom Settings

Answer

External Cache

Answer

Static Resources

Question 6

A SOQL query is considered 'selective' when it uses indexed fields in the WHERE clause. Why is selectivity critical for Large Data Volume orgs?

Accepted Answer

It prevents full table scans that degrade query performance

Answer

It reduces API call counts

Answer

It enables skinny table creation

Answer

It bypasses sharing rules

Question 7

What is the maximum CPU time limit per Apex transaction in synchronous contexts?

Accepted Answer

10,000 ms

Answer

5,000 ms

Answer

15,000 ms

Answer

60,000 ms