Salesforce Certified Sales Cloud Consultant — Question 203

Cloud Kicks has 300,000 account records and 16 million invoices in a custom object with a master-detail relationship to the Account. Each account record takes a long time to display due to the rendering time of the invoice related list.

What should the consultant do to reduce the amount of time to load the page?

Answer options

• A. Move the invoice related list to a separate tab on the Lightning page.
• B. Convert the Invoice object into a lookup relationship.
• C. Enable indexing on all visible fields on the invoice related list.
• D. Purge the recycling bin to decrease the number of records queried.

Correct answer: C

Explanation

Enabling indexing on all visible fields in the invoice related list can significantly improve query performance, making it the best solution to reduce the rendering time. Moving the related list to a separate tab (option A) does not actually address the underlying performance issue. Converting to a lookup relationship (option B) could change data integrity rules and may not enhance performance. Purging the recycling bin (option D) is unlikely to have a meaningful impact on the query performance for the invoice records.