ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 7 - Certified Data Architect discussion

Report
Export

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

A.
Use SOQL queries without WHERE conditions.
Answers
A.
Use SOQL queries without WHERE conditions.
B.
Work with Salesforce Support to enable Skinny Tables.
Answers
B.
Work with Salesforce Support to enable Skinny Tables.
C.
Reduce the number of triggers on Order _c object.
Answers
C.
Reduce the number of triggers on Order _c object.
D.
Make the queries more selective using indexed fields.
Answers
D.
Make the queries more selective using indexed fields.
Suggested answer: B, D

Explanation:

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.

asked 23/09/2024
Ruben Munilla Hernandez
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first