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:

Matthew
9 days ago
A, B, and D are the correct answers. Wildcards and inequality operators can really slow down a query, especially on a large dataset. I'm glad they're testing our understanding of selective SOQL queries.
upvoted 0 times
...
Lashaunda
27 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
28 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
29 days ago
I think using leading % wildcards prevents a query from being selective.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77