DATA-ARCHITECT Question 12

Question

The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field: SELECT ID, Description, subject FROM Task WHERE WhatID != NULL When the data architect uses the query to select values for a process, a time-out error occurs. What does the data architect need to change to make this query more performant?
A. Change the WHERE clause to filter by a deterministic defined value.
B. Change query to SOSL.
C. Remove description from the requested field set.
D. Add LIMIT 100 to the query.

Accepted Answer

Marked answer: A. Change the WHERE clause to filter by a deterministic defined value.

DATA-ARCHITECT Question 12

Community Discussion

Preparing Practice Exam…

DATA-ARCHITECT Question 12

Community Discussion