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

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.)
A . Make sure the query doesn’t contain NULL in any filter criteria.
B . Create a formula field instead of having multiple filter criteria.
C . Create custom indexes on the fields used in the filter criteria.
D . Modify the integration users’ profile to have View All Data.

View Answer

Answer: A,C