ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 217 - Certified Platform Developer II discussion

Report
Export

Consider the following queries. For these queries, assume that there are more than 200,000 Account records. These records include soft-deleted records; that is, deleted records that are still in the Recycle Bin. Note that there are two fields that are marked as External Id on the Account. These fields are Customer_Number__c and ERP_Key__c.

Which two queries are optimized for large data volumes? Choose 2 answers

A.
SELECT Id FROM Account WHERE Id IN : aListVariable
Answers
A.
SELECT Id FROM Account WHERE Id IN : aListVariable
B.
SELECT Id FROM Account WHERE Name != ' ' AND IsDeleted = false
Answers
B.
SELECT Id FROM Account WHERE Name != ' ' AND IsDeleted = false
C.
SELECT Id FROM Account WHERE Name != NULL
Answers
C.
SELECT Id FROM Account WHERE Name != NULL
D.
SELECT Id FROM Account WHERE Name != ' ' AND Customer Number c = 'ValueA'
Answers
D.
SELECT Id FROM Account WHERE Name != ' ' AND Customer Number c = 'ValueA'
Suggested answer: A, D
asked 23/09/2024
Andrey Zhukovskiy
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first