Exam Certified Platform Developer II topic 1 question 134 discussion

ACE https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_infrastructure_indexes.htm

ACD but E could be correct also if it actually means RecordtypeID standard field with label Recordtype https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_infrastructure_indexes.htm

LastModifiedDate field not indexed by default : https://help.salesforce.com/s/articleView?id=000328726&type=1

http://resources.docs.salesforce.com/194/0/en-us/sfdc/pdf/salesforce_query_search_optimization_developer_cheatsheet.pdf

ACD The platform automatically maintains indexes on the following fields for most objects. RecordTypeId Division CreatedDate Systemmodstamp (LastModifiedDate) Name Email (for contacts and leads) Foreign key relationships (lookups and master-detail) The unique Salesforce record ID, which is the primary key for each object Salesforce also supports custom indexes on custom fields, with the exception of multi-select picklists, text area (long), text area (rich), non-deterministic formula fields, and encrypted text fields. External IDs cause an index to be created on that field, which is then considered by the Force.com query optimizer. External IDs can be created on only the following fields. Auto Number Email Number Text To create custom indexes for other field types, including standard fields, contact salesforce.com Customer Support