Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Exam Data Architect Topic 4 Question 40 Discussion

Actual exam question for Salesforce's Data Architect exam
Question #: 40
Topic #: 4
[All Data Architect Questions]

Universal Containers has a custom object with millions of rows of data.

When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

Show Suggested Answer Hide Answer
Suggested Answer: B

Creating validation rules to check if the required attributes are entered is the best option to mandate this when customers are created in Salesforce. Validation rules allow you to specify criteria that must be met before a record can be saved. You can use validation rules to ensure that customers have a first name, last name, and email when they are created in Salesforce. This way, you can prevent incomplete or invalid data from being sent to your MDM solution.


Contribute your Thoughts:

Lashaunda
6 days ago
I believe using a custom index on a deterministic formula field can actually help make the query more selective.
upvoted 0 times
...
Ahmed
7 days ago
I agree with Lanie. Using trailing % wildcards and performing large loads and deletions also make the query non-selective.
upvoted 0 times
...
Lanie
8 days ago
I think using leading % wildcards prevents a query from being selective.
upvoted 0 times
...

Save Cancel