PD1 SOQL and SOSL 3

Question 1

What is the governor limit for total records retrieved via SOQL in a single synchronous Apex transaction?

Accepted Answer

50,000 records

Answer

Salesforce limits synchronous Apex transactions to retrieving a total of 50,000 records across all SOQL queries.

Question 2

Why is placing a SOQL query inside a for loop considered an anti-pattern in Apex?

Accepted Answer

It causes repeated query executions that quickly exceed the 100 SOQL query governor limit

Answer

Placing SOQL inside a for loop executes a new query on every iteration, rapidly consuming the 100 SOQL query governor limit.

Question 3

Which SOQL for loop syntax is the most memory-efficient for processing large record sets in Apex?

Accepted Answer

for (List<Account> batch : [SELECT Id FROM Account])

Answer

The List<sObject> SOQL for loop processes records in batches of 200, avoiding loading all records into heap memory at once.

Question 4

What does the WITH SECURITY_ENFORCED clause in a SOQL query enforce?

Accepted Answer

It throws a QueryException if the running user lacks field-level or object-level read access

Answer

WITH SECURITY_ENFORCED throws a QueryException if the running user does not have read access to any field or object referenced in the query, enforcing FLS and CRUD.

Question 5

What is the purpose of the OFFSET clause in a SOQL query?

Accepted Answer

It specifies the starting row number from which to return query results, enabling pagination

Answer

The OFFSET clause skips the specified number of records in the result set, enabling pagination when combined with LIMIT (e.g., LIMIT 10 OFFSET 20 retrieves records 21–30).

(PD1) Salesforce Certified Platform Developer 1 Practice Test

(PD1) Salesforce Certified Platform Developer 1 Practice Test

PD1 SOQL and SOSL 3