DATA-ARCHITECT practice question 26 of 35
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…
Full set: 257 questionsFor a custom object expected to grow to millions of records, SOQL query performance is critical. The two most effective strategies are making queries selective and using platform features like skinny tables. A selective query uses an indexed field in the WHERE clause to drastically reduce the number of records the database must scan. For frequently run reports and queries that involve joins or specific field combinations, a skinny table is a custom index created by Salesforce Support that contains copies of the data, providing a much faster retrieval path.
A. Queries without WHERE conditions, or with non-selective ones, cause full table scans, which is the primary cause of poor performance on large objects.
C. Triggers primarily impact DML performance (insert, update, delete), not the performance of standalone SOQL read queries, which is the focus of the question.
1. Salesforce Developer Documentation, Query & Search Optimization Cheat Sheet: "Make your queries selective." The document explicitly states that selectivity is the most important factor for query performance on large data volumes.
2. Salesforce Developer Documentation, Designing Record-Level Access for Enterprise Scale: Under the "Skinny Tables" section, it states, "For some frequently accessed fields, Salesforce can create a skinny table to improve performance on reports, list views, and SOQL queries."
3. Salesforce Architects, Salesforce Well-Architected - Data: Large Data Volumes: This guide details best practices for handling large data volumes, highlighting the importance of selective queries with indexed fields and the use of skinny tables as key performance optimization techniques.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
