DATA-ARCHITECT practice question 1 of 35
Which three characteristics of a skinny table help improve report and query performance?
Full set: 257 questionsSkinny tables are a performance-tuning feature created by Salesforce Support to optimize queries on objects with millions of records. They work by creating a separate, narrower database table that contains a subset of frequently used fields, including fields from a parent object to avoid costly joins (A). Salesforce automatically keeps this table synchronized with the source data (D). Crucially, skinny tables do not contain soft-deleted records (records in the Recycle Bin), which makes queries more efficient as they don't need to filter these records out (E).
B. Skinny tables are not a mechanism for creating indexes on multi-select picklist fields; custom indexes are a separate feature.
C. While a skinny table can provide a "view" across objects, option A is more precise by stating the mechanism: it helps avoid joins, which is the direct source of the performance gain.
1. Salesforce Developer Documentation, "Best Practices for Deployments with Large Data Volumes", Section: "Use Skinny Tables to Improve Performance". This document states, "Skinny tables can contain frequently used fields and avoid joins...", "Skinny tables are kept in sync with their source tables...", and "Skinny tables don’t include soft-deleted records...".
2. Salesforce Help, "Reduce Report Timeouts", Section: "Ask Salesforce to create a skinny table". This article confirms that skinny tables "combine frequently accessed fields into a single table to avoid joins" and are "kept in sync with the source table".
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 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…
- Question 7Universal container (UC) would like to build a Human resources application on Salesforce …
