Salesforce Certified Platform Data Architect Practice Questions

Salesforce Certified Platform Data Architect exam preparation

Salesforce Certified Platform Data Architect practice questions in English: 177 questions with explanations. The mock exam has 60 questions and 105 minutes.

Salesforce Certified Platform Data Architect free question 9 / 10 · Domain 5: Large Data Volume Considerations

You deleted 2 million old cases with an ordinary delete that sends them to the Recycle Bin. Afterward, case reports and list views are still not as fast as expected. Which view matches the description of deletion in the large data volume best practices?

  1. Deleted records stay flagged as deleted and must be excluded from queries, which affects performance
  2. Records in the Recycle Bin are excluded from queries, so they have no effect on performance
  3. Records in the Recycle Bin remain in the database until a user empties it, however long that takes
  4. Deleted records are removed from the database on the spot, so the slowness comes from somewhere else
Show the answer and explanation

Answer: A

Why this is correct
The large data volume best practices say that, instead of removing the data, Salesforce flags it as deleted and makes it visible through the Recycle Bin, a process called soft deletion. While the data is soft deleted it still affects database performance because it is still resident, and deleted records have to be excluded from any queries. For large volumes, the guide recommends the Bulk API 2.0 hard delete function.

Why the other options are wrong
"Deleted records are removed from the database on the spot, so the slowness comes from somewhere else" … The guide says Salesforce flags the data as deleted rather than removing it. The records are still in the database.
"Records in the Recycle Bin are excluded from queries, so they have no effect on performance" … The guide says soft-deleted data still affects database performance because it is still resident, and deleted records have to be excluded from any queries.
"Records in the Recycle Bin remain in the database until a user empties it, however long that takes" … The guide says records are removed permanently once a set number of days passes, once the Recycle Bin reaches a set size, or when it is emptied through the UI, API, or Apex. They are not kept indefinitely.

Where people trip
Disappearing from the screen is not the same as disappearing from the database. If you want performance back after a large delete, check which deletion method you used.

Go to the Salesforce Certified Platform Data Architect practice app (10 free questions; purchase unlocks all questions)

See the full practice set