U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Plat-Arch-201 Exam - Topic 3 Question 6 Discussion

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers
B) Work with Salesforce Support to enable Skinny Tables. and D) Make the queries more selective using indexed fields.
A) Use SOQL queries without WHERE conditions.
C) Reduce the number of triggers on Order _c object.

Salesforce Plat-Arch-201 Exam - Topic 3 Question 6 Discussion

Actual exam question for Salesforce's Plat-Arch-201 exam
Question #: 6
Topic #: 3
[All Plat-Arch-201 Questions]

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Show Suggested Answer Hide Answer
Suggested Answer: B, D

To improve the performance of SOQL queries that retrieve data from the Order_c object, the data architect should work with Salesforce Support to enable Skinny Tables and make the queries more selective using indexed fields. Skinny Tables are custom tables that contain frequently used fields and are kept in sync with the base tables3. They can improve performance by reducing the number of table joins and using indexes. Making the queries more selective using indexed fields can also improve performance by reducing the query execution time and avoiding query timeouts4. The other options are not effective or recommended for improving SOQL performance.


by Lashaunda at May 17, 2026, 07:13 AM

Limited Time Offer

25%

Off

Get Premium Plat-Arch-201 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rikki
1 month ago
I remember discussing the importance of using indexed fields to make queries more selective. That seems like a solid choice here.
upvoted 0 times
...

Save Cancel