Salesforce Certified Platform Data Architect (Plat-Arch-201) Exam - Topic 5 Question 75 Discussion

Actual exam question for Salesforce's Salesforce Certified Platform Data Architect (Plat-Arch-201) exam

Question #: 75
Topic #: 5

[All Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions]

A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

AMake sure the query doesn't contain NULL in any filter criteria.

BCreate a formula field instead of having multiple filter criteria.

CCreate custom indexes on the fields used in the filter criteria.

DModify the integration users' profile to have View All Data.

Show Suggested Answer

Suggested Answer: A, C

Making sure the query does not contain NULL in any filter criteria can avoid full table scans and leverage indexes more efficiently. Queries with NULL filters are not selective and can cause performance issues. Creating custom indexes on the fields used in the filter criteria can also enhance the query performance by reducing the number of records to scan.

by Jame at Apr 10, 2026, 01:49 PM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Penney

3 days ago

I remember something about indexing being crucial for performance, so maybe C is a good choice.

upvoted 0 times

...