Which two queries are optimized for large data volumes?

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
B. SELECT Id FROM Account WHERE Name != ‘ ‘ AND IsDeleted = false
C. SELECT Id FROM Account WHERE Name != NULL
D. SELECT Id FROM Account WHERE Name != ‘ ‘ AND Customer Number c = ‘ValueA’

How To Pass Certified Platform Developer II Exam?

Certified Platform Developer II PDF dumps.

High quality Certified Platform Developer II pdf and software. VALID exam to help you pass.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.