Exam Certified Platform Developer II topic 1 question 307 discussion

Actual exam question from Salesforce's Certified Platform Developer II

Question #: 307
Topic #: 1

[All Certified Platform Developer II Questions]

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 two.)

A. SELECT Id FROM Account WHERE Name != '' AND IsDeleted = false
B. SELECT Id FROM Account WHERE Id IN :aListVariable
C. SELECT Id FROM Account WHERE Name != '' AND Customer_Number＿c = 'ValueA'
D. SELECT Id FROM Account WHERE Name != NULL

Show Suggested Answer

Suggested Answer: BC 🗳️

by AppleDash at Feb. 26, 2023, 7:28 p.m.

Comments

Submit Cancel

rufusroffie

8 months ago

Selected Answer: BC

A is not good, because isDeleted is not indexed and != ' ' will not use index to search, general you want to avoid field != ' '; any negative comparison is discouraged unless there's second SELECT cause which is indexed; B is good, because you are SELECTing from a range of ID which lower the amount of records it searches; C is good, because even though first clause is bad, second one makes it very Selective because the field is indexed; D is bad because negative comparison is not encouraged

upvoted 4 times

...

AppleDash

8 months ago

BC https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_SOQL_VLSQ.htm

upvoted 1 times

...

Exam Certified Platform Developer II All Questions

View all questions & answers for the Certified Platform Developer II exam

Exam Certified Platform Developer II topic 1 question 307 discussion

Comments

rufusroffie

AppleDash

SY0-701