Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Platform Developer II All Questions

View all questions & answers for the Certified Platform Developer II exam
Go to Exam

Exam Certified Platform Developer II topic 1 question 295 discussion

Actual exam question from Salesforce's Certified Platform Developer II
Question #: 295
Topic #: 1
[All Certified Platform Developer II Questions]

Users complain that a page is very slow to respond. Upon investigation, the query below is found to perform slowly.



Which two actions can a developer take to improve performance? (Choose two.)

  • A. Make the CustomField_c field an External ID.
  • B. Make the field CustomField_c required because Salesforce field indexes do not include nulls.
  • C. Add a LIMIT clause to the query to reduce the number of records returned.
  • D. Contact Salesforce customer support to create a custom index to include null values.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by stan_malta at Nov. 12, 2023, 5:32 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
FriedConsole2000
8 months, 4 weeks ago
Selected Answer: CD
https://salesforce.stackexchange.com/questions/367157/custom-indexes-of-null-records#:~:text=By%20default%2C%20the%20index%20tables%20do%20not%20include,rebuild%20them%20to%20get%20the%20empty-value%20rows%20indexed.
upvoted 1 times
...
FriedConsole2000
8 months, 4 weeks ago
Selected Answer: AC
Answer is A and C. It is fine to create a External Id just for an index.
upvoted 1 times
FriedConsole2000
8 months, 4 weeks ago
Oh I was wrong. https://salesforce.stackexchange.com/questions/367157/custom-indexes-of-null-records#:~:text=By%20default%2C%20the%20index%20tables%20do%20not%20include,rebuild%20them%20to%20get%20the%20empty-value%20rows%20indexed.
upvoted 1 times
...
...
stan_malta
1 year ago
Selected Answer: CD
It's not good practice to mark fields as External IDs which are actually not External IDs, and Salesforce Support does create indexes with null values
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel